Posted by Kim on December 10, 2001 9:55 AM
Our construction company uses Excel for a calculating our final bid price,it was originally done in Lotus which handled the iterations automatically when the file was first opened (no nag screen). With Excel we need to set the calculation iteration option each time the sheet is opened in a NEW session. Question, is there a way to have the program automatically calculate the iterations without having to set the calculation iterations box each time we use the file for the first time. I have tried saving the file with it checked but when I open it again after closing Excel the setting must be reset.
Thanks in advance.