Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 10730
  • Last Modified:

Excel 2013 - "Not enough system resouces to display completely".

Hi,
I keep getting the following message when opening up just one specific excel file. "Not enough system resources to display completely". It works for everyone else and it used to open up on my older PC. I just got a brand new PC and it does not work.

Initially, my PC came with Office 2013 x32 bit. The file format is xls. It is 82 MB. I only have the problem for this one file. The file does open normally after I restart the computer. But if I close it and try to open it again later it won't work unless I restart again.

What I tried:

- Office 2013 Full repair
- Uninstalled Office 2013 x32 and installed x64
- Disabled all Excel add-ons.
- Converted file to xlsx (file size went down to 67 MB)
- Converted file to xlsb (binary workbook - file size went down to 9 MB)
- Increased virtual memory to 13 GB; The file did open all the contents (unlike before) but it still showed the message.

Like I said the PC is brand new. It has Intel Core i&-4770S with 2x CPU at 4 cores each with 8 GB of memory. OS is Windows 7 Pro x64.

Not really sure where else to go with this. Any suggestions would be appreciated.

Thanks in advance. - ES
0
eshiram
Asked:
eshiram
  • 3
  • 2
  • 2
  • +1
1 Solution
 
Martin LissRetired ProgrammerCommented:
Does your wb use a lot of files or objects that you aren't closing and/or setting to Nothing?
0
 
eshiramAuthor Commented:
I use this Excel doc as a reference that someone else made. How would I check this?
0
 
Martin LissRetired ProgrammerCommented:
Can you attach your workbook?
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
regmigrantCommented:
Do you use Tables? I believe that the Table functionality uses arrays which Excel tries to load completely. On 32 bit the 2gb limit left a natural breakpoint so Virtual Memory was invoked and that seems to have been removed/changed in 64 bit

Reg
0
 
regmigrantCommented:
you can also look at the following:-
http://support.microsoft.com/kb/2779852

Interesting that the print driver is listed as a possible cause!

Reg
0
 
eshiramAuthor Commented:
Yup, that is what it was. Thanks!
0
 
fdadadasd sadsaddasdCommented:
After this error all the data which I entered it was flushed and unable to recover, pls help me.
0
 
fdadadasd sadsaddasdCommented:
pls help me i am in trouble!!
0
 
fdadadasd sadsaddasdCommented:
This error erased my all the data, pls help me to recover the lost data.
pls help me.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now