cells not updating

[jalea148]

Problem started with Win 7 and continues in Win 10. running 2010 Pro Plus. Recently repair was tried without improvement. Also completely deleted and re installed office. When a cell is changed other cells that refer to it should update. There are thousands of these. I have a work around, but it's not practical [ find all =/replace all with =].

 

[oldbrewer]

have you got calculation set to manual ?

 

[jalea148]

have you got calculation set to manual ?

Fantastic; Thank you. Never realized there was such a setting.

 

[oldbrewer]

when you have a big spreadsheet and are making changes it can lake a long time to update, so setting calculate to manual is very useful, providing you remember to turn it back to auto afterwards

 

[jalea148]

I wasn't aware of the calculation setting manually or automatic. Somehow, mine got set to manual several months ago. Updating had been a nightmare. Now that it's reset to automatic things are going smoothly.

 

[oldbrewer]

make sure you did not use "unupdated" data in a report to your boss...........

 

[Scrappy666]

I wasn't aware of the calculation setting manually or automatic. Somehow, mine got set to manual several months ago. Updating had been a nightmare. Now that it's reset to automatic things are going smoothly.

If you open a document that someone else has saved with calculation set to Manual it can change yours...
Very odd but always a useful thing to know about. It's bound to happen to you again in the future!!

 

[jalea148]

make sure you did not use "unupdated" data in a report to your boss...........

I am my boss.................

 

[oldbrewer]

ok do not make key business decisions based on bad information resulting from analysis of poor quality data.....

 

[Macropod]

Cross-posted at: http://www.msofficeforums.com/excel/30852-cells-not-updating.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html