> >I have two Excel worksheet files: Test1.xls and test2.xls. Both are
> >multi-sheet files.
> >I have a formula on test1.xls sheet1 that references sheet2. I want to
> >copy the formula to test2.xls and have it references sheet2 on
> >However, when I copy the formula to test2.xls, it retains the remote
> >reference, copying the formula with a link back to sheet2 of test1.xls.
> >How can I copy so that the references retain there original _relative_
> >positions in a new file?
> Hi Hays,
> if I understand your problem here my solution: Edit your formula make
> it a text by entering a sign e.g. # in front of the = then copy the
> text in the new position remove the #. Of course after that remove the
> # in the original formula too.
> Henner Juengst
Thanks for your response. Yes, your solution would work, I'm sure.
But, in my practical application, I have a spreadsheet full of these
types of formulas and it is impractical to do that to the whole
I think that I could also do an Edit-Replace and replace all references
to the first file in the new formulas as a work around. I'm just hoping
that Excel has another and easier method to do this relatively common
(for me) application. In Lotus, there is no such problem, the Copy
copies the formulas with their _relative_ references, unless you tell it
differently by making references _absolute_.