Pasting Formulas Without Links

S

SamuelT

Hi all,

Is there a means of pasting formulas from one workbook to another
without the formulas linking back to the original workbook?

Example:

When I do Paste Special>Formulas, I get:

='[Monthly Status Report Template v.2.0.xls]Summary'!$B$2

When what I want is:

=Summary'!$B$2

I'm going to have to do this to around 50 spreadsheets, so if I can
find an quick way of doing it, it's going to be really useful. Note:
there are a number of formulas per worksheet, otherwise I'd just delete
it it manually!

TIA,

SamuelT
 
S

SamuelT

Thanks Niek.

Thing is, I know where the links are located...there's just rather
lot of them. By the looks of it, the utility you linked to is good fo
finding links, but can't actually do anything about them, and wit
around thirty links per page manual deletion will have me here unti
2007!

Cheers,

Samuel
 
S

SamuelT

OK - think I've found a way...for anyone who's interested, I simply do a
Find and Replace on:

[Monthly Status Report Template v.2.0.xls]

Replacing with a blank. Seems to work!

SamuelT
 
S

Stephen

SamuelT said:
OK - think I've found a way...for anyone who's interested, I simply do a
Find and Replace on:

[Monthly Status Report Template v.2.0.xls]

Replacing with a blank. Seems to work!

SamuelT
Click to expand...

I believe you can also use the Update Links command on the Edit menu, simply
choosing to point the links to the current workbook.
 
Top