Hi,
After unzipping xlsx and modifying many stuff in xmls(both changing formulas and changing inputs of chart series and so on) I need to refresh my excel file fully.
Alt + Ctrl + Shift + f9 (Application.CalculateFullRebuild) is doing it partially, it updates values of formulas. But my charts are not showing the updated results. Actually I understand the reasons are coming from xmls that I should provide more time there modifying other values which are related directly to GUI, but solving it will be too much time consuming.
One way to solve it is, I am saving my file then reopening it, and they are ok (excel creates all connections correctly and modifies all data while saving), otherwise I have to delete each series and create it again to see it correct. Is there anyway to refresh my xlsx by vba or manually, but not save and reopen, because all my scripts should be used by other users and do not want to make extra inconvenience for them, such as open xlsx, refresh, save, then reopen then use another vba...
Thanks in advance,
Sam
Bookmarks