Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 spreadsheet taking up almost 1gb of memory

09 Apr 2013   #1
bassdrv

Windows 7 64
 
 
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 System SpecsSystem Spec
.

09 Apr 2013   #2
UsernameIssues

W7 Pro SP1 64bit
 
 

Can you open this file on another W7 computer?
My System SpecsSystem Spec
09 Apr 2013   #3
bassdrv

Windows 7 64
 
 

Quote   Quote: Originally Posted by UsernameIssues View Post
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 System SpecsSystem Spec
.


09 Apr 2013   #4
UsernameIssues

W7 Pro SP1 64bit
 
 

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 System SpecsSystem Spec
Reply

 Excel 2010 spreadsheet taking up almost 1gb of memory




Thread Tools





Similar help and support threads
Thread Forum
Excel 2010 - Out of memory? Not enough resources.
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...
Microsoft Office
Windows 7 wont allow me to open an Excel spreadsheet
Hi, I've got a similar problem. W7 wont allow me to open an Excel spreadsheet because it says it's already running. But it isnt. It's not shown in the task manager either. How can I find it and close it apart from rebooting? This came about after I copied the the spreadsheet from a backup copy...
Microsoft Office
Excel 2010, acting sluggish and taking 3-15 min at a time for change.
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...
Microsoft Office
Excel 2010 emailed spreadsheet doesn't save/overwrite the orignal
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...
Microsoft Office
Problem with Excel Spreadsheet
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...
Microsoft Office
PDF File data into Excel Spreadsheet ?
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 ?
Microsoft Office

Our Sites

Site Links

About Us

Find 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 04:50.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App