Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Middelburg, Zeeland, Netherlands
    Posts
    165
    Thanks
    20
    Thanked 2 Times in 2 Posts

    Speed and Large (2000)

    Hi,
    We have a problem with large sheets for over 50 Mb. When trying to calculate Excel throws me out. Without leaving any trace of the file I was working with.
    Furthermore, it takes a long time to calculate sheets somewhat under 50 Mb.
    The question is: how to overcome this?
    The notebook I'm working on is an Intel PIV 1,8 with 256 Mb (and yes, defragmented by Diskeeper all day long).
    There's plenty of HD-space.
    TIA
    George

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Speed and Large (2000)

    Can you describe what is in the spreadsheet that makes it 50mb? Is the workbook shared and does it have "Track Changes" turned on?
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Middelburg, Zeeland, Netherlands
    Posts
    165
    Thanks
    20
    Thanked 2 Times in 2 Posts

    Re: Speed and Large (2000)

    It's a salary-sheet. It calculates many salaries of a company to see what the company can get back from taxes.
    It's not shared, and no Track Changes

  4. #4
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Middelburg, Zeeland, Netherlands
    Posts
    165
    Thanks
    20
    Thanked 2 Times in 2 Posts

    Re: Speed and Large (2000)

    Hans, thanx for your concern (bedankt).
    I've tried to Save As Html, but there only remains 612 KB :-(
    I'm convinced there's something wrong in the programming of the sheet.
    But it takes too much time and money to solve it. As a work-around we're gonna split the larger files.
    I's about numbers of employees. About 500 of them would make a file of 50 Mb.
    Split this in 250-250 and there remain two files of about 30 Mb. That's acceptable.
    Thanks

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Speed and Large (2000)

    Was there something missing from the file after the save to HTML format? Depending on exactly what is being done, 612kb does not sound wrong for 500 employees. I have many files with 500 rows of data that are much smaller than 612kb. It may be that there is some corruption in the file that is causing it to bloat to 50mb, and that is what the save to HTML format is supposed to get rid of.

    If there is something missing, can you describe what it is?
    Legare Coleman

  6. #6
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Middelburg, Zeeland, Netherlands
    Posts
    165
    Thanks
    20
    Thanked 2 Times in 2 Posts

    Re: Speed and Large (2000)

    Did I say kb?
    That should be just B.
    612 bytes. As you can imagine <gr> hardly anything was saved!
    Any idea?

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Speed and Large (2000)

    You did do the save to HTML format from XL 2000, not XL97? If it is XL 2000, then it sounds like there is something really corrupt in that workbook. XL 2000 should save just about everything that you can put into a workbook in HTML format.

    If that is what has happened, my only suggestion is to rebuild the workbook.
    Legare Coleman

  8. #8
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Middelburg, Zeeland, Netherlands
    Posts
    165
    Thanks
    20
    Thanked 2 Times in 2 Posts

    Re: Speed and Large (2000)

    Thanx, I'll think it over

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Speed and Large (2000)

    (Edited by HansV to update link to Excel MVP site)

    50 MB still seems very large. You may have accumulated some slack space and/or garbage over the course of time. You can try various things (make a copy first, just in case, and check carefully that nothing is lost after the suggested steps before using the result):
    <UL><LI>Save the workbook as HTML, close, reopen and save as XLS again (frankly, I've never tried it with a workbook anywhere near a large as yours)
    <LI>If you've got lots of code, run Rob Bovey's code cleaner; you can download it from http://www.appspro.com/ or http://www.bmsltd.ie/mvp/.[/list]

Posting Permissions

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