Why yes, that is the case. So if I understand right, when my source workbook
has multiple sheets, this is what I can expect. Thanks for the clean up tip.
JB

"GSnyder" wrote:

Hi, JB.

One thing I can think of is if your formula in the first worksheet refers to
another sheet in that workbook, it will retain that link even if you copy it
to another workbook. For example, if you copy =$B$8 to another workbook, it
will simply copy over and refer to the new workbook. No problem.

But if you copy =Sheet2!$B$8 over to a new workbook, it will try to hang
onto its link to that worksheet in the original workbook and it will copy
over as =[Book1]!Sheet2!$B$8.

Could that be what's happening to you?

If so, you could use search and replace to find all instances of [Book1] and
replace them with nothing.

--
Happy calculating!

If you like this answer, please click ''Yes.''




"JB" wrote:

Suddenly when I copy/paste between workbooks, the pasted formulas contain an
external link to the source workbook. Is there a setting I have changed
accidently, that is causing me to inadvertently creat external links?