H
HoboDan
So I have this worksheet called D09. When I do a Move or Copy of the
worksheet and select the Copy box, it creates the new worksheet. I then
proceed to rename it to D08.
BUT, when I import the data into the new worksheet my chart does not work.
When I look at the source data, the thing still references D09. So for
example:
='D09'!LeftLIVP
When it needs to be:
='D08'!LeftLIVP
I even tried creating a template of this worksheet and inserting it that
way, but it fails to update the chart reference every time.
Is there any way to fix this? Excel 2007.
-HoboDan
worksheet and select the Copy box, it creates the new worksheet. I then
proceed to rename it to D08.
BUT, when I import the data into the new worksheet my chart does not work.
When I look at the source data, the thing still references D09. So for
example:
='D09'!LeftLIVP
When it needs to be:
='D08'!LeftLIVP
I even tried creating a template of this worksheet and inserting it that
way, but it fails to update the chart reference every time.
Is there any way to fix this? Excel 2007.
-HoboDan