Ok, I have a few worksheets that have formulas in them. If you put in
numbers, it's fine, but if you change one of the numbers, the cell where the
formula is, doesn't change unless you go into Tools|Options|choose the
Calculation Tab and then choose Automatic because it is defaulted to Manual.
Is there a file that I can change that will change all my spreadsheets from
Manual to Automatic? Any help will be greatly appreciated. I have done some
searching, would it be the personal.xls file and if so, where can I find this
file and what would I do to change it?



Thanks again,

Tim

To change my personal.xls file, I open a new workbook and choose Windows and
"Unhide". Options: Calculate and choose Automatic. Then close and save
personal.xls. Exit Excel. Go back into Excel. Is Automatic Calculation now
your default?

"westdomain" wrote:

Ok, I have a few worksheets that have formulas in them. If you put in
numbers, it's fine, but if you change one of the numbers, the cell where the
formula is, doesn't change unless you go into Tools|Options|choose the
Calculation Tab and then choose Automatic because it is defaulted to Manual.
Is there a file that I can change that will change all my spreadsheets from
Manual to Automatic? Any help will be greatly appreciated. I have done some
searching, would it be the personal.xls file and if so, where can I find this
file and what would I do to change it?



Thanks again,

Tim