When I make a copy of a worksheet (into a new tab in the same workbook) that
contains a crosstab, the cell references of the crosstab retain the reference
to the original (old) worksheet. This is not what I want.

In other words, when I copy a worksheet that contains crosstabs, I have to
go into each crosstab on the new worksheet and reset all the cell references
to point to the new worksheet (instead of the old/prior/original worksheet).

This appears to me to be a different behavior then a regular "cell". If the
original cell references "A1" on the old worksheet, after the copy, the same
cell references "A1" on the NEW worksheet. But NOT FOR CROSTABS!!

Is there any way to have the crosstab reference the NEW worksheet instead of
the original worksheet ?

FYI, The technique I use to copy a worksheet is to right-click the tab at
the bottom - "move or copy" - "Move to end" - check "Create a copy".

Sorry for the long post - it's hard to explain. Using Excel 2003 SP2.

Thanks,

Peter

--