Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In one workbook, I have 66 graphs that get updated each month. There are 5
graphs displayed per tab. To update the graphs each month, I update the links to the graph file and then check all the graphs to ensure they have been updated before I save and close the file. However, when I reopen the graph file, I discover that some of the graphs are no longer updated. Out of 66 graphs, only about 10 - 15 don't get updated. I then update the links again and then all the graphs look good again, so I save and close the file. But once again I reopen the file and find still some more graphs no longer updated, about 5-10 this time... this goes on and on until all the graphs remain stable. Can someone tell me what's going on and what can I do to fix it. Thanks, Mary-Lou |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Updating graphs in Excel using a macro | Excel Discussion (Misc queries) | |||
Automatic Updating of Graphs | Charts and Charting in Excel | |||
automatically updating graphs based upon conditional variables | Charts and Charting in Excel | |||
Excel graphs not updating when source data is changed | Charts and Charting in Excel | |||
Automatically updating Graphs | Excel Worksheet Functions |