This may be a bug in XL 2007.

Best thing to do is contact the XL 2007 bloggers, he
http://blogs.msdn.com/excel/ and ask if they are aware of a similar issue.

Dave
--
Brevity is the soul of wit.


"sc" wrote:

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.