Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 02-25-2011, 07:29 PM
rtlight rtlight is offline Use changeable table data in doc text? Windows Vista Use changeable table data in doc text? Office 2007
Novice
Use changeable table data in doc text?
 
Join Date: Feb 2011
Posts: 3
rtlight is on a distinguished road
Default

I appreciate your feedback; it prompted me to give linking another try.

Today I linked a test Word Doc to a test Excel Sheet and it seemed to work well. I had not realized until I played with it that one could select the .rtf option (under Paste Special) when linking to an Excel sheet and get the data pasted as an easily editable table. Previously I thought I had to link to the Excel object and ended up with a piece of a worksheet embedded in my Word doc which I couldn't format. Then, instead of trying to bookmark the individual cells from the linked table, as you pointed out, I link to the Excel data for the text data I need to insert.

I see your point about templates vs. re-usable documents. I will plan to create a re-usable file with a "constant" name and link it to an Excel sheet which will also have a "constant" name. The real Excel work will be done in a different workbook and then the needed content will be pasted to the Excel source with the constant name. Similarly, after the Word doc has been filled with the needed data, I'll simply copy it to another file and break the links.

Once the links are broken, as far as I can see, they can not be toggled and thus remain invisible to a reader.

Mailmerge is not an option I considered since the data I have to embed would involve several thousand fields, if each cell of a linked table is counted separately. I will keep it in mind for the title page of the document.

Thank you again for your thoughtful advice.
Reply With Quote
 

Tags
tables



Similar Threads
Thread Thread Starter Forum Replies Last Post
Use changeable table data in doc text? Table Text Alignment? Jazz43 Word Tables 2 08-19-2010 08:07 AM
VISIO - Formatting Shape Data Details TABLE Lora Visio 0 07-19-2010 12:15 PM
inserting a string of data into an MS Word table??? matto Word VBA 0 07-16-2010 09:35 AM
pivot table source data hannu Excel 0 07-03-2010 04:54 AM
Use changeable table data in doc text? extracting data from Table to text file Anirudh_Dsp Word Tables 1 05-23-2010 07:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:37 PM.


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