Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy of a Worksheet Does Not Update Chart References
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Update worksheet references as new worksheets are added | Excel Worksheet Functions | |||
Copy worksheet with row & column references | Excel Discussion (Misc queries) | |||
copy/Paste references other worksheet | Excel Worksheet Functions | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Copy worksheet without absolutle references | Excel Worksheet Functions |