Hi,
I copied a sheet from book1 to book2. The formulas in the sheet of book2 shows the name of book1 in the formulas. How can I remove these book1 references?
Example:
Formula after copying the sheet to Book2 is:
=IF('C:\Stony\[C5-C7_Corona.xlsm]Constants'!B14="","",'C:\Stony\[C5-C7_Corona.xlsm]Constants'!B14)
The formula in Book2 should look like this:
=IF(Constants!B14="","",Constants!B14)
Where Constants is a sheet in the the workbook.
Can this be done? I have 127 formulas in the sheet.
Khalil
Bookmarks