Microsoft Office Forums Problem with Covnverting Linked Excel Data to Text

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-25-2009, 07:30 PM
trapdoor trapdoor is offline Problem with Covnverting Linked Excel Data to Text Windows XP Problem with Covnverting Linked Excel Data to Text Office 2007
Novice
Problem with Covnverting Linked Excel Data to Text
 
Join Date: May 2009
Posts: 1
trapdoor is on a distinguished road
Default Problem with Covnverting Linked Excel Data to Text

I was wondering if your superior knowledge of word could help me out with a vexing problem:
I have a Word document with links to excel because I want the data to automatically update when I change the Excel sheet. That works fine. Then, once the info has been updated from the excel sheet to word, I want to take that info and make into unlinked text so I can email the word document to my boss without having to include the excel sheet. I know that you can copy the data that is linked to Excel, copy> paste special> paste as formatted text and just have the values of the data and not the link, but I want to do this for the entire Word document and not have to copy>paste special each time because there are well over 100 links in the Word document. I've tried copy>paste special but that doesn't break the links. I've tried to do this with Office X for OS X as well as Office 2008 for OS X. I'm going to try it on Windows tomorrow as well.


If any one has any insight, I would be very grateful.
Thanks,
John
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Covnverting Linked Excel Data to Text Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM
Excel not saving all data and formatting TRT Excel 2 04-09-2009 12:51 PM
Outlook Form that Saves Data to Excel dcbrown Outlook 0 12-29-2008 06:25 PM
Automatically entering/fill data in cells in Excel 2003 dipdog Excel 0 08-17-2006 08:37 AM
Problem with Covnverting Linked Excel Data to Text Refreshing Data in Excel jamal420 Office 3 06-13-2005 03:45 PM


All times are GMT -7. The time now is 05:13 AM.


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