Copying worksheets with formulae between workbooks
 

I need to copy some worksheets from one spreadsheet to another and I want the
formulae that I have written in the original s/s to copy exactly to the next
s/s, WITHOUT adding in a reference to the original worksheet.

e.g. if I write '=formula' in spreadsheet1.xls I want it to copy across as
'=formula' as opposed to '=[spreadsheet1.xls]formula'

I could use find and replace to get rid of all the unwanted references but I
get 'formula is too long' errors as a direct result of the fact that excel
has added the unwanted reference!!

Help!!

Copying worksheets with formulae between workbooks
 

Maybe you could try:
Edit|links|change source

I like to do this:
I change all the formulas to plain old text in the original worksheet:
Select all the cells
edit|replace
what: =
with: $$$$$=
replace all

Then do the copy|paste

Then go back to both the pasted and original worksheet and change my strings
back to formulas:
Edit|replace
what: $$$$$=
with: =
replace all

You may get the same "formula is too long" with this technique--but it couldn't
hurt to try.

Paul wrote:

I need to copy some worksheets from one spreadsheet to another and I want the
formulae that I have written in the original s/s to copy exactly to the next
s/s, WITHOUT adding in a reference to the original worksheet.

e.g. if I write '=formula' in spreadsheet1.xls I want it to copy across as
'=formula' as opposed to '=[spreadsheet1.xls]formula'

I could use find and replace to get rid of all the unwanted references but I
get 'formula is too long' errors as a direct result of the fact that excel
has added the unwanted reference!!

Help!!

--

Dave Peterson