PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes Formula does not run automatically.

Reply

Formula does not run automatically.

 
Thread Tools Rate Thread
Old 07-04-2006, 05:48 AM   #1
=?Utf-8?B?QkFTSA==?=
Guest
 
Posts: n/a
Default Formula does not run automatically.


In the first sheet of my workbook I have formulas that pickup and add data
form other sheets in the same workbook. Every time I make changes in the data
in other sheets the cells in first sheet do not get updated automatically. I
have to go back to the first sheet, double click on the cell which has
formulas and them press enter. Only then the cells bicks data from other
sheets.
  Reply With Quote
Old 07-04-2006, 08:21 AM   #2
Bondi
Guest
 
Posts: n/a
Default Re: Formula does not run automatically.

Hi
Maybe you have set your calculations to manual.

Go to Tools -> Options -> Calculations and set calculations to
Automatic

Regards,
Bondi

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off