P
pierrelogic
I have an Excel file that is doing something odd. First of all, Excel 9
SP2. Now when I open this file it has tons of formulas and it can bot
auto-update or manually update just fine. The problem is when it's don
crunching numbers the word "calculate" shows up on the bottom of th
Excel window in the status bar on the far left and will not go awa
even if I close the suspect file causing it. I can keep the Exce
program itself open and continue to open other workbooks and the wor
calculate still stays present in the status bar. Close the Exce
program, reopen and all other Excel files load just fine. Load up thi
suspect file and the word calculate shows up gain until I shut th
Excel program down. I've searched many many other sites trying to fin
out what is causing this and I can't find anything specific addressin
this problem.
This is an issue because the calculating that is done on this sheet
take a loooong time to complete. So long I've had to turn off th
auto-calculation option just so I can navigate the file withou
calculating every time I move to another cell.
This file has several sheets all pulling raw information from anothe
single sheet within the same workbook. I'm using VLOOKUP quite a bit t
pull this raw info into the fields doing the calculating based on tex
fields on the sheets housing the raw data. Nothing earth shattering o
the calculating...just adding and totaling but there are a lot o
repeating calculations that only change lines referenced.
AtDhVaAnNkCs
SP2. Now when I open this file it has tons of formulas and it can bot
auto-update or manually update just fine. The problem is when it's don
crunching numbers the word "calculate" shows up on the bottom of th
Excel window in the status bar on the far left and will not go awa
even if I close the suspect file causing it. I can keep the Exce
program itself open and continue to open other workbooks and the wor
calculate still stays present in the status bar. Close the Exce
program, reopen and all other Excel files load just fine. Load up thi
suspect file and the word calculate shows up gain until I shut th
Excel program down. I've searched many many other sites trying to fin
out what is causing this and I can't find anything specific addressin
this problem.
This is an issue because the calculating that is done on this sheet
take a loooong time to complete. So long I've had to turn off th
auto-calculation option just so I can navigate the file withou
calculating every time I move to another cell.
This file has several sheets all pulling raw information from anothe
single sheet within the same workbook. I'm using VLOOKUP quite a bit t
pull this raw info into the fields doing the calculating based on tex
fields on the sheets housing the raw data. Nothing earth shattering o
the calculating...just adding and totaling but there are a lot o
repeating calculations that only change lines referenced.
AtDhVaAnNkCs