Changing Multiple Formula

[Samkat]

If I have more than one formula that are different but have within the
a link to another workbook is there a way i can change all of the link
in one go rather than going to each one and changing the information

 

[Bob Phillips]

Use the Windows Replace function, Ctrl-H

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

If I have more than one formula that are different but have within them
a link to another workbook is there a way i can change all of the links
in one go rather than going to each one and changing the information?


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[Chris]

There's 2 other ways to do this:

1) Edit|Links|Change Source
2) Open the source workbook, and "save as" the source
workbook as the new source you want to change it to. The
links on the original workbook will change with it.