Ã
Ö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?
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?