copying/moving a sheet from one spreadsheet to another

[kwvh]

I am pretty sure there is an easy way to do this, but I can't figure it out.

I have two spreadsheets, with multiple sheets. They are essentially similar, but one may have formatting different from the other. In other words, Spreadsheet1 has three tabs (Tab1,Tab2,Tab3), as does Spreadsheet2. I want to insert a copy of Tab2 from Spreadsheet2 into Spreadsheet1. The problem is all the formulae that are in Tab2 from Spreadsheet2 now include the original spreadsheet name (e.g. "=C:\MyFiles\[Intake_K1941.xlsm]Tab1'!U2") I only want the formula to be "Tab1!U2".

It is probably just a setting some place, but I can't find it.

Thanks for your consideration.

Ken

[HansV]

After copying, press Ctrl+H in the target sheet to display the Replace dialog.
In the 'Find what' box, enter the path and filename of the source workbook, e.g. [C:\MyFiles\[Intake_K1941.xlsm].
Leave the 'Replace with' box blank.
Click 'Replace All'.

[kwvh]

I didn't even think of that. I thought there might be a preference or setting that didn't copy the path and name.
Thanks, Hans!!