Excel 2007 Question

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Go to data tab
with connection group, you will find "edit links"
click there and make your changes