How to prevent a graph update

[Öregjani]

I have a workbook, containing different sheets with data acquired as readings
of an instrument. These data are visualized on a graph. located on the same
sheet. Finishing the data acquisition I copy this sheet and paste it in a new
worksheet, and rename the sheet according the sheet name it was copied from
and adding to the name a serial number. I save this new worksheet with
UpdateLinkNever option. But when I repeat the data acquisition using the
"master" workbook, and copy the newly acquired data conatining sheet in the
workbook former saved with the above option, the graph on the sheet copied
former in this workbook will be refreshed with the newly acquired data,
living the cells containing the source on this sheet unchanged. How can I
copy a sheet containing data and graph in a new woksheet such a way, that the
graphs data surce will be updated for the new location of the sheet?

 

[ker_01]

I believe the updatelinks only refers to links outside the workbook- so if
you are pasting new data into the workbook, any graphs that reference that
data sheet would update.

Consider this alternative approach; when copy/pasting the graph, copy/paste
as picture, rather than as an Excel object. To see sample code for XL2003:
1. start recording a macro
2. select a graph or range of cells
3. hold down the shift key and click
4. Click the edit menu
5. Select "copy as picture"
6. Paste the image to your target sheet

note that copy as picture gives several options, so you may want to test
each in advance to see which one you really want to record.

You didn't mention which version of Excel you are using; if it is 2007, then
check the help menu or google for the specific steps or syntax to copy or
paste as picture.

HTH,
Keith

 

[Öregjani]

Thank you for the idea, but this solution in my case is not optimal, because
I loose the possibility for occasional editing the graphs. I'm thinking now
about the editing the references of graphs according the post-paste location.

„ker_01†ezt írta: