Excel (Office 2000) - problem with formulas becoming too long when copying

[dipsy10]

Hi.

I have a sheet within a workbook that I would like to copy into many
other workbooks that are of the same format. The sheet necessarily
contains some formulas that are quite long (with references to other
sheets in the workbook). Hence, when I copy the sheet, or just the
cells to the other workbook, and the filename of the original workbook
gets carried through too, the formulas become too long and don't work.


Is there anyway of not taking the filename across too? Because I want
the formulas to refer to the sheets in the new workbook, not the
original anyway.

Hope this makes a little bit of sense to someone,

Thanks

 

[Niek Otten]

You can replace the "=" sign with some harmless character (like "|") before
copying and re-replace after pasting. That way Excel will not recognize the
cell contents as a formula and not adjust the addresses.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[dipsy10]

Not too worry, a brainwave figured one way of doing it at least. By
replacing = with # and copying that instead, then obviously
re-replacing the # with =. Don't know if it's the ideal solution but
it'll do for now!

 

[dipsy10]

Thank you!!

See, it took me hours to think of that. Should have come here sooner