Linked Workbook problem

  • Thread starter Thread starter Andy Sandford
  • Start date Start date
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
 
choose tools --> options --> edit --> ASK to update
automatic links (check mark). This should give to update
or not when you open a file with links
 
Back
Top