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!