ExcelBanter - Excel 2007 is not recalculating formulas when new data is entered

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2007 is not recalculating formulas when new data is entered (https://www.excelbanter.com/excel-discussion-misc-queries/172512-excel-2007-not-recalculating-formulas-when-new-data-entered.html)

FlowerTechie

Excel 2007 is not recalculating formulas when new data is entered

Fred Smith[_4_]

Excel 2007 is not recalculating formulas when new data is entered

Check Excel Options, Formulas

Regards,
Fred

"FlowerTechie" wrote in message
...

FlowerTechie

Excel 2007 is not recalculating formulas when new data is ente

Thanks, Fred, Why dose it change from automatic to manual with out the user
doing anything. If anyone knows how to fix this please let me know.

"Fred Smith" wrote:

Check Excel Options, Formulas

Regards,
Fred

"FlowerTechie" wrote in message
...

Fred Smith[_4_]

Excel 2007 is not recalculating formulas when new data is ente

The most common reason is from a running a macro which gets interrupted.

Regards,
Fred.

"FlowerTechie" wrote in message
...
Thanks, Fred, Why dose it change from automatic to manual with out the
user
doing anything. If anyone knows how to fix this please let me know.

"Fred Smith" wrote:

Check Excel Options, Formulas

Regards,
Fred

"FlowerTechie" wrote in message
...

All times are GMT +1. The time now is 12:12 AM.