twig123 Posted August 8, 2008 Posted August 8, 2008 Hey all,I'm having some problems with Excel 07. I will randomly get an error "Not enough system resource to display completely" when just looking at excel sheets. I have done some research and found that old versions of LANDesk software as well as Bitmaps in excel can cause this... however... I have neither. I also read that the page file being too small can cause this as well so I changed the size to a range of 1GB-3GB, which had no effect. The error comes up randomly and can happen even in a new Excel sheet. Microsoft has a patch for this... but it is for Office 03, not 07...I am lost as the where to turn next... any help would be appreciated.
DigeratiPrime Posted August 8, 2008 Posted August 8, 2008 Are you using XP, Vista, or other? In Task Manager (Ctrl+Alt+Del) under the Performance tab, how much Physical Memory do you have Total and Available (Free)? Does this only happen with certain excel files open or even with new empty worksheets?
twig123 Posted August 11, 2008 Author Posted August 11, 2008 running XP. system has 1GB RAM and run around 400mb RAM usage... leaving ~600MB for excel or any other new apps. Happens in both new and existing.
cluberti Posted August 11, 2008 Posted August 11, 2008 This is not a memory error, but rather a desktop heap resource issue. How many apps/windows/etc do you have open, and/or how many sheets does this workbook have? Also, can you reproduce this with just Excel and this workbook open?
twig123 Posted August 11, 2008 Author Posted August 11, 2008 Doesn't matter what apps are open or if it is a new blank or existing workbook.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now