Help!

Excel 2003 Formula not responding

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Change default black background when saving power..  
Author Message
Formulas not responding t
External


Since: May 01, 2009
Posts: 1
PostPosted: Fri May 01, 2009 7:26 am    Post subject: Excel 2003 Formula not responding
Archived from groups: microsoft>public>excel>misc (more info?)
All of a sudden, worksheets with formulas that I have been using forever are
not responding to changes in data. I checked formulas and formatting - all is
correct. The cell with the formula in it does not show a changed result when
the related data changes.....Seems suddenly to have happened to all my
spreadsheets!
Back to top
Jacob Skaria
External


Since: Mar 04, 2009
Posts: 441
PostPosted: Fri May 01, 2009 7:31 am    Post subject: RE: Excel 2003 Formula not responding [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Under Tools Option check the Calculation settings..

Set that to automatic if not
--
If this post helps click Yes
---------------
Jacob Skaria


"Formulas not responding to changed data" wrote:

> All of a sudden, worksheets with formulas that I have been using forever are
> not responding to changes in data. I checked formulas and formatting - all is
> correct. The cell with the formula in it does not show a changed result when
> the related data changes.....Seems suddenly to have happened to all my
> spreadsheets!
Back to top
RonaldoOneNil
External


Since: May 01, 2009
Posts: 7
PostPosted: Fri May 01, 2009 7:31 am    Post subject: RE: Excel 2003 Formula not responding [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Tools - Options - Calculation
Make sure Automatic is selected.

"Formulas not responding to changed data" wrote:

> All of a sudden, worksheets with formulas that I have been using forever are
> not responding to changes in data. I checked formulas and formatting - all is
> correct. The cell with the formula in it does not show a changed result when
> the related data changes.....Seems suddenly to have happened to all my
> spreadsheets!
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum