Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-26-2011, 08:07 AM
rwbarrett rwbarrett is offline Link data from embedded excel sheet Windows 7 32bit Link data from embedded excel sheet Office 2010 32bit
Novice
Link data from embedded excel sheet
 
Join Date: May 2011
Posts: 1
rwbarrett is on a distinguished road
Default Link data from embedded excel sheet

I have a large document template that contains references and embedded worksheets. Is it possible to link items in the embedded worksheets to appear in the document without referring to the document name in the link (as the name will change as this is a template rather than a finished document). As an example, I have charts that are produced in the worksheet as data is updated that I'd like to be shown at the correct place in the document but if I use an OLE link it uses the document name for the link.
Reply With Quote
  #2  
Old 05-27-2011, 02:05 AM
macropod's Avatar
macropod macropod is offline Link data from embedded excel sheet Windows 7 32bit Link data from embedded excel sheet Office 2007
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi rwbarrett,

The source file's name is an essential part of the link. So, no, you can't have a link without it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link data from embedded excel sheet Embedded Excel functionality? markg2 Word 1 01-13-2011 02:17 PM
Excel 07-Access 03 Data Link Issue ddw23 Excel 0 08-20-2010 09:05 AM
Link data from embedded excel sheet How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM
Link data from embedded excel sheet Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM
Setting up Analysis Sheet when data does not exist, yet. burnoutdetective Excel 0 10-13-2008 05:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft