2020-09-11 18:08:44 • Filed to: PDFelement for Mac How-Tos • Proven solutions
People always ask 'how do I save an Excel spreadsheet as a PDF on Mac', the answer is easy. With PDFelement you can convert excel to PDF on Mac with a drag and drop action. Microsoft Excel is a standard spreadsheet application used for performing calculations and creating dynamic tables and graphs. It is widely used by within the business world on a daily basis.
Convert Excel to PDF on Mac
Run the Compatibility Checker for Excel 2007 and later. To verify that a workbook is compatible with Excel 2013, 2010, or 2007, run the Compatibility Checker manually the first time you save your workbook. Then set the Compatibility Checker to run automatically every time you save that workbook. Follow these steps: Click File Info Check for. The basic example code below is something that is close to what you can do in Excel for Windows but if you have good suggestions please let me know. Below is a custom function that you can use to let the user save the ActiveWorkbook in the formats you want and get the correct fileformat of.
Step 1. Open and Import Files
When PDFelement launches, you can simply drag and drop your files into the program window.
Step 2. Create Excel to PDF
Once your excel file has been opened in it, then the PDF file has been created successfully. Click the 'File'>'Save as' button on the top menu to save the created PDF on your Mac directly.
Step 3. Edit PDF as you need
PDFelement can also help you view, edit, and print PDFs so that they look polished and professional. If you need to add tables or data from other Excel files, PDFelement allows you to do that through a simple process. It is compatible with macOS 10.12, 10.13, 10.14 as well as the latest macOS Catalina 10.15. Here is how to edit PDF text on Mac for your reference.
PDF files are usually easier to manage, share, and present within a professional setting. Many Microsoft Office document types present better in PDF format and will be less likely to get manipulated by end users. This is one of the reasons why many official publications are often presented in PDF. Like other files, Excel files also look more professional when presented in PDF format. That's why it's often necessary to save Excel as a PDF on Mac.
How to Save Excel as PDF on Mac
Step 1. Open an Excel File
Open your file in Excel. If you only want a part of the spreadsheet to be saved as a PDF, then select only the area you want to convert. Otherwise, the whole sheet will be saved as a PDF file.
Step 2. Export Excel to PDF
Then click the 'File' > 'Save As..' button on the top menu. In the new pop-up window, choose PDF in the 'Save As' option to save directly.
Convert Excel to PDF with PDF Creator for Mac
PDF Creator for Mac allows you to convert Microsoft Office documents, including Excel, Word, PPT, and more to PDF. Even beginners can use it since it has a simple and intuitive interface. Additionally, PDF Creator for Mac allows you to convert all documents created via Microsoft Office to PDF on the same platform without the need for downloading additional tools.
Step 1. Open and Import Files
When PDF Creator for Mac launches, you will see a simple interface allowing you to upload your excel files for conversion. You can simply drag and drop your files into the program window to upload them. Otherwise, you can import your files by clicking the 'Add Files' button at the top of the 'Add Folder' button if you have more than one file to upload.
Step 2. Create Excel to PDF
Click 'Create' at the bottom and select the destination folder for the files you are converting. Be sure to select a folder that you can easily locate, otherwise, you might lose your newly-converted PDF file.
Step 3. Preview Files
When you click 'Save' in the previous window, PDF Creator for Mac proceeds to convert your Excel file to PDF. You can click 'Preview' on the next window to take a sneak peek of the file that has been converted. You can also click 'Show in Finder' to view the PDF file.
Free Download or Buy PDFelement right now!
Free Download or Buy PDFelement right now!
Buy PDFelement right now!
Buy PDFelement right now!
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Causes
Third-party add-ins
If the Excel file is not saved when you run Excel in Windows safe mode, the issue may be caused by a third-party add-in or by a file that is in one of the Excel startup locations. By default, these files are loaded when you start Excel.
Sometimes, third-party software vendors install custom add-ins to work with Excel. Some of these add-ins work with existing Excel features by design, and some are intended to enable a seamless transition when you are using a third-party product. Typically, these third-party add-ins do not interfere with normal Excel functionality. However, there are some exceptions. For example, Excel save conflicts have occurred because of an add-in.
To test for and eliminate the possibility that a third-party Excel add-in or file is causing an Excel save issue, start Excel in safe mode. To do this, follow these steps:
Exit Excel.
Select Start, and then point to Programs.
Press Ctrl when you start Excel, and hold it until you receive a message that resembles the following:
Excel has detected that you are holding down the Ctrl key. Do you want to start Excel in safe mode?
Select Yes.
Try to save a new Excel file, and then resave the same Excel file again.
If the file saves correctly, a custom add-in or a file that is located in an Excel startup location is most likely the cause. You must locate and remove the add-in or the file to eliminate the problem. After you determine the add-in or the file that caused the problem, contact the vendor that designed it. The vendor may have additional information about this issue and an update that does not cause the issue to occur.
For more information about Microsoft Excel safe mode, press F1 in Excel to open the Help menu, type safe mode in the Search box, and then select Search to view the topic.
For more information about how to determine the folders that Excel uses during startup and additional options to disable this functionality, see the following articles:
Restricted permissions
When you save an Excel file, you must have the following permissions to the folder in which you are saving the file:
- Read permission
- Write permission
- Modify permission
- Delete permission
Note
If you do not have these permissions, the Excel save process cannot be completed.
Insufficient drive space
When you save to any medium, such as a hard drive, an external storage drive, or a network drive, you must make sure that the drive has sufficient free space to enable the file to save. If the destination drive does not have sufficient space, Excel cannot complete the save operation, and you receive the following error message:
Disk is Full.
For more information about this error message, see the following articles:
Antivirus software conflict
When antivirus software is installed or is running, you may receive an error message when you try to save an existing workbook. You do not receive an error message if you try to save a new file. You may receive an error message because some antivirus programs quickly scan any new files that appear on a computer. This scan can sometimes disrupt the Excel save process. This interruption may stop Excel from saving the file correctly.
To check if your antivirus software conflicts with Excel, temporarily deactivate the antivirus software and then try to save the Excel file.
File sharing conflict
If you and a second user work concurrently on a shared workbook, you may receive an error message if you and the second user try to save the file at the same time. You receive an error message because Excel cannot save the file if another instance of Excel is saving the same file.
For more information about this error message, see Unlock a file that has been locked for editing.
File name length
If you try to save or open an Excel file, and the path of that file (including the file name) is more than 218 characters, you may receive the following error message:
Filename is not valid.
For more information, see Error message when you open or save a file in Microsoft Excel: 'Filename is not valid'.
Process to save a file
Excel follows these steps when it saves a file:
- Excel creates a randomly named temporary file (for example, Cedd4100 without a file name extension) in the destination folder that you specified in the Save As dialog box. The whole workbook is written to the temporary file.
- If changes are being saved to an existing file, Excel deletes the original file.
- Excel renames the temporary file. Excel gives the temporary file the file name that you specified (such as Book1.xls) in the Save As dialog box.
For more information, see Description of the way that Excel saves files.
Note
Other processes that occur on your computer may disrupt the Excel save process. These issues may occur if the Excel temporary file is accessed before the Excel save process is completed. For example, the local antivirus software locks the temporary file for scanning before the file can be renamed. Therefore, you must keep track of any new software installations or updates that are performed before you have problems when you try to save workbooks. This information will be helpful if this article does not fix your issue and you have to contact Microsoft Support.
Quick resolution
Try the following options to help recover your Word document. Select the image at the left or the option heading to see more detailed instructions about that option.
Save the workbook by using a new file name
|
Move the original worksheets to a new workbook
|
Save the file as a different Excel file type
|
Try to save the workbook to another location Try saving your notebook to another location, such as a local hard drive, a network drive, or removable drive. |
Try to save a new workbook to the original location
|
Try to save the workbook in safe mode Restart Windows in safe mode, and then try to save the workbook to your local hard disk. |
Additional resources
If you experience specific issues when you use Excel, go to the following website to search for more information about your program version:
Detailed view of the options
The following section provides more detailed descriptions of these options.
You may have problems when you try to save a Microsoft Excel workbook if one or more of the following conditions are true:
- You save an Excel workbook to a network drive on which you have restricted permissions.
- You save an Excel workbook to a location that does not have sufficient drive space.
- The connection to the Excel workbook is lost.
- There is a conflict with an antivirus software program.
- You save an Excel workbook that is shared.
- The 218-character path limitation is exceeded when you save an Excel workbook.
Workarounds to save Excel workbooks
To work around this problem and try to save your work before you troubleshoot, use the following methods. Depending on the cause of the problem, you may be unable to recover the current file as-is. However, the following methods are typically successful. These methods are listed in order of format retention when you are trying to keep the original file formatting.
Note
The following methods may not save all the latest changes, formatting, and feature sets of the workbook that are specific to the version of Excel that you are using. The following methods are intended to let you obtain a usable, saved version of the file. These methods require you to save the file to your local hard disk by using a unique file name.
Option 1: Save the workbook by using a new file name
- On the File menu, select Save As.
- Save the Excel workbook by using a unique file name.
Option 2: Move the original worksheets to a new workbook
Add a filler worksheet to your workbook. To do this, press Shift + F11.
Note
This sheet is required because there has to be at least one remaining sheet in a workbook after you move all relevant data sheets.
Group all the worksheets (except the filler). To do this, select the first sheet, hold the Shift Microsoft for mac 2011. key, and then select the last sheet.
Right-select the grouped sheets, and then select Move or copy.
In the To Book list, select (New Book).
Select OK.
Note
These steps should move the active (grouped) worksheets to a new workbook.
If your workbook contains VBA macros, copy the modules from the old workbook to the new workbook.
Option 3: Save the file as a different Excel file type
- On the File menu, select Save As.
- In the Save as Type list, select a file format other than the current file format. If you are using Microsoft Excel 2007 or a later version, save the file as .xlsx or .xlsm instead of as .xls.
Option 4: Try to save the workbook to another location
Try saving your notebook to another location, such as a local hard drive, a network drive, or removable drive. If you are successful, the following are possible causes of the problem: - [Antivirus software conflict](#antivirus-software-conflict) - [Restricted permissions](#restricted-permissions) - [File name length](#file-name-length) - [File sharing conflict](#file-sharing-conflict)Option 5: Try to save a new workbook to the original location
To save a new Excel file to the original location, follow these steps:Create an Excel workbook.
On the File menu, select Save As.
In the Save As dialog box, follow these steps:
- In the Save in box, select the location in which the original workbook is saved.
- In the File name box, type a name for the new file.
- Select Save.
Excel 2016 For Mac Save As Not Working
If you can save a new workbook to the original location, the following are possible causes of the problem:
If you cannot save a new workbook to the original location, the following is a possible cause of the problem:
If you have sufficient drive space, try Step 3.
Option 6: Try to save the workbook in safe mode
Restart Windows in safe mode, and then try to save the workbook to your local hard disk.
Notes
- If you use a network location to save your workbook, try to restart Windows in safe mode with network support, and then try to save.
- Windows safe mode cannot be used to troubleshoot issues in Microsoft Excel 2010 or later versions.
For more information about how to start Windows in safe mode, see Advanced startup options (including safe mode).
If the workbook saves after you restart Windows in safe mode, try to save the file again. To do this, select Save on the File menu.
If the workbook does not save (or save again) after you restart Windows in safe mode, the following are possible causes:
More information
Download Excel On Mac
PDF Creator for Mac allows you to convert Microsoft Office documents, including Excel, Word, PPT, and more to PDF. Even beginners can use it since it has a simple and intuitive interface. Additionally, PDF Creator for Mac allows you to convert all documents created via Microsoft Office to PDF on the same platform without the need for downloading additional tools.
Step 1. Open and Import Files
When PDF Creator for Mac launches, you will see a simple interface allowing you to upload your excel files for conversion. You can simply drag and drop your files into the program window to upload them. Otherwise, you can import your files by clicking the 'Add Files' button at the top of the 'Add Folder' button if you have more than one file to upload.
Step 2. Create Excel to PDF
Click 'Create' at the bottom and select the destination folder for the files you are converting. Be sure to select a folder that you can easily locate, otherwise, you might lose your newly-converted PDF file.
Step 3. Preview Files
When you click 'Save' in the previous window, PDF Creator for Mac proceeds to convert your Excel file to PDF. You can click 'Preview' on the next window to take a sneak peek of the file that has been converted. You can also click 'Show in Finder' to view the PDF file.
Free Download or Buy PDFelement right now!
Free Download or Buy PDFelement right now!
Buy PDFelement right now!
Buy PDFelement right now!
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Causes
Third-party add-ins
If the Excel file is not saved when you run Excel in Windows safe mode, the issue may be caused by a third-party add-in or by a file that is in one of the Excel startup locations. By default, these files are loaded when you start Excel.
Sometimes, third-party software vendors install custom add-ins to work with Excel. Some of these add-ins work with existing Excel features by design, and some are intended to enable a seamless transition when you are using a third-party product. Typically, these third-party add-ins do not interfere with normal Excel functionality. However, there are some exceptions. For example, Excel save conflicts have occurred because of an add-in.
To test for and eliminate the possibility that a third-party Excel add-in or file is causing an Excel save issue, start Excel in safe mode. To do this, follow these steps:
Exit Excel.
Select Start, and then point to Programs.
Press Ctrl when you start Excel, and hold it until you receive a message that resembles the following:
Excel has detected that you are holding down the Ctrl key. Do you want to start Excel in safe mode?
Select Yes.
Try to save a new Excel file, and then resave the same Excel file again.
If the file saves correctly, a custom add-in or a file that is located in an Excel startup location is most likely the cause. You must locate and remove the add-in or the file to eliminate the problem. After you determine the add-in or the file that caused the problem, contact the vendor that designed it. The vendor may have additional information about this issue and an update that does not cause the issue to occur.
For more information about Microsoft Excel safe mode, press F1 in Excel to open the Help menu, type safe mode in the Search box, and then select Search to view the topic.
For more information about how to determine the folders that Excel uses during startup and additional options to disable this functionality, see the following articles:
Restricted permissions
When you save an Excel file, you must have the following permissions to the folder in which you are saving the file:
- Read permission
- Write permission
- Modify permission
- Delete permission
Note
If you do not have these permissions, the Excel save process cannot be completed.
Insufficient drive space
When you save to any medium, such as a hard drive, an external storage drive, or a network drive, you must make sure that the drive has sufficient free space to enable the file to save. If the destination drive does not have sufficient space, Excel cannot complete the save operation, and you receive the following error message:
Disk is Full.
For more information about this error message, see the following articles:
Antivirus software conflict
When antivirus software is installed or is running, you may receive an error message when you try to save an existing workbook. You do not receive an error message if you try to save a new file. You may receive an error message because some antivirus programs quickly scan any new files that appear on a computer. This scan can sometimes disrupt the Excel save process. This interruption may stop Excel from saving the file correctly.
To check if your antivirus software conflicts with Excel, temporarily deactivate the antivirus software and then try to save the Excel file.
File sharing conflict
If you and a second user work concurrently on a shared workbook, you may receive an error message if you and the second user try to save the file at the same time. You receive an error message because Excel cannot save the file if another instance of Excel is saving the same file.
For more information about this error message, see Unlock a file that has been locked for editing.
File name length
If you try to save or open an Excel file, and the path of that file (including the file name) is more than 218 characters, you may receive the following error message:
Filename is not valid.
For more information, see Error message when you open or save a file in Microsoft Excel: 'Filename is not valid'.
Process to save a file
Excel follows these steps when it saves a file:
- Excel creates a randomly named temporary file (for example, Cedd4100 without a file name extension) in the destination folder that you specified in the Save As dialog box. The whole workbook is written to the temporary file.
- If changes are being saved to an existing file, Excel deletes the original file.
- Excel renames the temporary file. Excel gives the temporary file the file name that you specified (such as Book1.xls) in the Save As dialog box.
For more information, see Description of the way that Excel saves files.
Note
Other processes that occur on your computer may disrupt the Excel save process. These issues may occur if the Excel temporary file is accessed before the Excel save process is completed. For example, the local antivirus software locks the temporary file for scanning before the file can be renamed. Therefore, you must keep track of any new software installations or updates that are performed before you have problems when you try to save workbooks. This information will be helpful if this article does not fix your issue and you have to contact Microsoft Support.
Quick resolution
Try the following options to help recover your Word document. Select the image at the left or the option heading to see more detailed instructions about that option.
Save the workbook by using a new file name
|
Move the original worksheets to a new workbook
|
Save the file as a different Excel file type
|
Try to save the workbook to another location Try saving your notebook to another location, such as a local hard drive, a network drive, or removable drive. |
Try to save a new workbook to the original location
|
Try to save the workbook in safe mode Restart Windows in safe mode, and then try to save the workbook to your local hard disk. |
Additional resources
If you experience specific issues when you use Excel, go to the following website to search for more information about your program version:
Detailed view of the options
The following section provides more detailed descriptions of these options.
You may have problems when you try to save a Microsoft Excel workbook if one or more of the following conditions are true:
- You save an Excel workbook to a network drive on which you have restricted permissions.
- You save an Excel workbook to a location that does not have sufficient drive space.
- The connection to the Excel workbook is lost.
- There is a conflict with an antivirus software program.
- You save an Excel workbook that is shared.
- The 218-character path limitation is exceeded when you save an Excel workbook.
Workarounds to save Excel workbooks
To work around this problem and try to save your work before you troubleshoot, use the following methods. Depending on the cause of the problem, you may be unable to recover the current file as-is. However, the following methods are typically successful. These methods are listed in order of format retention when you are trying to keep the original file formatting.
Note
The following methods may not save all the latest changes, formatting, and feature sets of the workbook that are specific to the version of Excel that you are using. The following methods are intended to let you obtain a usable, saved version of the file. These methods require you to save the file to your local hard disk by using a unique file name.
Option 1: Save the workbook by using a new file name
- On the File menu, select Save As.
- Save the Excel workbook by using a unique file name.
Option 2: Move the original worksheets to a new workbook
Add a filler worksheet to your workbook. To do this, press Shift + F11.
Note
This sheet is required because there has to be at least one remaining sheet in a workbook after you move all relevant data sheets.
Group all the worksheets (except the filler). To do this, select the first sheet, hold the Shift Microsoft for mac 2011. key, and then select the last sheet.
Right-select the grouped sheets, and then select Move or copy.
In the To Book list, select (New Book).
Select OK.
Note
These steps should move the active (grouped) worksheets to a new workbook.
If your workbook contains VBA macros, copy the modules from the old workbook to the new workbook.
Option 3: Save the file as a different Excel file type
- On the File menu, select Save As.
- In the Save as Type list, select a file format other than the current file format. If you are using Microsoft Excel 2007 or a later version, save the file as .xlsx or .xlsm instead of as .xls.
Option 4: Try to save the workbook to another location
Try saving your notebook to another location, such as a local hard drive, a network drive, or removable drive. If you are successful, the following are possible causes of the problem: - [Antivirus software conflict](#antivirus-software-conflict) - [Restricted permissions](#restricted-permissions) - [File name length](#file-name-length) - [File sharing conflict](#file-sharing-conflict)Option 5: Try to save a new workbook to the original location
To save a new Excel file to the original location, follow these steps:Create an Excel workbook.
On the File menu, select Save As.
In the Save As dialog box, follow these steps:
- In the Save in box, select the location in which the original workbook is saved.
- In the File name box, type a name for the new file.
- Select Save.
Excel 2016 For Mac Save As Not Working
If you can save a new workbook to the original location, the following are possible causes of the problem:
If you cannot save a new workbook to the original location, the following is a possible cause of the problem:
If you have sufficient drive space, try Step 3.
Option 6: Try to save the workbook in safe mode
Restart Windows in safe mode, and then try to save the workbook to your local hard disk.
Notes
- If you use a network location to save your workbook, try to restart Windows in safe mode with network support, and then try to save.
- Windows safe mode cannot be used to troubleshoot issues in Microsoft Excel 2010 or later versions.
For more information about how to start Windows in safe mode, see Advanced startup options (including safe mode).
If the workbook saves after you restart Windows in safe mode, try to save the file again. To do this, select Save on the File menu.
If the workbook does not save (or save again) after you restart Windows in safe mode, the following are possible causes:
More information
Download Excel On Mac
Excel On Mac Free
Still need help? Go to Microsoft Community.