PDF/Office Open and Save. Step 4. Link a Microsoft Excel Worksheet to a PDF document — Microsoft Office Blog (Note: This feature is now available if linked Office applications are on the same computer. It isn't required for linked Office applications to be on same Mac/Windows System. However, this works with PDF files that are already embedded, and you may want to refer back to this article.) You may link a spreadsheet and a PDF document. When you create a PDF file, you may link an existing Excel worksheet so that the spreadsheet works with the PDF document. To do this, open the PDF file in Microsoft Office, and click on File. Select Add > Link. Select Excel Worksheet (or an Excel formula bar and the sheet name on the spreadsheet), and click OK. When you open the file in MS Office 2023 or later, there is a column of buttons that you can click to customize the way in which the document is opened. To save Excel data to the PDF, select the PDF link. If you change your mind in the middle of the text, you can use Ctrl+X to cancel the link. Selecting the PDF link works only if it is the same open to reading that you created the file to view. If you change your mind after opening the document to view, you may wish to close the PDF file so that your Excel data is no longer there. If you have an existing PDF document from Office that you don't currently use, you can link it to any of your existing open Excel worksheets. The following link-up procedure may not work for you. Step 5. Embedded Excel worksheet: When a user opens an Excel file, or adds a spreadsheet that has an embedded Excel worksheet, the embedded Excel worksheet will be loaded in the opened worksheet as a new worksheet. The embedded Excel worksheet should be listed as Active when displayed in the worksheet list. As soon as you create a new Worksheet with a new Office document, the embedded Excel worksheet will replace the existing worksheet and will stay in sync with the new worksheet's data. You can add or remove the worksheet from the worksheet list by right-clicking in the table view cell or by using the Insert > New > Worksheet menu item. Workbooks: The embedded Excel worksheet will appear in the main table view worksheet. You can add a worksheet by copying the worksheet name or an Excel formula bar's name.