Microsoft has introduced a great feature in Excel 2010 – the ability to convert excel workbooks directly to the PDF (Portable Document Formats) or XPS (XML paper Specification) file format. A PDF (Portable Document Format) file allows others to view documents without any requirement of original program like excel that is installed on your computer. Users can directly open a file with a free PDF reader program such as Adobe Acrobat Reader. Also, this file format allows you to let others view spreadsheet data without giving them the opportunity to change it.
PDF file is such a kind of document that enables people to open and print your Excel worksheets even if the users don’t have installed excel file on their systems. Here, you can have a look at how to easily convert an excel file to PDF file with its inbuilt feature.
Steps to Convert Excel File to PDF in Microsoft Excel 2010:
- Open a workbook.
- On the green File tab, click Save As.
- Select PDF from the drop-down list.
- Click Options.
- You can publish a selection, active sheet or entire workbook.
- Click OK and then Click Save.
You May Also Like: How To Repair Excel 2010 Macro Compile Error: Can’t Find Project Or Library
These are the steps you can follow to convert your excel file to PDF file format. Sometimes while performing these steps, you may get error. However, the error you may get is not a big issue and can be solved. Before going to have a look at the repair solution, let us first read a practical scenarios that have been faced by the user.
All of the sudden it won’t let me save as PDF using 2010 Excel. I am running Windows 7 Home Premium 64 bit. 2010 Office Excel. I have been using the same spreadsheet I made on 2007 Excel with 2010 for the last 6 months or so and have had no problem saving as PDF. Two nights I ago I went to save it as PDF and got an error message of “Document not saved. The document may be open, or an error may have encountered when saving“. Then the original spreadsheet stays on the screen, but a shrunk version of the text boxes with the new information I added shows in the upper left corner. It will save as Excel fine, just not as PDF. I tried creating a new spreadsheet in 2010 and am still getting the same error message. When I use a different spreadsheet it will save as PDF. This spreadsheet has text boxes and two simple oval shapes. Thank you in advance.
Causes For Getting Excel 2010 Error Message When Trying To Save As PDF:
Whenever you get any error while using excel file then there must be a reason, a cause, for getting the error, no matter what the error is. However, the same thing is here in this case. Let us have a look what can be the cause or the reason for getting Excel 2010 error message when trying to save as PDF.
Well, after going through some forum contents, it has been found that the reasons for getting this error could be – changed the PDF/A complaint tag to ON for compatibility purpose that is generally found in ‘Save As’, ‘PDF’, ‘OPTIONS’ screen. So, if the tick is removed then save as a PDF will not start working.
Solution to Fix Excel 2010 Error Message When Trying to Save as PDF:
With the help of manual solution, you can fix this issue with an ease. In order to solve this issue, at first, you have to Open Excel in Safe Mode and then there will be a need to verify the status. After this, you are required to hold the CTRL button and then click the Excel icon.
After you perform the above step, you have to check if it works. If yes, then it is quite good and there might be an add-in(s) conflicting. Now you have to perform these steps to know which one is causing the problem: Open Excel > Tools > Add-in > Uncheck the boxes one after another and then simply click “OK”.
However, even after performing the above steps, you find that the issue still resides there then you can proceed to the below Microsoft’s link and check if it helps:
You May Also Like: Fix Excel Error “Invalid XLS File Format” On Windows OS
After going through the above blog, you must have noticed everything about the error and how this error can take place. As well as, the solution to fix this error can also be seen here. However, if you get Excel 2010 error message when trying to save as PDF then you can try the above solution but if you ever come across any other issues related to excel file then for that case also, you can try some manual solution to fix the issue but if you fails to do so then don’t panic. In that case, you can make use of Excel Repair Tool. This tool is quite efficient to solve the problem and also it allows you to fix the issue soon after performing a few easy steps. The steps involved in the solution to fix the error are so easy that even a person with 0% technical knowledge can easily use this tool.