Pasting Formulas Without Links

[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

 

[Niek Otten]

Look at Bill Manviile's FindLink add-in.

http://www.oaltd.co.uk/MVP/

 

[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

 

[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

 

[Stephen]

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

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