Excel 2010 spreadsheet taking up almost 1gb of memory


  1. bassdrv
    Posts : 5
    Windows 7 64
       New #1

    Excel 2010 spreadsheet taking up almost 1gb of memory


    So I have a .xlsx spreadsheet of about 1.5mb taking up nearly 1gb of memory.

    Simple workbook consisting of about 5 sheets with standard formatting and some colors.

    I deleted all unnecessary rows and columns, ran 449898_intl_x64_zip hotfix, and rebuilt Excel registry and managed to get down from 1gb to 500mb memory being used.

    Anything else I can try?

    Thanks!
      My Computer
    Quote Quote

  3. UsernameIssues
    Posts : 10,485
    W7 Pro SP1 64bit
       New #2

    Can you open this file on another W7 computer?
      My Computer
    Quote Quote

  4. bassdrv
    Posts : 5
    Windows 7 64
    Thread Starter
       New #3

    UsernameIssues said:
    Can you open this file on another W7 computer?
    Unfortunately, no as this is the only PC in the household that has Office. Right back up to 1gb after viewing all 5 sheets in the workbook...
      My Computer
    Quote Quote

  6. UsernameIssues
    Posts : 10,485
    W7 Pro SP1 64bit
       New #4

    Have you tried making a fresh spreadsheet?

    Copy/paste the exact info in, then save it and check the RAM consumption.

    If the test spreadsheet takes up too much RAM, then delete it & create a new one. This time, type in data that is close to the original spreadsheet. ...check the RAM consumption.
      My Computer
    Quote Quote

 

  Related Discussions
When a user is opening a second Excel sheet the following error message appears: 'Excel cannot complete this task with available resources. Choose less data or close other applications.' The files are saved on a network drive and I am able to open them fine on my PC which is the exact same spec...
Greetings all, I'm having troubles with 2 excel 2010 spread sheets, that act very sluggish, and takes 3-15 min to make changes. These changes can be as simple as Cut and paste info to a new section, on the same spreadsheet, and will still take 3-15 min (depending on the amount of data being...
I was recently upgraded to Windows 7 and Office 2010. Under my old version of Windows XP & Office XP/07, when I received an emailed spreadsheet & made adjustments to it, I was able to save it directly over the old emailed file. Now when I make any changes I am asked to save a copy of the file & to...
Problem with Excel Spreadsheet
in Microsoft Office

I have to admit that I am not proficient in the MS Excel program. I have to fill in a form for a potential employer but the cell is too small to contain all of the information--the information that I typed in goes "off the page" into neighboring cells that are not part of the form. I can't seem to...
I have WIN 7 with Excel 2003. Is it possible to transfer data contained in a .pdf file onto an Ecel spreadsheet ? If it is possible what is the procedure ?
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 10:27.
Find Us