'%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 Cannot Print Excel Workbooks from Excel Online or Teams
Question details
Users need to resolve an issue where Excel workbooks fail to print when accessed through web-based platforms.
- Product
- Excel Online, Microsoft Teams
- Device & OS
- not provided
- Scenario
- Attempting to print an Excel workbook that is stored in OneDrive or SharePoint directly from Excel Online or Microsoft Teams.
- Observed behavior
- A printing error is displayed and the workbook fails to print, despite other Office web applications printing normally.
Ensure your local printer is turned on, securely connected to your computer, and has adequate paper and ink before proceeding with the desktop printing workaround.
Download a Local Copy and Print via Desktop Application
Bypass the cloud printing error by downloading the workbook to your computer and printing it from a local desktop spreadsheet program.
Microsoft has identified this as an ongoing issue affecting Excel files stored in SharePoint and OneDrive when accessed via Excel Online or Microsoft Teams. The most reliable workaround is to use a desktop client to handle the print job.
In Excel Online or Microsoft Teams, navigate to the 'File' menu in the top-left corner and select 'Save As' or 'Make a copy'.
Choose the option to 'Download a Copy' to save the workbook directly to your local computer's hard drive.
Locate the downloaded file on your computer and open it using the desktop version of Microsoft Excel or another compatible spreadsheet application.
Go to 'File' > 'Print' (or press Ctrl + P) in your desktop application to configure your settings and print the workbook normally.
Easily Print Your Downloaded Excel Workbooks with WPS Spreadsheet
Avoid cloud printing bugs by downloading your workbooks and printing them using WPS Office. It provides full compatibility with Microsoft Excel formats and offers a robust, easy-to-use desktop printing experience.
- 1. Download and Install WPS Office: Download WPS Office for free from the official website and install it on your computer.
- 2. Open the downloaded workbook: Right-click the Excel file you downloaded from Teams or Excel Online, select 'Open with', and choose WPS Spreadsheet.
- 3. Access the print settings: Click on 'Menu' in the top-left corner and select 'Print', or simply use the keyboard shortcut Ctrl + P.
- 4. Adjust layout and print: Review the Print Preview to ensure your layout is correct, adjust scaling or margins if necessary, and click 'Print'.
Frequently Asked Questions
Why does Excel Online show a printing error but Word Online prints fine?
Microsoft has identified an ongoing bug that specifically affects the printing function for Excel workbooks stored in SharePoint or OneDrive when accessed via Excel Online or Teams. Other web applications like Word Online are not impacted by this specific issue.
Can I fix this printing error directly within Microsoft Teams?
Currently, there is no direct fix within Teams or Excel Online. The only reliable solution is the official workaround: downloading a local copy of the file and printing it using a desktop application.
Will downloading the Excel file change my formatting?
No, downloading a copy of the workbook preserves all data, formulas, and formatting. When you open it in a highly compatible desktop application like Microsoft Excel or WPS Office, it will maintain the original print layout.
How do I save a local copy from Excel Online?
While the file is open in Excel Online, click on the 'File' tab in the ribbon, select 'Save As' from the left sidebar, and click 'Download a Copy' to save the .xlsx file to your computer.
