I have an excel file (original) with A and B sheets and a cell of B points to a cell of A. When I try to copy the original sheet B to a new excel file the reference in the new B sheet cell contains ...
If I understand what you're trying to do, it needn't involve copying. Instead, if you just take both sheets A and B (i.e., the whole workbook) and do a "Save As" or "Save a Copy" and give a different name. And do this repeatedly. But that's if I understand what you're doing.
