C
Charles
I am running Excel 2007 on my laptop and seeming randomly I am encountering
memory problems. My assumption is that the problem is a memory leak within
Excel and has nothing to do with the total overall memory of the system.
Error Message: Excel can not open workbook with available resources
Symptoms: Excel will either open the notebook, graying out portions of the
screen or toolbar, making them unviewable -OR- will attempt to recover the
workbook showing only values with no formatting or formulas.
Workarounds include: Closing all spreadsheets or rebooting machine
temporarily resolves issues most of but not all of the time.
I am looking for a way to permanently resolve this issue so that it will not
affect my productivity. Excel 2007, even on this decently fast system takes
a long time to start and rebooting takes longer.
Lenovo Thinkpad T60
2GB RAM
20GB free HD space
Attached 22" monitor extended on laptop display
Windows XP SP2 patched to current
Excel 2007
The number of workbooks open, worksheets in each book, macros, formulas,
etc... does not seem to affect the problem. It happens
inconsistently...sometimes when I open a known working spreadsheet after a
reboot and sometimes after having the same spreadsheet open several times
throughout the day. Sometimes with no other workbooks open and sometimes
with 5. Sometimes changing the zoom on all sheets to 100% fixes the problem,
sometimes it doesn't. Basically I haven't been able to find any consistency
with the problem. Occassionally closing excel and re-opening fixes the
problem, sometimes it doesn't and requires a reboot.
System memory utilization is always low...never over 50% for all
applications and processes. Usually the only things I have open are e-mail
and excel but occassionally it will happen with only one small spreadsheet
open and no other applications open.
The only applications running in the background are .net framework, java,
McAffee VS, and ATI display tools.
I have searched all over the internet and have not been able to find anybody
having this problem with similar symptoms.
memory problems. My assumption is that the problem is a memory leak within
Excel and has nothing to do with the total overall memory of the system.
Error Message: Excel can not open workbook with available resources
Symptoms: Excel will either open the notebook, graying out portions of the
screen or toolbar, making them unviewable -OR- will attempt to recover the
workbook showing only values with no formatting or formulas.
Workarounds include: Closing all spreadsheets or rebooting machine
temporarily resolves issues most of but not all of the time.
I am looking for a way to permanently resolve this issue so that it will not
affect my productivity. Excel 2007, even on this decently fast system takes
a long time to start and rebooting takes longer.
Lenovo Thinkpad T60
2GB RAM
20GB free HD space
Attached 22" monitor extended on laptop display
Windows XP SP2 patched to current
Excel 2007
The number of workbooks open, worksheets in each book, macros, formulas,
etc... does not seem to affect the problem. It happens
inconsistently...sometimes when I open a known working spreadsheet after a
reboot and sometimes after having the same spreadsheet open several times
throughout the day. Sometimes with no other workbooks open and sometimes
with 5. Sometimes changing the zoom on all sheets to 100% fixes the problem,
sometimes it doesn't. Basically I haven't been able to find any consistency
with the problem. Occassionally closing excel and re-opening fixes the
problem, sometimes it doesn't and requires a reboot.
System memory utilization is always low...never over 50% for all
applications and processes. Usually the only things I have open are e-mail
and excel but occassionally it will happen with only one small spreadsheet
open and no other applications open.
The only applications running in the background are .net framework, java,
McAffee VS, and ATI display tools.
I have searched all over the internet and have not been able to find anybody
having this problem with similar symptoms.