Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Spreasheet crashes (2002)

    This does not necessarily mean that the workbook is corrupted. It probably means what it says: that Excel cannot allocate enough memory to perform the operation - 85 MB is quite large! Perhaps copying one worksheet at a time, then saving the workbook will work better. He might also try quitting and restarting Excel after copying a worksheet.

    FYI, see Jan Karel Pieterse's article on Corrupt files.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Spreasheet crashes (2002)

    For information on memory problems in Excel see Decision Models - Excel Pages - Memory & Limits

  3. #3
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreasheet crashes (2002)

    Currently one sheet in his spredsheet is 5mb, he will need to create 50 of those which means that his spreadsheet will be 250mb, in your opinion will it be possible for his spreadsheet to function? his PC spec: 2.8ghz, 256mb of ram and the spreadsheet is linked to other spreadsheets too.

    Any syggestions...

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

    Re: Spreasheet crashes (2002)

    I think Excel/Windows will run out of memory. Why does he need so many sheets of such a huge size?

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

    Re: Spreasheet crashes (2002)

    See the link in TonyE's reply. Excel 2002 cannot make use of all available memory, but Excel 2003 is much better at memory management. So it might help if he upgraded his RAM to (for example) 1 GB and installed Office 2003 instead of Office XP. I cannot guarantee anything, however.

  6. #6
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Spreasheet crashes (2002)

    One of my colleagues has a sperasheet of 85mb, ones he tries to copy a tab of a spreedsheet multiple times, the spreadsheet is crashing and a message comes up saying "you do not have enough resources to complete this operation"

    Does anyone have any idea why this is happenind and how can you tell when a spreadsheet is corrupted...

    Cheeers Skender

  7. #7
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreasheet crashes (2002)

    <P ID="nt"><font size=-1>(No Text)</font>

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

    Re: Spreasheet crashes (2002)

    <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

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

    Re: Spreasheet crashes (2002)

    I don't know what is most memory intensive, perhaps someone else can shed light on this.

  10. #10
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Spreasheet crashes (2002)

    <post:=404,416>post 404,416</post:> has some discussion/suggestions on memory size and reducing them.

    In addition pictures embedded in the files can make it large. No matter what type of picture is embedded, XL seems to save it in the file as a bitmap so a 30k gif grows to much larger size if embedded.

    In our files at work, we no longer insert photos but store them in a network folder and link to them in the XL file.

    Steve

  11. #11
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreasheet crashes (2002)

    Thanks for your suggestions, I have one more question.
    With regards to this massive spreadsheet, what features of a workbook are the most memory intensive?

    Cheers
    Skender

  12. #12
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet crashes (2002)

    I have bought an extra 1gb of ram, I have a copy of Office 2003, when i do the install for office 2003 does it matter if i do an upgrade or should i uninstall the current version first, which is Office XP.

    Regards,
    Skender

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

    Re: Spreadsheet crashes (2002)

    You don't have to uninstall Office XP, the installation program for Office 2003 will take care of that.

  14. #14
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet crashes (2002)

    when I install office 2003, should I chose to do an upgrade or full install?

    cheers,
    Skender

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

    Re: Spreadsheet crashes (2002)

    If you want the installation to detect Office XP etc., choose upgrade.

Page 1 of 2 12 LastLast

Posting Permissions

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