can I paste a formula to a new workbook that refers to a sheet in the new workbook, not the old one?

[TomCon]

I have two workbooks with a sheet named "dashb".

In one workbook I have a formula like this
=dashb!L2

If i copy/paste that formula into the second workbook, it comes out like this:
=[D4_p_TRK.xlsm]dashb!L2
In other words the old (source) workbook name is included in the formula. But, i want the pasted formula to refer to the sheet "dashb" in the new, destination workbook.

Is there any way to simply paste the formula from the first workbook to the second, without getting the old, source workbook reference in the pasted formula?

Thanks!

 

[JLGWhiz]

To copy formulas from one workbook to another without the attributes of the source workbook, copy from the fromula bar at the top of the sheet. If you are using VBA to copy, then use the PasteSpecial xlPasteFormulas method.