ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   F9 doesn't do calculation (https://www.excelbanter.com/excel-programming/319650-f9-doesnt-do-calculation.html)

strout

F9 doesn't do calculation
 
The problem is weird. The user is using Excel 2000 on WIndows XP. The Excel
is not doing calculation automatically even though I set it in options. It
won't do calculation even when I press F9 button.

However when I copy the file to my computer, Office XP on Windows XP.
Everything is fine. What would be the problem?

Thanks


david mcritchie

F9 doesn't do calculation
 
Try...
Recalculate all cells on all worksheets in all open workbooks [Ctrl+Alt+F9]
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"strout" wrote in message ...
The problem is weird. The user is using Excel 2000 on WIndows XP. The Excel
is not doing calculation automatically even though I set it in options. It
won't do calculation even when I press F9 button.

However when I copy the file to my computer, Office XP on Windows XP.
Everything is fine. What would be the problem?

Thanks





All times are GMT +1. The time now is 03:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com