Changing Multiple Formula

S

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
 
B

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)

Samkat said:
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?
Click to expand...
creating financial statements
 
C

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.
-----Original Message-----
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?


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by
Click to expand...
step guide to
creating financial statements


.
Click to expand...
 
Top