Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.
With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company.
Learn more about Allen...
Moira has a Word document that contains embedded Excel worksheets. When the Word file is saved in PDF format, the user is no longer able to access the Excel worksheets; Excel will not open. Moira wonders if this is normal and if there is a way the user can still access the Excel worksheets.
Yes, this behavior is normal, but it can be modified depending on how you create the PDF file. PDF files are meant to be—for the most part—static, not dynamic. You can, however, create PDF files that do incorporate some types of dynamic behavior, such as the ability to fill in forms and, within bounds, embed information that can be changed.
In order to take advantage of these advanced features, you must have a copy of Adobe's top-of-the-line version of Acrobat. The built-in printer drivers (such as those that create PDF files by "printing" from Word) won't allow you to utilize the advanced features.
One possible way around the problem (at least partially) is to include in the Word document a hyperlink to where the Excel workbook is located on the Web. PDF files rather routinely include hyperlinks, and the hyperlink to your Excel file would be no exception. The reader of your PDF file could then access the workbook through the hyperlink, but any changes made to the workbook would not be reflected in the PDF file.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (6468) applies to Microsoft Word 97, 2000, 2002, and 2003.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!