"...to become the leader in providing faster, friendlier, and more affordable subscription-based computer support services."

Ask Dr.Tech solution database


How to Link Objects in MS Office Documents

Saturday, 19 September 2009 20:23 by Tom

Different types of objects could be inserted to MS Office documents including pictures, spreadsheets, sounds etc. There is two options: you can embed the object or link it. Embedded objects don't reflect changes of the sourse files while linked objects do.

Linking means your two documents are linked, as in connected to each other. You have your original file (source), and you have a second document (destination) where you linked the first file (source). You can maintain the connection between the two. When you update the original (source) document the second file (destination) is updated as well.

For example create graph in Excel. Copy the graph by using right click on the graph.

 

copydatatable_excell.jpg

 

Go to PowerPoint and place in on a slide. Use the edit menu and select Paste Special.

 

pastespecial_powerpoint.jpg

Choose Paste Link and click OK.

 

pastelink.jpg

 

Now you can update numbers in Excel. Both copies of the graph will be updated.


Sign up now - $98.00 annual plan
Also available plans: 15 day money back guarantee
per-incident $37.00
month to month* $47.00
* Plans include unlimited number of support incidents

A “must-have” service


Using Ask Dr. Tech is like having your personal technician always at hand *
* for only 26 cents per day