Written by Allen Wyatt (last updated October 8, 2020)
This tip applies to Word 97, 2000, 2002, and 2003
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.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
One way that documents are commonly shared with others is in the form of a PDF file. Getting information from a PDF file ...
Discover MoreWhen pasting information copied from a PDF file, you can end up with a paragraph for each line of the original document. ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
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.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2024 Sharon Parq Associates, Inc.
Comments