Excel Office 365

[Turbineguy]

Strangely, this morning a work sheet that I have been using for about 15 years stopped working. The formulas are there but when you change a variable, nothing updates?

It's as if somebody turned something off. Any ideas?

[WA-03 Democrat]

1. Couple of suggestions

1) make a backup of the sheet on your drive and an external device ( thumb drive)
2) open one of the copies and try savings as a .xls and reopen to see. You may have saved it to a new ver.
3) email the sheet to another computer and try to open.

[Hoyt]

2. Several possibilities. Try searching "Excel worksheet is not updating" for suggestions.

I've had the automatic calculation function stop before. Never did identify reason, but resetting it worked. Also, if it is using values from another spreadsheet, that can create an issue if something happens to that sheet.

Good luck.

[Turbineguy]

3. Thanks for the answers.

I renamed the worksheet and it started working again. Once. I saved/closed. When I opened it again it did not work. It works once when you rename it.

I found a week-old back-up in my back-up drive. I deleted the bad sheet and copied the old one in place and updated the info. Now it's working.