• Speed and Large (2000)

    Author
    Topic
    #388396

    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

    Viewing 0 reply threads
    Author
    Replies
    • #681747

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

      • #681761

        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

        • #681790

          (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):

          • #682099

            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

            • #682166

              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?

            • #682208

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

            • #682254

              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.

            • #682264

              Thanx, I’ll think it over

    Viewing 0 reply threads
    Reply To: Speed and Large (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: