“Document not saved. The document may be open, or an error ,,,

[Kokomojo]

I'm getting this message when I'm trying to save an Excel workbook as a PDF:

“Document not saved. The document may be open, or an error may have been
encountered when saving.â€

I cannot find any help about this. Any thoughts?

Thank you.

 

[Joel]

what tool are you using to savve a worksheet as PDF? Usually when I use
Adobe writer I can print the file and set the printer to Adobe which
automatically creates a PDF file. The PDF file has to be closed for this to
work. What steps are you performing?

 

[Joel]

what tool are you using to savve a worksheet as PDF? Usually when I use
Adobe writer I can print the file and set the printer to Adobe which
automatically creates a PDF file. The PDF file has to be closed for this to
work. What steps are you performing?

 

[Kokomojo]

Hi Joel,

Thanks for helping out. I'm in Excel 2007. I click on the Office Pearl,
then Save As, then PDF. I downloaded the Office 2007 PDF add-in that gives
me these options. I'm working with Windows XP and I have the Acrobat Reader
9.

Thanks,
Joe

 

[Joel]

Do you have a license for this product?

the microsoft webpage for downloading this product says the following:

This download allows you to export and save to the PDF and XPS formats in
eight 2007 Microsoft Office programs. It also allows you to send as e-mail
attachment in the PDF and XPS formats in a subset of these programs. Specific
features vary by program.

This Microsoft Save as PDF or XPS Add-in for 2007 Microsoft Office programs
supplements and is subject to the license terms for the 2007 Microsoft Office
system software. You may not use this supplement if you do not have a license
for the software.

 

[Kokomojo]

Yes, it's a legal copy. I bought the upgrade from Office 2003 and registered
it.

 

[menzel19]

I have the exact same issue - fully licensed copy of Office 2007 with the
"Save as PDF" add-in from Microsoft. Every time I go to save as PDF I get
that error now. Rebooting does not help.

 

[Eric Menzel]

We are having this same problem. The safe switch did not help with
the problem. Can we get a response from Microsoft or an update to
this add-in? It is the one function that was LONG overdue, and
requested, but only half functional now.

 

[hagchr]

Error saving Excel file as PDF

I had the same problem. However, when I turn off the anti-virus program (in my case Kaspersky) it works just fine.

 

[98765]

Hagchr, thank you for your post! I too had the same problem with Office 2007, and when I turned off Kaspersky anti-virus program, Word and Excel work just fine to print pdf.

 

[jsavoor]

Hi

From what I have tested and observed this is not necessarily the case for all. I am using a Excel macro I have written to generate a PDF file for a quotation. I am setting an area and then using the code below to write the file. The macro always ends execution at the same line with the same error message everyone is experiencing. I have tried to disable Kaspersky 2010 which I use but I still get this error intermittently.

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
pdfname _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False

I am intrigued as to why this is happening and I am sure this is a Microsoft issue.

JAy