Thread: Excel question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
westdomain westdomain is offline
external usenet poster
 
Posts: 1
Default Excel question

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