ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Formula stopped working (https://www.excelbanter.com/new-users-excel/226419-formula-stopped-working.html)

tony

Formula stopped working
 
I'm having a rather odd problem with my Excel formulas and hope someone can
help me.

Within the week, my Excel spreadsheet formulas have simply stopped working.
When I input new data into the sheet, the formula will not calculate new
totals like it did last week. Nothing about the formula has changed and it is
correct. Even if I alter a figure, it will not recalculate it just sits there
showing the same figure that it was before.

This has affected all my spreadsheets.

Has it been caused by an update? If so, how can I rectify it?

Gary''s Student

Formula stopped working
 
Hi Tony:

Tools Options... Calculation and check automatic
--
Gary''s Student - gsnu200842


"Tony" wrote:

I'm having a rather odd problem with my Excel formulas and hope someone can
help me.

Within the week, my Excel spreadsheet formulas have simply stopped working.
When I input new data into the sheet, the formula will not calculate new
totals like it did last week. Nothing about the formula has changed and it is
correct. Even if I alter a figure, it will not recalculate it just sits there
showing the same figure that it was before.

This has affected all my spreadsheets.

Has it been caused by an update? If so, how can I rectify it?


tony

Formula stopped working
 


"Gary''s Student" wrote:

Hi Tony:

Tools Options... Calculation and check automatic
--
Gary''s Student - gsnu200842



Thanks Gary - Worked a treat!! :)


All times are GMT +1. The time now is 10:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com