G
Guest
I have 2 worksheets that I want to group and copy. In Excel 2003 when I
select the 2 worksheets and create a copy I'm prompted to create a new name
for the reference cells so the formulas don't refer back to the wrong
worksheet, in addition the grouped worksheets have formulas and values that
refer to each other and are automatically updated to the new copies names
(again so they don't refer to the originals but the copied worksheets).
In the new Excel (2007 Beta) this doesn't happen and I'd have to manually
update all the formulas and named ranges.
Any help would be appreciated.
select the 2 worksheets and create a copy I'm prompted to create a new name
for the reference cells so the formulas don't refer back to the wrong
worksheet, in addition the grouped worksheets have formulas and values that
refer to each other and are automatically updated to the new copies names
(again so they don't refer to the originals but the copied worksheets).
In the new Excel (2007 Beta) this doesn't happen and I'd have to manually
update all the formulas and named ranges.
Any help would be appreciated.