"Not enough system resources to display completely&quot

[tn312c]

Hi, I've been working with links the past few days and have been experiencing the subject error message. What do I need to do to avoid the error?

Thank you in advance...

 

[JulioNobre]

Re: "Not enough system resources to display completely&quot

Hi ade333

In order to help you, I have prepared a sample EXCEL workbook (see below).

Code explanation

1 - Create a workbook with two sheets:

MainSheet - Is the offending sheet, the one that contains controls or zoom <> 100%

DummySheet - A temporary which temporarily activated during save and load operations, saying, for example: "Please, wait..."
​

2 - On Workbook.BeforeSave event:

1 - Save current active sheet;
2 - Activate DummySheet
​

3 - On Workbook.AfterSave event:

1 - Restore current active sheet
​

4 - On Workook.Open event:

1 - Activate workbook MainSheet
​

What you will get

Now, everytime you save the workbook:

1 - DummySheet is activated;
2 - The workbook is saved;
3 - Current (prior to saving) active sheet is reactivated.

Note: If saving is too fast, alternation between sheet is not noticiable. Therefore, I have added a small delay so you can see that DummySheet is being temporarily activated.
​

And everytime you load the workbook:

1 - DummySheet is shown;
2 - MainSheet is activated.
​

This my sample workbook source code

<CODE>Option Explicit

Dim CurrentSheet As Worksheet

Const MainSheetName = "MainSheet"
Const DummySheetName = "DummySheet"

Private Sub Workbook_Open()
ActivateSheetByName MainSheetName
End Sub

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
SaveCurrentSheet
ActivateDummySheet
End Sub

Private Sub Workbook_AfterSave(ByVal Success As Boolean)
RestoreCurrentSheet
End Sub

Private Sub RestoreCurrentSheet()
If Not (CurrentSheet Is Nothing) Then ' Restore to current sheet prior to saving
CurrentSheet.Activate
End If
Set CurrentSheet = Nothing
End Sub

Private Sub SaveCurrentSheet()
Set CurrentSheet = ActiveSheet ' Active sheet will be restored after save
End Sub

Private Sub ActivateDummySheet()
ActivateSheetByName DummySheetName ' Activate dummy sheet during save
Sleep 2 ' Wait for 2 seconds just to let you see that active sheet is temporarily DummySheet
End Sub

Private Sub ActivateSheetByName(ByVal SheetName As String)
Dim Sheet As Worksheet
Set Sheet = ThisWorkbook.Sheets(SheetName)
Sheet.Activate
End Sub

Private Sub Sleep(ByVal Seconds As Integer)
Application.Wait DateAdd("s", Seconds, Now)
End Sub

</CODE><CODE></CODE>
​

<CODE>Sample workbook available at http://sisgarbe.dyndns.org/sispub/download/obter.php?produto=JULIO-EXCEL-BUG01-SAMPLE</CODE>
<CODE></CODE>
<CODE></CODE>
<CODE>To see source code on sample workbook, just press ALT + F11</CODE>
<CODE>Hope this helps </CODE>
<CODE></CODE>

 

[ade333]

Re: "Not enough system resources to display completely&quot

Julio,

THANK YOU! This is great!!!!

 

[pbaxter]

Re: "Not enough system resources to display completely&quot

Changing all sheets to 90% did it! Thanks.
Definitely a WTF.

 

[AndrewGG]

Re: "Not enough system resources to display completely&quot

You may want to look at the following:
http://support.microsoft.com/kb/183503
Provides a usable work-around.

Microsoft claim the problem was resolved years ago.
Unfortunately for them and us – it returned.

 

[pbaxter]

Re: "Not enough system resources to display completely&quot

Thanks. I'll try those work-arounds

 

[PC Guru]

"Not enough system resources"

I tried every fix on the internet for the "not enough resources" error in Excel 2010 with no luck

. It wasn't until I started looking at the version of Excel that I had a break through. By default Office is installed as 32-bit, but you can install a 64-bit version that allows Office to use all the resources that a work station has. 32 bit Excel only allows 2GB, whereas 64 uses all resources. This link 64-bit editions of Office 2010 explains how you should use 64 bit Office 2010 and how to install 64-bit editions. We have accountants that work with huge spread sheets and would always run into this issue after Office upgrade to 2010, once I switched them to Office 64-bit the problem stopped. I would only suggest to use 64-bit for users that work with large excel documents and/or get the memory error, keep 32-bit as default, this has worked great for us. BTW go to file>help in any Office 2010 program to see what version you are running, most likely it's 32-bit. Hope this helps someone out there because I know this error drove me nuts!!

 

[Engineer1279]

Re: "Not enough system resources to display completely&quot

Hi all you experts out there. It looks like this topic is not new and the resources and ideas listed above are great for preventing this error from displaying, but my excel file has come too far. It did not start doing this when I auto filled a formula or copied a page. It also happens at random points. I have not been able to find a specific circumstance which triggers the error. If I could, I would likely have fixed the problem by now. But this just started one day and now I don't know what I did that may have caused the issue. The error itself doesn't seem to do anything, even though it says it can't display completely, I don't see anything missing or wrong. It is just annoying that it is happening.

So does anybody have any ideas on how I might be able to find and fix the problem now that it is there?
Thanks.

 

[JulioNobre]

Re: "Not enough system resources to display completely&quot

Hi Engineer1279

This issue is in fact quite a mistery. However, if your excel file is self contained - I mean, it does not contain links to other excel files or other datasources (i.e. databases)-, I am willing to play around with it for a while in order to reproduce the insuficient resources issue - finding a consistent way of reproducing a problem take us very close to a solution. In case you agree with it, you can compressed it and attach it to one of these messages. Then I will take a look at it and publish the results. Alternatively, you can send me a Private Message (check on Mr Excel Account) and share the file only with me.

Of course, you can always just let us know the version of your Office and the version of operating system. At least, it is a start.

That is the best I can tell you for now.

 

[Simoneazz]

Re: "Not enough system resources to display completely&quot

Many thanks!!!! I spent a lot of days trying to resolve this issue!!! Thanks!!!

 

[AnotherExcel]

Re: "Not enough system resources to display completely&quot

I found the root cause of the problem. Please see the below explanation.
Definitions:
Source tab is where combobox or other control referencing.
Active tab is what you tab you see directly or under your form.

1. If source tab has 100% zoom then it does not matter what the zoom factor of active tab. No error.
2. If active tab has 100% zoom then it does not matter what the zoom factor of source tab. No error.
3. If neither of the tabs has 100% zoom then following applies.
a. If source tab zoom is equal to active tab’s then you won’t get the error.
b. Any other setting will give you error. Even if it is different by 1%.