I have two workbooks with 3 sheets each. Sheet three has cells with formulas that appear like this:
=Sheet1!D3
When I copy from the first workbook and paste these cells to a new workbook they apear like this:
='[ Service Today.xls]Sheet1'!D3
I need to copy the cells as the formula originally reads. It is automatically adding [Service Today.xls] which is causing the new workbook to refer back to the first. I need it to refer to itself. Going to each cell and deleting this tag is time consuming. Please help!!
Bookmarks