Error Message = "Not Enough System Resources to Display Completely"

[Starbucks_33]

Hi,

I had a question about the error message I was getting.

Error Message = "Not Enough System Resources to Display Completely"

1.) I get this message when I view my userform in design mode.
2.) The userform has a picture = 105kb, A multipage with 5 tabs.
3.) Size of workbook = 2 mb, Size of bitmap = 105kb
4.) Memory usage = 25mb, in taskmanager when the userform is open. only 3mb when closed.
5.) Excel 2003, XP, 2GB of Ram
6.) I have 1.5GB of available memory (Ram) from Taskmanager

Questions.
1.) Should I ignore the error message, my spreadsheet seems to be working fine.
2.) what is the cause of the error, it looks like my system has available resources since Excel is only taking up 25mb of ram, I have 2GB
3.) is there a way to fix the error

Thanks for your help

 

[Stormseed]

Hi Starbucks

Welcome to MrExcel

Your computer RAM has nothing to do with the memory taken by Excel as an application. I suggest you go through these links and read the information which would help you to understand the issue. The issue that you are experiencing is common and is experienced by most of the users who use Excel.

1) http://support.microsoft.com/kb/313275/en-us
2) http://www.decisionmodels.com/calcsecretsf.htm

 

[Starbucks_33]

Thanks for the links I think they were useful but am still wondering if these have to do with my problem -

1.) They talk about memory limits, that are exceeded when copying large ranges. But my worksheet does not have any formulas or excessively large ranges. The problem has to do with the userform, is there a memory limit for the userform that is different from just copying ranges?

2.) The second link talks about formulas and the calculate (f9), but my worksheet is not slowed down because there are no formulas in it.

 

[Stormseed]

hi

sure, these links talk about large formula ranges. However, the error message that you get "Not Enough System Resources to Display Completely" is caused only due to the memory limit dependencies in Excel.

You would not get this error message due to some other cause in Excel. You can cross verify the same with whatever resource you get through.

 

[Starbucks_33]

Thanks for your help I think this answers my question - the problem is caused by memory limits. Also do you know if this is a problem or should I just ignore the issue?

 

[Stormseed]

Excel behaves in this manner by design. There is nothing much you can do and I guess you will have to live with it. Also, I think switching over to Excel 2007 would give better performance in terms of memory allocation. I do not know the solution to this problem, the reason being, even I experience these errors on a daily basis at workplace. What does Microsoft Paid Support has to say, any idea ?

 

[Starbucks_33]

I think that is basically the answer I was hoping for. I just wanted to make sure that the error would not result in a crash or a problem that could effect the running of my program. Basically it is just a nuisance.