Update formula

ladyfear

New Member
Joined
Oct 6, 2008
Messages
5
Hi All,

I am using Excel 2003 and have been having a problem lately with formulas in my worksheets that will not update automatically. Say for example that I have data in Sheet 1 in cells A1 and B1. And then I have a formula in Sheet 2 that adds these values together (=a1+b1). There are times when I update the values in A1 and B1 on Sheet 1, that the formula in Sheet 2 will not update. I have to manually go to Sheet 2, click on the cell, hit F2, and then enter for it to update (without altering anything else). Is there a reason for this? I have checked the calculation option in Tools/options, and it's set to automatic. I posted another problem similar to this (regarding formatting), but the general problem is the same - my cells are not updating. Please help! It makes it so that I have to check to see every formula is correct in the workbook -- what then is the point of formulas -- I might as well input everything by hand!
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

btadams

Well-known Member
Joined
Jan 6, 2003
Messages
1,936
Does this happen all the time or only with certain workbooks?
 

Watch MrExcel Video

Forum statistics

Threads
1,095,931
Messages
5,447,380
Members
405,449
Latest member
Jfrusty

This Week's Hot Topics

Top