'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel for Mac Saving PDFs to the Previous Folder
Question details
When printing from Excel for Mac and choosing 'Save as PDF', the Finder dialog defaults to the last used folder instead of the folder containing the active workbook.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Exporting or saving an active Excel workbook as a PDF document using the Print menu.
- Observed behavior
- Finder opens the previously used directory for saving PDFs rather than the folder where the current workbook is located.
Check the Mac App Store or Microsoft AutoUpdate to ensure your macOS and Excel applications are updated to the latest versions, as Microsoft frequently patches directory routing bugs.
Use Manual Navigation and Submit a Bug Report
Since this is a recognized directory routing issue in Excel for Mac, you must manually select the correct folder while saving. Submitting feedback directly to Microsoft helps expedite an official patch.
This behavior is often considered a bug specific to Excel for Mac's Print-to-PDF feature. Unlike Microsoft Word, which correctly defaults to the active document's directory, Excel caches the last used save path for PDFs.
Open your workbook in Excel for Mac, go to 'File' > 'Print', click the PDF dropdown menu at the bottom, and select 'Save as PDF'.
In the Finder save dialog that appears, click the folder dropdown or use the sidebar to manually navigate to the directory where your active workbook is stored.
To help Microsoft fix this bug, click 'Help' in the top Mac menu bar while Excel is open, then select 'Give Feedback'.
Choose 'I do not like something', describe the issue (mentioning your macOS version, Excel version, and that PDFs do not save to the workbook's folder), and click submit.
Use the Standard 'Save As' Menu Instead of Print
Bypassing the macOS Print dialog and using Excel's native 'Save As' feature can sometimes force the application to recognize the active workbook's folder.
Seamlessly Export PDFs in the Right Folder with WPS Office
Frustrated by directory bugs in Excel for Mac? WPS Office offers a smooth, bug-free experience for Mac users, allowing you to easily export spreadsheets to PDFs in the correct folders without extra clicks. It is a highly compatible, fast, and free alternative to Microsoft Office.
- 1. Open your spreadsheet in WPS Office: Launch WPS Office for Mac and open your .xlsx or .csv file.
- 2. Click Export to PDF: Navigate to the 'Menu' or the 'Tools' tab and click on the 'Export to PDF' button.
- 3. Save to your current folder: The save dialog will naturally default to the directory of your active document, saving you time and frustration.
Frequently Asked Questions
Why does Excel for Mac open the last used folder instead of the current one?
This is a known software behavior and potential bug specific to Excel for Mac's Print-to-PDF function. Unlike Microsoft Word, Excel caches the last used PDF directory rather than automatically referencing the active workbook's file path.
Can I change a setting to make Excel default to the workbook's folder?
Currently, Excel for Mac does not offer a built-in configuration or preference setting to force the 'Save as PDF' dialog to always open the active workbook's folder. Users must rely on manual selection or use the 'Save As' menu as a workaround.
Does this issue happen when using 'Save As' instead of Print to PDF?
Typically, no. Using the standard 'File > Save As' function and changing the file format to PDF usually prompts Excel to open the correct folder containing the workbook. The bug is largely isolated to the macOS Print dialog's 'Save as PDF' feature.
