Excel File Size & Memory Limitations? How best to proceed?
Excel File Size & Memory Limitations? How best to proceed?
(OP)
Am developing a workbook to perform some engineering analysis and design calculations.
It is linked to a multisheet set of datatables.
Contains about 16 sheets, and these have about 28 embedded charts. A number of the sheets contain vba code pages to iterate to a solution on each calculate event. Being developed in Excel97 and WinNT with occaisional review in Excel 2000 and WinME. Ever since its being hovering around 1MB in size the file has been very temperamental, with spurious strange excel behaviour cropping up from time to time. Reverting to a recent backup and restarting Excel cures these problems. Other problems, such as "Out of Memory" occur, (especially when editing charts from user interface -editing by macro seems to be OK though) and files saved after this occurs seem to have permenant damage. Once again frequent backups save the day.
Even though both NT and ME seem to have plenty of physical/virtual memory unused, excel does not seem to be able to make use of it.
Is there something I can do to make more memory available to Excel?
Would I be better to develop a string of a larger number of (smaller) linked files, rather than few (larger) files?
It is linked to a multisheet set of datatables.
Contains about 16 sheets, and these have about 28 embedded charts. A number of the sheets contain vba code pages to iterate to a solution on each calculate event. Being developed in Excel97 and WinNT with occaisional review in Excel 2000 and WinME. Ever since its being hovering around 1MB in size the file has been very temperamental, with spurious strange excel behaviour cropping up from time to time. Reverting to a recent backup and restarting Excel cures these problems. Other problems, such as "Out of Memory" occur, (especially when editing charts from user interface -editing by macro seems to be OK though) and files saved after this occurs seem to have permenant damage. Once again frequent backups save the day.
Even though both NT and ME seem to have plenty of physical/virtual memory unused, excel does not seem to be able to make use of it.
Is there something I can do to make more memory available to Excel?
Would I be better to develop a string of a larger number of (smaller) linked files, rather than few (larger) files?





RE: Excel File Size & Memory Limitations? How best to proceed?
RE: Excel File Size & Memory Limitations? How best to proceed?
http://support.microsoft.com/support/kb/articles/Q168/6/50.ASP
RE: Excel File Size & Memory Limitations? How best to proceed?
http://support.microsoft.com/support/kb/articles/Q167/0/79.ASP
Am I the only one who finds it frustrating that Excel limits you to 256 columns in a worksheet?
RE: Excel File Size & Memory Limitations? How best to proceed?
http://support.microsoft.com/support/kb/articles/Q168/6/50.ASP
http://support.microsoft.com/support/kb/articles/Q167/0/79.ASP
then I would suggest that you have a far-heap corrupt. This can occur when your app requests more stack space than memory has allocated as available.
Program a Hook at the stack-request and insert a pause-message that displays current memory states. This may isolate your problem to a specific excel object which can be modified to eliminate the problem.
If this is above your skill level, eMail me the sheet zipped and I'll check it for you.
StackCheckE-tips770-12656@builderspost.com
RE: Excel File Size & Memory Limitations? How best to proceed?
The MS KB articles referenced, and a few others, do not, I think, exactly apply to my problem, but are fairly close and point out a few pitfalls to be avoided.
More feedback welcome.
Ctruax's approach seems promising. I often have files which by deduction have a faulty component that is hard to pin point...
I will seek his or her help!
RE: Excel File Size & Memory Limitations? How best to proceed?
Narendranath R
narenr@narendranath.itgo.com
http://www.narendranath.itgo.com
Pipeline engineering is made easy with state of the art computer software, visit www.narendranath.itgo.com.