Thread
:
Paste Special Question
View Single Post
#
2
Don Guillett
Posts: n/a
One way is after the pasteeditlinkschange link to current workbook
--
Don Guillett
SalesAid Software
"Kevin" wrote in message
...
Hi,
I am pasting cells from a worksheet from one xls file into another xls
file.
After I paste the cells, the formulas reference the source xls file. Is
there a way to "Paste Special" to keep the formulas, but NOT include the
xls
referenced file name?
Example Formula: ='Show Approval'!L51
Current Result of Paste: ='[SourceFile.xls]Show Approval'!L51
After paste, I want the formula to remain as: ='Show Approval'!L51
Thank you!
Reply With Quote