not enough resources to display completely in Excel 2007

[Venugopal N.R]

Hi,

I use a dell Core2Duo system with 2GB RAM, XP prof SP3 is the OS and Office 2007 standard. Now days I get an error message
not enough resources to display completely in Excel 2007 when i open a spreadsheet and the system shuts down. only in excel it happens after long duration of work in excel Please help me to over come this error.


Regards,
Venu

 

[Smallman]

Hi Venugopal

How big are these spreadsheets you are trying to open? Might be that you don't have enough power if the files are monsterous. I have a pretty quick machine and even it struggles when I get a big XL file to open.

If it is a big file over the 1meg limit for this site. You could put it on DropBox and we could have a look to see what the response times are.

Take care

Smallman

 

[Venugopal N.R]

Excel shuts down the system by displaying the above said error message, sometimes when i open multiple sheets that are less than MB. or Sometimes with Only one excel sheet. But if i work in any other application other than excel the system doesn't shutdown. I'm sorry for not sharing the files.

 

[NARAYANK991]

Hi Venugopal ,

Offhand , I would say the problem is with your Excel software ; Excel itself is not as resource hungry as many other applications.

You can use the Windows Task Manager to examine what is happening ; run the software by pressing CTRL ALT DEL ; look at the number of processes and the CPU Usage when Excel has not been loaded. Start Excel and see how the figures change ; open a new workbook and see how the figures change ; now open one of your problem workbooks and see what happens.

Another possibility is to open these same problem files on another computer , and see what happens ; if Excel does not shutdown , then you know that the problem is restricted to your computer.

Yet another point to look at is since when has this problem been present ? Can you restore your computer to an earlier restore point and see whether the situation improves ?

Narayan

 

[Venugopal N.R]

Hi, Thankyou for your reply. I saw an article as below:

Each instance of Microsoft Excel 2007, Excel 2010, and Excel 2013 32-bit is limited to 2 gigabyte (GB) of memory (internal heap space). Each instance is also limited to 32,760 source cells when you perform a smart fill operation. When you copy or fill large sections of a worksheet, one or both of these limitations may affect the result.

Is it causing the problem?

Regards,
Venu

 

[NARAYANK991]

Hi Venu ,

What you have posted is with reference to a specific operation on the worksheet.

Only you can say whether what is mentioned has any relevance to your worksheet ; if your copy of Excel is crashing even when you are not copying or filling large sections of a worksheet , then what is posted may not be relevant.

Have you checked out any of the points I posted earlier ?

Narayan

 

[lohithsriram]

Hi Venugopal,

1) Check if there are any disabled items in your Excel (Options -> Addins-> Choose disabled items from dropdown -> Go.) Enable all the items. Also check the Com-Addins section and remove the references if there are any.
2) Delete all the *.exd & other files from the Forms folder under %appdata% -> Microsoft -> Forms
3) Delete all the *.exd & other files from the Excel8.0 folder under %temp%
4) Delete all the *.exd & other files from the VBE folder under %temp%
5) Check the Excel startup folder and see if you have any unwanted stuff/temp files placed in there and delete those. Also, outside the startup folder where usually all the Excel backup files gets stored.

 

[SirJB7]

Hi, Venugopal N.R!
After doing what lohithsriram suggested and if the problem still happens, open a clean Excel instance, go to the VBA editor (Alt-F11) and copy the number and names of the VBA projects loaded.
Regards!