View Single Post
  #1   Report Post  
KevinB
 
Posts: n/a
Default Copy and Paste Formula Without the linked file path

Hi, I regularly cut/paste Worksheet cells (with formula's) into a different
Workbook.

I want to keep the formulas "as is" and NOT have the linked workbook name
included in the formula.

Incorrect: ='[MasterFile.xls]Show Approval'!L111

Correct: ='Show Approval'!L111

Is there a paste feature to NO include the linked path in the formula?