Cant export Excel as PDF

[karl.hansson]

Hi,

Im trying to export my Excel as PDF but it´s not working..
I downloaded the latest Excel VBO but and even tried the extended with no success.

My inputs: (which should be fine because they work with all the other actions..)

Error:

@ewilson  🙂

All help appreciated.

Best regards,
Karl

[ewilson]

Hi @karl.hansson 

I believe that's a NAME_NOT_FOUND error in Excel. This could be caused by any number of issues within the Workbook itself. First thing I'd try is setting the Active Sheet Only flag to True and see if that exports ok.

Cheers,
Eric 

[david.l.morris · Accepted solution]

Have you verified that you can manually export as PDF in Excel for that specific file first?

[karl.hansson]

I should have tried this first.. Didn´´t think it could be an issue but there´s a problem when trying to do it even manually but i get this:

Any suggestion on work around?

When i tried to use the Save As PDF in the other object i get an issue with the Portrait / Landscape input where i tried both True/False without success.

[david.l.morris]

@karl.hansson I haven't seen that specific error before (the one dealing with no printers installed). I would think all it wants is Microsoft Print to PDF set up as a Printer. Do you have that in your list of printers? Maybe if you set it as default in the printers, then it might work? Also, make sure the Print Spooler Windows service is running.

[faheemsd]

Dear @karl.hansson 

I have faced the similar issue with my Remote Desktop Machine. I was able to convert Excel to pdf in my local desktop but when it comes to RDP I'm getting the same error.

I suggest you to check the excel version and update it to the newer of excel this will resolve your issue

[swolonda]

@faheemsd and @karl.hansson contact your security/infrastructure department.

Ask them about policy for "print spooler" service, excel uses it for export (the "export" is actually the same thing as printing to PDF). This Windows component is ussually forbidden at servers and virtual machines as it presents a security risk (and you don't ussually have any printers connected there anyway).