#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Refreshing Data in Excel | jamal420 | Office | 3 | 06-13-2005 03:45 PM |