LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel graphs not updating when source data is changed James Carlson Charts and Charting in Excel 0 May 23rd 06 06:44 PM
Macro to Update Charts Source Data [email protected] Charts and Charting in Excel 1 October 18th 05 03:22 AM
Excel changing number formatting and source data in graphs on it's own!!! JohnHamer Excel Discussion (Misc queries) 2 September 22nd 05 02:29 PM
Graphs/Charts by country. Same Graph, different Source Data Dan_Green Charts and Charting in Excel 0 July 19th 05 01:37 PM
Change graph's source data via macro flipflop Excel Programming 0 December 1st 04 03:37 PM


All times are GMT +1. The time now is 05:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"