Out of Memory Errors (Office 97 SR-2)

Topic

New Reply

We are having an increasing number of people that are getting

Reply | Quote

Replies

Excess meaning too many or not utilized?

Cheers

Reply | Quote

Too Many

Reply | Quote

A large number of styles can cause memory problems with Excel.
Almost any format change affects memory.
Take a look at the following link for lots of info on Excel and memory.

http://www.decisionmodels.com/memlimitsc.htm%5B/url%5D

If you still need it, after reviewing the above , I have an Excel 97 Add-in that removes
custom number formats and styles. Advise if you are interested.

Jim Cone
San Jose, CA

Reply | Quote

How many is too many?

Curious

Reply | Quote

I ran into one of those several days ago. Our problem was a large number (~100) graphs spread across 20 worksheets. We found this KB entry Q168650. It explained that with a certain defaultm, each graph required 2 font entries. It defines a reg hack that drops it to 1 font entry per graph. It goes on to explain that there is a fixed max of 256 fonts in Excel 97. Even though all graphs may be using the same font they each need their own entry. The reg hack have us 100 more possable graphs which allows the user to finish the project Hope this helps

Reply | Quote

You can get rid of obsolote styles by exporting the file to HTML format and reading it back.

Reply | Quote

Jan Karel,

That might work in XL2000- but XL 97 “Save AS HTML” gives an entirely different result. So much so that I still use XL97 to save as a simple HTML where I can edit and make changes. XL2000 saves graphs, macros, formats- and a whole heap of things which are not saved in XL97.

Riknowoi might be able to post the troublesome spreadsheet, and have a helpful lounger convert it to XL2000 HTML and back to xls.

Reply | Quote