Excel 2007 Question

Closed
crm - Feb 17, 2010 at 03:18 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 17, 2010 at 05:37 PM
Hello,

I know it is possible to copy an Excel 07 sheet (#1) into another Excel 07 worksheet (#2) and keep the data in tact.

What I want to know is once you copy from #1 to #2, is there an easy way to change the SOURCE worksheet (#1) other than going to each data series and changing it there?

I have a page of data that I am using to create graphs. Since some of the data is similar due to similar areas (but I must keep each particular area separate), I would like to create the data in one file and then just copy the chart into another worksheet. (Normally I create an original worksheet and then just file/save as....however, this time I had already created 4 other worksheets that need this data easily included in them).

Thank you for your help,
Cheryl

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Feb 17, 2010 at 05:37 PM
Go to data tab
with connection group, you will find "edit links"
click there and make your changes
0