how do redirect

[Guest]

Hey people i have 48 graphs with external data sources and i would like to
know how i can rediect them to a new address other the editting all of the
series???

thanks
Gus

 

[Jon Peltier]

If the new external data sources have the same worksheet names and data in
the same cells, then you can use Edit menu > Links to redirect the links to
the new workbooks. If not, you will have to edit the chart or series source
data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______