Updating excel from a word file
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.
One of the changes I notice is the column width in the working computer is 11.86 but when I open the same file on other computer which doesn't work, the column width becomes 11.9 I believe many other changes to other columns too, that's why it's affecting my display badly.
Any idea what happen, or setting or anything that done this?
Somehow the column width changes, the row height changes, that's why all display change.
When I say it doesn't work, it's because the display change between computers.Would you like to answer one of these unanswered questions instead?This example uses a hypothetical syntax, where the contents are standard Excel formula.Somehow PI's Calculate method was no longer running during the normal workbook recalculate.In Settings I had to change Automatic Update command to Full Calculate and then back again.