Large Spreadsheet - Freeze On Recalculate
You are correct. When I hit F9, or even Shift+F9, the second reference to
Excel (with the same file name listed each time) is listed on the Task
Manager. Any ideas on how to resolve this?
"JLatham" wrote:
Try a couple of tests. Open up the workbook and check the Task Manager for
entries. Then hit [F9] and check again. If the second copy shows up then
I'd suspect some code somewhere attached to a sheet's Calculate event
triggering and firing off and maybe confusing everything. Call this a stab
in the dark, but it is something to check out if for no other reason than to
rule code out of the picture.
"J" wrote:
I am having a persistent problem. Every time I tell the spreadsheet to
recalculate (F9) Excel 2003 freezes. After I press F9 it says "Calculating
Cells: 0%". It stays at 0% and will not progress. Eventually the Task Manager
sayd says that Excel is Not Responding. For what its worth, the program/file
name is listed twice in the Task Manager. Any suggestions? I can't figure out
what to do.
|