Hi!
I created a template with a bunch of formulas that I want to copy to another worksheet. Some of the formulas in the template refer to sheets locally in the .xsl file, for example: "='Results N1'!Q1".
What I want to do is for the formulas to function as they do in the template, to copy what is in the "Results N1" into another window called "To Drive".
What happens instead is that when I copy the template into another workfile with another name, it refers BACK to the parent workfile with square brackets [].
I have tried to do a "Find and Replace all" on the [] but when I click "Replace all" a window pops up wanting me to refer to a worksheet. If i refuse, the cell is filled with "#REF". If I delete the cell, and type in "='Results N1'Q1!'", it still wants me to refer to the original worksheet.
I have tried to go to Data -> Edit Links -> and refer to the worksheet I am copying to. It still does not work.
Any ideas?
I created a template with a bunch of formulas that I want to copy to another worksheet. Some of the formulas in the template refer to sheets locally in the .xsl file, for example: "='Results N1'!Q1".
What I want to do is for the formulas to function as they do in the template, to copy what is in the "Results N1" into another window called "To Drive".
What happens instead is that when I copy the template into another workfile with another name, it refers BACK to the parent workfile with square brackets [].
I have tried to do a "Find and Replace all" on the [] but when I click "Replace all" a window pops up wanting me to refer to a worksheet. If i refuse, the cell is filled with "#REF". If I delete the cell, and type in "='Results N1'Q1!'", it still wants me to refer to the original worksheet.
I have tried to go to Data -> Edit Links -> and refer to the worksheet I am copying to. It still does not work.
Any ideas?