Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have many many many graphs in one file, all linked to external sources.
For some reason the graphs are still referring to some files that were copied over to other names (all files were open, the data files were saved as different names, then the graph files saved). My problem is I need need them all to refer to the new names. Bottom line. Is there a function or macro code someone can give me that will, in a given one of these graph files, look at each graph, and then print up a little list (some separate "sheet 1" tab) of all graphs and their source data locations? That way I can just spot the ones that have the old links, go into those specific ones, and fix. Whereas now I would have to look at each one of them individually. -- Boris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel graphs not updating when source data is changed | Charts and Charting in Excel | |||
Macro to Update Charts Source Data | Charts and Charting in Excel | |||
Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
Graphs/Charts by country. Same Graph, different Source Data | Charts and Charting in Excel | |||
Change graph's source data via macro | Excel Programming |