Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Location
    Indiana
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Out of Memory Errors (Office 97 SR-2)

    We are having an increasing number of people that are getting

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Out of Memory Errors (Office 97 SR-2)

    Excess meaning too many or not utilized?

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    New Lounger
    Join Date
    Apr 2002
    Location
    Indiana
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Out of Memory Errors (Office 97 SR-2)

    Too Many

  4. #4
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Out of Memory Errors (Office 97 SR-2)

    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

    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

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Out of Memory Errors (Office 97 SR-2)

    How many is too many?

    Curious
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  6. #6
    New Lounger
    Join Date
    Apr 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Out of Memory Errors (Office 97 SR-2)

    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

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Out of Memory Errors (Office 97 SR-2)

    You can get rid of obsolote styles by exporting the file to HTML format and reading it back.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Out of Memory Errors (Office 97 SR-2)

    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.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •