big Excel file crashes Excel

瀏覽次數:3 次
跳到第一則未讀訊息

Michael Dirksen

未讀,
2002年1月25日 下午3:07:202002/1/25
收件者:
Hello!
I made an Excel file, of a size about 63 MB. I could store it, but
after closing Excel I was not able to open it again. Excel crashes
with the statement "Not enough memory" . The system has enough memory
(512 MB) and the task amnager states that still 200 MB of phsikal
memory are free. My system: Office 2000 service pack 1 windows NT4,
512 MB RAM Any Idea how to open the file and work with it?
thank you very much
MIchael

David McRitchie

未讀,
2002年1月25日 下午4:08:202002/1/25
收件者:
Hi Michael ,
You have about as much RAM memory left as I have HD space left.

The memory referred to may be graphical memory, used up
by buttons, fonts, hyperlinks (not HYPERLINK Worksheet Functions),
graphs.

More information in
Slow Response
http://www.mvps.org/dmcritchie/excel/slowresp.htm
and at Charles Williams site (see links on above page).

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Macros: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


"Michael Dirksen" <dir...@hrz2.hrz.tu-darmstadt.de> wrote in message news:3C51BAF8...@hrz2.hrz.tu-darmstadt.de...

Alan

未讀,
2002年1月25日 下午5:02:482002/1/25
收件者:
My thought is - are you trying to use Excel where a database would be a
better solution? What version of Excel are you using? Oldver versions may
not be able to handle the amounts of memory that we deem as normal these
days...


"Michael Dirksen" <dir...@hrz2.hrz.tu-darmstadt.de> wrote in message
news:3C51BAF8...@hrz2.hrz.tu-darmstadt.de...

Charles Williams

未讀,
2002年1月25日 晚上7:34:252002/1/25
收件者:
Hi Michael,
There is a limit, about 64MB filesize~~80MB memory.

try getting rid of all add-ins, personal.xls etc and you may be able to open
it.
Excel 2002 (XP) can open much larger files (approx 2x larger).
hth
Charles Williams
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com


回覆所有人
回覆作者
轉寄
0 則新訊息