Copying formual without the file name

HI
I am wondering if there is a way no to display file names in the formulas when you copy paste the formula from another workbook. For example: if the formula is =sum(A1:A5) when you copy it from lets say Book1 to another workbook, formula shows =sum([Book 1.xlsx]A1:[Book 1.xlsx]A12)..I just would like to copy paste the formula to a new workbook as it is

Thanks