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 an 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.
The 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 in-built 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 an 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 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.
Original Post From Microsoft Community
Causes For Getting Document not saved Excel 2010 Error Message:
Whenever you get document not saved Excel 2010 error while using Excel file then there must be a reason.
Well, after going through some forum contents, it has been found that the reasons for getting this error could be – changed the PDF/A compliant 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:
Automatic Solution: MS Excel Repair Tool
The above mentioned manual solution will most probably sort out the issues and mentioned errors from Excel file. But for any other corruption or file damage most suitable option would be to make use of MS Excel Repair Tool. This is is highly competent in restoring corrupt Excel files and also retrieves data from worksheet like cell comments, charts, other data and worksheet properties. This is a professionally designed program that can easily repair .xls and .xlsx files.
Steps to Utilize MS Excel Repair Tool:
I tried my best to provide the ample information about the Document not saved Excel 2010 error and fixes. so make use of it to get rid of the error Document not saved Excel 2010, click to save.
However, if you are having any additional fixes or any query then please share it with us. You can go to the comment section or on MS Excel Ask Question page.