copy original formulas from another spreadsheet

Topic

New Reply

How do you copy from one spreadsheet to another without linking the first spreadsheet. I only want to bring the original formulas. Paste special / formulas does not do it. Some of the formulas I want to copy link to different worksheets in the spreadsheet. Would this change the method?

Reply | Quote

Replies

Hi Len,

After copying & pasting, you can use Find/Replace to delete the external links – simply copy the external link part of a modified formula, paste it into the Find field of the Find/Replace dialogue box, then click on ‘Replace All’.

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

You might also try

Copy:

Followed by

Paste Special – Formulas

should work for most formulas.

Tom D

Reply | Quote