How to Save an Excel Workbook as a PDF Directly to SharePoint or OneDrive
Question details
The user wants to export an Excel workbook as a PDF file directly into a shared SharePoint or OneDrive folder directly from the web browser.
- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Attempting to convert and save an active spreadsheet as a PDF directly to a cloud location (SharePoint or OneDrive) while working in the web version of Excel.
- Observed behavior
- Excel for the web lacks a native direct 'Save As' option to export an XLSX workbook to a PDF in the same shared SharePoint or OneDrive folder.
Make sure you have the Excel desktop application installed on your device or have access to Microsoft Power Automate, as these tools are required to bypass the web app's limitations.
Use the Excel Desktop Application to Export the PDF
Opening the workbook in the full desktop application gives you access to advanced export features, allowing you to save the PDF directly to any synced cloud location.
While the web version of Excel provides quick access to your files, it does not support advanced direct-to-cloud PDF exports. Switching to the desktop app is the most straightforward way to accomplish this task.
While viewing your workbook in Excel for the web, click the 'Editing' dropdown or look for the 'Open in Desktop App' button on the ribbon to launch the file locally.
Once the desktop application opens, click on the 'File' tab in the top-left corner, then select 'Export' from the left-hand menu.
Click 'Create PDF/XPS Document'. In the save dialog box, navigate to your synced SharePoint or OneDrive folder on your computer, choose your desired file name, and click 'Publish'.
Automate PDF Conversion with Power Automate
Create an automated workflow that generates a PDF from your Excel file and saves it to a specific SharePoint or OneDrive destination without manual export.
Easily Export Spreadsheets to PDF with WPS Office
If you are frustrated by the export limitations of web-based spreadsheet applications, consider switching to WPS Office. It provides a lightweight, highly compatible desktop suite that lets you instantly export spreadsheets to PDF and save them directly to any local or cloud-synced folder for free.
- 1. Open Your File: Launch WPS Spreadsheet and open your .xlsx document.
- 2. Export to PDF: Click on the 'Menu' or the 'Tools' tab, and select 'Export to PDF'.
- 3. Save to Cloud Directory: Choose your synced OneDrive or SharePoint directory as the output path and click 'Export'.
Frequently Asked Questions
Why can't I save an Excel web file as a PDF directly to SharePoint?
Excel for the web is designed as a lightweight editor and currently has limited file conversion capabilities. It does not support directly pushing a converted PDF file into the same cloud directory from within the browser interface. You must download the PDF locally or use the desktop app.
Can I use a VBA macro to save a PDF to SharePoint?
Yes, if you open the workbook in the Excel desktop application. You can use the ExportAsFixedFormat method in VBA and specify the mapped SharePoint network drive or the synced local path as the destination folder.
How do I request this feature to be added to Excel for the web?
Microsoft accepts feature requests through their official feedback portals. You can submit or vote for this feature by navigating to Help > Feedback in Excel for the web and describing your need to save PDFs directly to SharePoint.
Will saving the PDF to my local OneDrive folder update SharePoint?
Yes, if your SharePoint document library is synced to your device using the OneDrive sync client. Saving the PDF to that specific local folder will automatically push the file to the shared SharePoint library in the cloud.
