Forum Discussion

7575Ben's avatar
7575Ben
Copper Contributor
May 23, 2024

Sharing Excel as a PDF

Hi,

I have suddenly become unable to share an excel spreadsheet as a PDF through email. When I enter the share in Excel one of the popups is send as a PDF. When I click on the PDF it comes up with "Document not saved. Document may be open, not saved, or an error may have occurred when saving." I used this all the time to send PDF's, and stopped working about a month ago. Any suggestions?

Excel
office 365
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jun 07, 2024

    7575Ben 

    There are a few potential reasons for the error you're experiencing when trying to share an Excel spreadsheet as a PDF. Here are some troubleshooting steps you can follow to resolve this issue:

    1. Check for Updates in Excel 365

    • Open Excel.
    • Go to File > Account.
    • Under Product Information, click Update Options > Update Now.

    2. Save the Excel File Locally

    Ensure your file is saved locally, not on OneDrive or another cloud service, to rule out connectivity issues.

    3. Repair Office 365

    • Right-click the Start button and select Apps and Features.
    • Scroll down to find Microsoft Office 365.
    • Click on it, then click Modify.
    • Select Quick Repair or Online Repair and follow the prompts.

    4. Disable Add-Ins in Excel 365

    • Open Excel.
    • Go to File > Options > Add-Ins.
    • At the bottom, next to Manage, select COM Add-ins and click Go.
    • Uncheck all add-ins and click OK.
    • Restart Excel and try again.

    5. Save As PDF Manually in Excel 365

    • Open the Excel file.
    • Go to File > Save As.
    • Select a location, and in the Save as type dropdown, choose PDF.
    • Save the file and manually attach it to your email.

    6. Run Excel 365 in Safe Mode

    • Press Windows + R, type excel /safe, and press Enter.
    • Try to share the document as a PDF in Safe Mode.

    7. Check OneDrive Sync Status

    If you’re using OneDrive to save your files:

    • Ensure OneDrive is properly synced and there are no errors.
    • Right-click the OneDrive icon in the system tray and select View online to check the status.
    • Try saving the file locally instead of on OneDrive.

    8. Check for Permissions and File Corruption

    • Right-click on the file, go to Properties, and ensure it’s not marked as read-only.
    • Open the file in Excel and save it under a different name or location.

    9. Check Disk Space

    Ensure your computer has sufficient disk space for saving files.

    10. Reset Excel Settings

    Resetting Excel settings can sometimes resolve issues.

    • Close Excel.
    • Open the Run dialog box (Windows + R).
    • Type regedit and press Enter.
    • Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel (for Office 365).
    • Right-click the Excel folder and select Export to back it up.
    • Delete the Excel folder.
    • Restart Excel (a new Excel registry key will be created).

    The text was created with the help of AI.

    If these steps do not resolve the issue, provide detailed information.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

     

    Was the answer useful? Mark as best response and like it!

    This will help all forum participants.

Resources