There is a woman at work who is using excel 97. When she opens Excel a F9 window pops up. She has a large excel spreadsheet which she is linking to Freedom accounting software spreadsheet. We changed the tools, options, calculation to manual calculation and re-saved the spreadsheet. However when she opens the spreadsheet the next day it still autocalculates, which takes about 30 minutes. She would like it to stay on manual calculation even when saving or opening. Anyone out there had this problem? She claims that last week it would stay on manual but won't this week.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel 97 Calculation Problem
- Thread starter cgilmore
- Start date