Excel worksheet updating macro

I also have had this problem with a very large spreadsheet that just stopped updating itself over the weekend, but having checked the above solutions, setting were already set to automatic, and sheet is too big to rebuild, so I was at a loss.My solution was to find an old version of the same excel spreadsheet which was not having thses issuesbefore I archived it, which is of similar size and complexity to the current version.I opened this spreadsheet, checked that this was still working and autoupdating with current installation of MS Excel and any new automatic office updates (which it did work with), and then just reopened the original spreadsheet. In my instance I was using a particular add-in called PI Datalink.Somehow PI's Calculate method was no longer running during the normal workbook recalculate.

Ctrl+F9 not only updated the values, but fixed the problem so it didn't happen again.I had a case of this just now on Excel 2010: a particular spreadsheet that would not auto-recalculate.I changed the setting as indicated above; but the auto-recalculate still did not work, and upon rechecking the "Calculation" option, found it had reset itself back to "Manual" all by itself.Three attempts later and it was still adamant it wanted to be "Manual" and nothing else.Copy the contents of the spreadsheet to a new one, and deleted the old one (it wasn't a particularly important spreadsheet, thankfully), and everything was fine.

Search for excel worksheet updating macro:

excel worksheet updating macro-3excel worksheet updating macro-58

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “excel worksheet updating macro”