How to convert MS Excel cell comments to show in Adobe pdf format?

[reesep60134383]

As late as May of 2017, you could convert an Excel spreadsheat to pdf format, and the cell comments created in Excel would show in the pdf document as a light red shade over the cell.  When the mouse hovered over the light shade area, the comment would show in the pdf document as a popup.  This no longer happens.  This function is very important for reports that my company sends to it's clients, as the popup notes provide additional information, without having to add it every time the document is created.  I have reached out to Microsoft to see if they have an answer, but they agree it is no longer possible to do this and that I need to find out why by contacting the Adobe people.

Does anyone have an answer as to why this function has gone away and if there is any way to get it back?

Discussion moved from Acrobat Reader by moderator to Commenting & Collaboration

[~graffiti]

What exact Adobe product were you using to convert the Excel file to PDF? And what steps were you taking?

[reesep60134383]

Adobe Acrobat Pro DC.

We generally use the addon in Excel to run the Adobe converter to pdf. It

can be done other ways, such as in the print box, but anyway we have tried,

the comments no longer show.

[~graffiti]

You'll probably want to ask this in the forum for Acrobat. This is the forum for the free Reader. More than likely it's a setting on the Acrobat or Excel end of things.

[jane-e]

How do you make the PDF?

What version of Excel?

Do you use the Acrobat toolbar?

Are comments enabable in Acrobat preferences on the Acrobat toolbar?

[reesep60134383]

Hello,

How we make the pdf: We click on the Acrobat tab at the top of the ribbon,

and up pops the Acobat toolbar. One of the choices there is "create pdf".

We click on that and it brings up a menu box asking do we want to save the

entire document or the page. We choose thé entire document. Then it asks us

to save the document and we click "yes". The pdf is then created.

Version of Excel: Office 365 Business, Version 1709 Build 8528-2139;

Click-to-Run.

As noted above, we use the Acrobat toolbar.

Under preferences, the comments enabled box is checked.

Thanks.

[yairr40582425]

Adobe DC support team - We are trying to to the same as described by the OP at my workplace bu this does not succeed - why is this feature still not working?

[Nazif from Pamir Khost]

I will tell you the instruction but you should pray for me.

On the excel sheet that has comments, first you should show the comments as follow.

Click page set up, then click sheet, then open the box next to comments and select as displayed on sheet.

Now you can print it with comments.

Now if you want to convert it to pdf with showing comments, you can do as bellow.

Open the file with comments as above, then go to file menu, then click save& send, then click Create pdf/Xps document, then again click on Create Pdf/Xps document, then give name and click on publish botton.