- Jul 18, 2005
- 761
- 0
- 0
Our comptroller at work has a penchant for breaking things, and this time it's Excel. When working in large-ish spreadsheets (~10 megs), he will encounter this scenario:
1. He makes a change to a value.
2. Auto calculate kicks in.
3. After auto calculate finishes, "Calculate" still shows on the status bar.
4. Even if he closes his spreadsheet, "Calculate" remains.
He wants to make sure that the calculation IS actually finishing, and this little weirdness is driving him up the wall. Any suggestions are appreciated, for both our sanity. Attached is a screenshot of the effect (look in the bottom left corner at the status bar).
Click here for a picture.
1. He makes a change to a value.
2. Auto calculate kicks in.
3. After auto calculate finishes, "Calculate" still shows on the status bar.
4. Even if he closes his spreadsheet, "Calculate" remains.
He wants to make sure that the calculation IS actually finishing, and this little weirdness is driving him up the wall. Any suggestions are appreciated, for both our sanity. Attached is a screenshot of the effect (look in the bottom left corner at the status bar).
Click here for a picture.
Facebook
Twitter