Hi All,
After launching « myFile.xltx » my Charts will not react on data input, but if I Quit the file without saving and relaunch it, everything in the Charts will then work correctly on data input. Do anybody have a glue on what cause this abnormality.
Thanks...
My first guess is that it is related to the "manual/automatic calculation" toggle in Excel settings (fully understanding it is a little complicated, and I don't know if/how it has changed in newer versions). When the chart doesn't update, is the calculation setting set to manual? When the chart does update, is the calculation set to automatic?
Originally Posted by shg
My Settings in preferences shows automatic calculations. My eventuel data inputs are reflected in other depending cells immediately but not in the Charts.
Going to need more information, then, to debug this. Can you upload a sample file that exhibits the symptoms?
I have tried to make a sample file, but unfortunately I can't reproduce the problem in a small file. Thank you anyway for the offer to debug the problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks