A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Automatically Updating Excel Data In Word Doc Inside Excel File



 
 
Thread Tools Display Modes
  #1  
Old August 29th, 2004, 10:55 PM
Business Design Architect
external usenet poster
 
Posts: n/a
Default Automatically Updating Excel Data In Word Doc Inside Excel File

I have inserted a "Word" object icon into an Excel file (Tab 1) and then used
paste link to display data updates from other tabs in the same Excel file in
the Word document that is in Tab 1. I am looking for a way to have the links
from the Excel Tab 1 file that are in the Word file automatically updated and
independent of the Excel filename.

Problem is that when I put the Word document icon into the Excel file, open
it, paste link data from the same Excel file and then rename the Excel file
later the links are not automatically reflecting the new Excel name. The new
Excel file name is showing "invalid link" references when I open the Word
document inserted in the original file.

I would appreciate anyone's assistance to find a workable solution so that I
don't have to have users trying to manually changing file links everytime
they rename their baseline Excel file that has the inserted Word document.

Thanks, David


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
You do not have exclusive access... ERROR Robin General Discussion 1 July 6th, 2004 01:18 AM
Tips for using Excel as data file in Word merge doct? StargateFanFromWork New Users 4 July 1st, 2004 04:53 AM
Product Key for Office XP P.G.Indiana Setup, Installing & Configuration 1 June 7th, 2004 03:22 AM
Word mail merge with Excel data Peter Jamieson Mailmerge 1 April 26th, 2004 07:30 PM
Merging Excel Data into Word Document Debra Dalgleish Worksheet Functions 1 February 16th, 2004 01:15 AM


All times are GMT +1. The time now is 06:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.