The first issue I have is that when I copy an entire worksheet which includes multiple charts, all of the charts keep the reference to the origin sheet in their data definitions. This makes me blue because I just want to be able to paste new data into the new sheets and be done! But instead I must go through and tweak all of the various data sources for all of the charts and in this situation that is a time consuming proposition. I could swear that I have been able to do this before without even trying but cannot figure out how to do it now. Is there a certain way to do the copying that will achieve this?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.