Updating tables in excel
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.
It is interesting to note that for some types of data—such as those based on dates—Excel will automatically sort the data by date as it presents it in the chart, but not in the data table itself.(This approach only works if the chart is on object on the same worksheet that contains the data on which the chart is based.) Follow these steps: That's it—Excel incorporates the new data right into the existing chart, slick as a whistle.Another approach is to add new data to the range not at the end, but somewhere within the range.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.
Instead, insert some blank rows somewhere within the data range; it doesn't matter where, as long as the record for 11/13 is below the added rows.