I use Excel a lot and know how to get sheets to calculate. I also know how
to suspend calculations and how to manually kick them off using F9. However,
I have a big sheet (about 125Mb) that won't finish calculating. Auto
calculating is turned on but the word "calculate" still appears on the bottom
of the worksheet. When I click F9, the "calculate" goes away and to the left
the words "calculating cells 0%" appear for about 2 seconds and then go away.
After "calculating cells 0%", the word "calculate" appears again! I've
probably hit F9 about 100 times and it wno't clear the "calulate" from the
sheet! As a test, I moved the entire contents of the worksheet to a new
workbook but got the same results. I also tested deleting everything from
the sheet an also got the same results. Does anyone know what's wrong?!?!
Thank you in advance for your help!