A
Andy Sandford
Hi all,
I need to use data in my source workbook in another, destination, workbook -
however, I don't want the data to automatically update in the destination
workbook when data in the source workbook is changed. I thought I could link
to it, and then configure Excel to only update the info when I select it
manually.
When I copy the data, then paste it as a link, then go to EDIT-LINKS on the
toolbar, the manual tab isn't available.
Unfortunately, after trying for ages I finally found the following in the
Help file!
"Note You can't paste worksheet cells or a chart as a linked or embedded
object in a Microsoft Excel workbook. However, you can use the Copy Picture
command (hold down SHIFT and click the Edit menu) to create a link to cells
on this or another sheet or workbook."
Obviously, if I use the picture option I can't manipulate the data - only
stare at it for hours, helplessly!
Is there a way I can get round this - either by tackling it a different way
in Excel, or by the use of VBA.
Cheers
Andy
I need to use data in my source workbook in another, destination, workbook -
however, I don't want the data to automatically update in the destination
workbook when data in the source workbook is changed. I thought I could link
to it, and then configure Excel to only update the info when I select it
manually.
When I copy the data, then paste it as a link, then go to EDIT-LINKS on the
toolbar, the manual tab isn't available.
Unfortunately, after trying for ages I finally found the following in the
Help file!
"Note You can't paste worksheet cells or a chart as a linked or embedded
object in a Microsoft Excel workbook. However, you can use the Copy Picture
command (hold down SHIFT and click the Edit menu) to create a link to cells
on this or another sheet or workbook."
Obviously, if I use the picture option I can't manipulate the data - only
stare at it for hours, helplessly!
Is there a way I can get round this - either by tackling it a different way
in Excel, or by the use of VBA.
Cheers
Andy