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