What happens with Excel 2007:

1. Get two columns/rows of data
2. Create a chart out of the first column/row
3. Create custom error bars out of the second column/row (I go to Graph
Tools Layout Error bars More options Custom; I select the second
column both for positive and negative error for the sake of simplicity)
4. Duplicate the current sheet (I hold ctrl, drag the sheet label on a new
position and release both)
5. Switch to the new sheet
6. Change the graphed data. Notice the new chart updates correctly
7. Change the error bar data. Notice nothing happens.
8. Change the error bar data on the old worksheet. Notice both charts update
with the new value.
9. Reach the custom error bars dialog for the new graph.
10. Notice both fields incorrectly display ={1}

What should happen:
* Custom error data references are correctly updated on duplication
* The Custom error dialog correctly shows the worksheet reference

What happens instead:
* Custom error data references stick to the old reference
* The Custom error dialog incorrectly shows "={1}".