Why can't I insert a PDF file in Excel?
This question has been asked in multiple forums including here and here, with the solution of selecting from the drop-down menu "Insert", then "From Other Sources", clicking on the browse button, and finally choosing the directory where the PDF file is located.
There are two problems I have with this: It's not immediately clear that we're in fact selecting from other sources, and not from the open Office documents (such as an ODF file). I suspect that it might better if it worked directly from a directory rather than from a file. I'm not convinced that it would be easier for people to find a file on a computer or network than a directory.
In any case, the instructions are quite clear, but why doesn't it work for me? I have Microsoft Office 2025, and the latest version of the PDF Library for Windows (8.0).
I haven't actually tried this, but you may have to do a bit of registry hacking: right click your desktop, choose "Computer Management", go to "Settings", and look for "Registry Files". You'll see all of the registry keys used by Windows, and among them one key named "Microsoft" where you will find what you need. I think it will be called something like "MicrosoftOpenOfficeMSExcel4OpenOffice.orgMS Office" (where "4" is probably the version).
I suppose you could also try this: In Word: File > Open > Choose the file location (open a folder you want to use). On the open dialog choose "File" > "Save As." > "Choose a Location" Or in Excel: File > New > Blank Worksheet. Choose where you want to save the file, and change "Save as type" to "Microsoft Office format (*xls)". If your documents have macros, they'll still run just fine on any machine with Office installed.
How do I insert a PDF to Excel 365?
There are some limitations to inserting a PDF file to a sheet of Excel 365.
PDFs can only be inserted from a desktop application such as Microsoft Word, and users can't search or modify PDFs in Excel. However, there are options available. This post will cover the process of inserting a PDF into a document.
The process is pretty straightforward, so I won't go into details on how to open a PDF in an Office 365 application, but rather on how to get the PDF into Excel 365. When you click on the link above, it will take you to the Microsoft SharePoint site, where there are several tutorials for inserting a PDF file into your Excel document.
After you insert the file, you will then need to save the changes to your Excel file. If you don't want to make the changes, just cancel the upload process by hitting the cancel button at the bottom right corner of the upload page.
Insert a PDF in Excel. You will need to open your Excel document and then open the SharePoint site you received the link from earlier in your browser. After you open the SharePoint page, you will notice that your uploaded file is highlighted. Selecting this highlighted area will show you the entire folder structure with all your files, including the PDF file.
Click on the PDF file. You should see a box open up showing the file itself, and a few other buttons, as seen below.
At the top of the screen, click on the Select File button. Now, click on the Open with button. This will open your browser and you will be redirected to the website where you can select another file, or you can click the Open button to open the file in your Excel document.
Once you have your file opened in the Excel document, select the highlighted area. This will display a window similar to the one below. If you have a PDF with more than one page, you may need to select all pages of the PDF by holding down the Ctrl (control) key while clicking the Open button.
When you click OK, you will be prompted to save the changes to your Excel document. Make sure that you check the box for Ask me before saving changes to Microsoft Excel files.
How do I insert a PDF in an Excel worksheet?
I am trying to insert a PDF file as an image in an Excel worksheet, and I am stuck with this error: Run-time error '1004': Application-defined or object-defined error.
I am using Office 2025. The following is the VBA code that I have been using, but it fails on the line where I am trying to insert the image.
Sub InsertPDF(). Dim wb As Workbook. Dim fName As String. Dim fNum As Integer. FName = "C:UsersDocumentsFile.pdf" fNum = FreeFile(). Open fName For Input As #fNum. ActiveWorkbook.Sheets(1).Shapes.AddPicture fName, msoFalse, msoTrue, Left, Top, Width, Height
Close #fNum. End Sub. I am not sure what I am doing wrong. Try adding the path to your pdf file to the open statement, rather than just using the file name.
How do I embed a file in Excel 365?
This is a very common question and my answer below will cover both Office 365 and the older desktop versions of Excel.
Here's what you need to do to embed a file into an Excel workbook. Make sure the file is added to your OneDrive as a folder. Open the workbook you wish to embed the file into, right click on it, and select Embed from the context menu. You can also use the Insert > File option. Note that not all documents can be embedded.
You can embed a PDF, a Microsoft Office document (.docx, .pptx), or a PowerPoint presentation (.pptx) if the document you want to embed is in one of those formats.
If you want to embed a Word document (.doc), PowerPoint presentation (.ppt), or a PowerPoint slide (.pptx), then you must convert the document to one of these formats. You can find instructions for how to do this here: Convert DOCX, PPTX, or PPTM to a new format.
In addition, there are some files that can't be embedded. If you're going to embed a photo, video, or audio file, then make sure that it's in one of the supported formats.
If you don't know what format the file is in, you can use the free online converter at this link: www.office.com/word/convert-to.html. The site will give you a preview of the file so that you know what type of file it is.
Related Answers
Is there a free program to convert PDF to Excel?
I've seen a few programs that are supposed to be able to c...
How can I open a PDF file in Excel for free?
How to Convert PDF to Excel for Free. Convert PDF to Exce...
Can I copy PDF data to Excel if the PDF file is in a foreign language?
I have a PDF that I need to copy inf...