Excel 2010 Save as PDF - Document not saved

**rustleg** · 04-12-2013, 03:43 PM

I have an Excel 2010 spreadsheet which I need to print to PDF. There is a simple "Save as" PDF option which always fails with just the message "Document not saved". I created a simple test sheet with just a few numbers on to check it isn't due to complexities with the particular workbook. This works on my home PC (Windows 7) but not on the Windows 7 Club PC which is where I need to run it to generate the output which eventually will go to the club's website.

It also fails the same way if I try to create an XPS file (although I don't want an XPS file).

This fails from the normal user interface "Save As". I also tried it from a VBA macro and run it: I get
Run-time error '-2147467261 (80004003)' Document not saved

I've googled endlessly but all the references I tried failed to uncover a solution. I was a bit surprised that this doesn't seem particularly common and most of the reports seem to be a couple of years old or older (no workarounds were useful).

**rustleg** · 04-21-2013, 09:31 AM

Finally worked out that if it wasn't particularly common then it's probably not a bug but a problem with myinstallation. I uninstalled Office then reinstalled - no change. I then did a complete reinstall of Windows (upgrade option) and this did fix it.

So ok now. Hope this post helps someone else with the same problem.

**Georgian77** · 10-09-2019, 02:45 AM

Hello!
I solved the problem in the following way. After opening the file, go to Save As, select the location where the file will be saved, and select type as PDF. Click on options and in the newly opened window, uncheck PDF / A compliant. It worked for me.