Computer Help and Support

Turbineguy

(38,440 posts) Fri Nov 16, 2018, 12:08 PM Nov 2018

Excel Office 365

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?

3 replies

= new reply since forum marked as read

Highlight:

Excel Office 365 (Original Post) Turbineguy Nov 2018 OP

Couple of suggestions WA-03 Democrat Nov 2018 #1

Several possibilities. Try searching "Excel worksheet is not updating" for suggestions. Hoyt Nov 2018 #2

Thanks for the answers. Turbineguy Nov 2018 #3

WA-03 Democrat

(3,273 posts)

1. Couple of suggestions

Reply to Turbineguy (Original post)

Fri Nov 16, 2018, 12:19 PM

Nov 2018

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

(54,770 posts)

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

Reply to Turbineguy (Original post)

Fri Nov 16, 2018, 12:45 PM

Nov 2018

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

(38,440 posts)

3. Thanks for the answers.

Reply to Turbineguy (Original post)

Fri Nov 16, 2018, 06:00 PM

Nov 2018

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.

Reply to this discussion