Auto updating blog
I am having to click on the formula bar, then I have to click enter for the formula cell to do its thing. 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.
In Settings I had to change Automatic Update command to Full Calculate and then back again.
Once the original setting had been restored, the add-in ran as normal.
The ORCID registry lets researchers decide who can access their ORCID record and how.
Visit Stack Exchange is pressed or when the cells are clicked out of.
However, for some reason, the value calculated by the formula does not update automatically.
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. I ran into an issue where some cells weren't calculating.In my instance I was using a particular add-in called PI Datalink.