View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BorisS BorisS is offline
external usenet poster
 
Posts: 191
Default graphs' source data macro

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