Report Offensive Message
RE: Anatomy of Word: Using Excel information in Word documents
I have one problem when I use the "paste link" option when doing the paste special of an Excel Worksheet Object. When I open the Word document, it automatically opens the Excel file it's linked to in the background. However, the Excel file is invisible to the desktop. When I try to open the Excel file separately I get the message that it's already open. I have to close the Word document and open the Excel file first. Anyone have a solution for this? My boss prefers the links rather than an embedded link to the worksheet.