Formulas no longer auto update with newly inserted data!

  • Thread starter Thread starter Oyitch
  • Start date Start date
O

Oyitch

All of a sudden, I add sales numbers to a row that was
included in the summation. The sum function did not sum
the newly inserted information until I double-clicked on
the formula cell and re-entered. This now holds true for
all of my linked worksheets and formulas, rendering me
useless for entering additional data. Anybody know why
this is happening and how to remedy?
 
Hi
you probably have disabled the automatic calculation. Goto 'Tools -
Options - Calculation' and check 'Automatic calculation
 
Thank you I had the same problem.

----- Frank Kabel wrote: -----

Hi
you probably have disabled the automatic calculation. Goto 'Tools -
Options - Calculation' and check 'Automatic calculation
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert New Row with auto formatting. 3
setting excel formula from code 4
Auto numbering inserted rows. 1
Insert Row with formula 1
vba insert row does not update Sum formula 2
macros to insert specific rows without altering the formula 4
Formula Question 1
Auto extract data & inserts rows additional rows automatically 3

Back
Top