Automatically recalculating in Excel

A

Allison

Our spreadsheets use to automatically recalculate when we entered additional
information. Now, we have to manually ask for the spreadsheet to recalculate.
It is not isolated to one spreadsheet, workbook, or file.
Is this a setting in Excel that can be changed?
 
P

Paul B

Allison, tools, options, calculation, check automatic
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
B

Bob Phillips

Check your settings, Tools>Options>Calculate and make sure it is set to
automatic not manual.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top