How to Import a PDF Into Excel 2007
Excel 2007 is a powerful spreadsheet program you can use to balance your checkbook, analyze statistics or plan budgets, even for an entire business. While Excel has plenty of built-in options for graphics, you may still need to insert existing files, like PDFs, within the spreadsheet. Inserting a document is fairly straightforward and only takes a few minutes, but as of the time of publication, Adobe Reader X causes an error with PDF insertion, so you have to correct that error first.
Turn Off Protected Mode
Launch Adobe Reader by clicking "Start" in the lower-left corner of your screen and typing "Adobe Reader" in the search field. Click "Adobe Reader" when it appears in the search results.
Click the "Edit" menu at the top of the screen, and then click "Preferences."
Select "General" in the left pane.
Click the check box to remove the check beside "Enable Protected Mode at startup." This option is in the "Application Startup" section near the bottom of the "Preferences" window. If the "Protected Mode" option is not listed, your version of Reader does not have this option, so you do not need to take any action.
Click "Yes" in the window that appears, and then click "OK" in the "Preferences" window.
Close Adobe Reader.
Insert the PDF
Open the Excel document into which you're going to put the PDF.
Select the cell you want the PDF on. The PDF's upper-left corner will align against the cell's upper-left corner. You can, of course, move the PDF later, if you prefer.
Click the "Insert" tab at the top of the window, and then click "Object" in the "Text" group.
Select "Adobe Acrobat Document" from the "Object type" section.
Click "OK" to display the "Open" window.
Locate the PDF you want to insert in the document.
Select the PDF and click "Open." The PDF will open in Adobe Reader and insert into your Excel document.
Turn "Protected Mode" back on in Adobe Reader using "Preferences" in the "Edit" menu.
Tips & Warnings
- "Protected Mode" isn't required for Adobe Reader to function properly, but it is a strong security option that helps keep your system safe. While it's fine to turn it off temporarily to insert a PDF into Excel, you should always turn it on and leave it on afterward.