Accessing Excel through a PDF File

by Allen Wyatt
(last updated May 10, 2014)

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.

Author Bio

Allen Wyatt

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. ...

MORE FROM ALLEN

Read-Only Embedded Fonts

If you receive a document from somebody else, you might not be able to edit it if the document contains fonts that you don't ...

Discover More

Entering Numbers in Excel

Enter information into a cell, and Excel needs to figure out what type of information it is. Here's how Excel interprets ...

Discover More

Using Fractional Number Formats

If you want information to display on the screen using fractions instead of decimals, you're in luck. Excel provides ...

Discover More

The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!

More WordTips (menu)

Processing Information Pasted from a PDF File

When pasting information copied from a PDF file, you can end up with a paragraph for each line of the original document. It ...

Discover More

Converting PDF to Word Documents

One way that documents are commonly shared with others is in the form of a PDF file. Getting information from a PDF file back ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 8 - 2?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


This Site

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.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.