Excel Comment

Question

I was forced to use Libre office for one time, and after I saved file, when I opened it again with excel there where some changes in color, borders and other stuff. But the thing I don't know hot to change back is comments. ALL comments became transparent.... when I edit, i can see comment, bet after editing,transparent again. And all comments have  rotation option , that was not there before. And in format comment transparency is 0%. New comments are OK, without that problem...... HOW CAN i CHANGE BACK.  I have a lot of comments

Answer 1

SO , as I wrote, problem is just with one file (file that I was forced to use with libre, and then saved). There is no such problem with other excel files. And in this particular file when I make new comment, it dos not have the same problem.

And problem is not that excel dos not show comments, it does, but they are transparent, (I checked, in comment formatting, transparency is 0%) whe I do comment editing, every thing is ok, It is not transparent anymore. but after editing transparent again.( and in these "broken comments" is one more new thing, rotation option. In new comments rotation is 0 and i can't change it)

I understand it is strange problem, but it is very important excel file for work , and it has a lot of comments.....

Thanks for trying to help

Answer 2

Thank you for getting back us. Just to confirm, which version of Office Excel are you using? Is it Office 2016, 2013, 2010 etc.?

Since the troubleshooting steps did not work, let us try to repair your Office app. Detailed steps are provided on this link.

Let us know if this will make any difference.

Thank you.

Answer 3

Hello,

Based on your description, it seems like you are facing issues viewing comments in Excel files. We would like to confirm if you are encountering this issue with a specific file or with all the files. Please try creating a new file and check if you are able to view the comments. If this works, then you may copy the contents from the problem files to a new file and verify the results. We also suggest that you check the Excel settings below:

1. Click Review > Show All Comments, all of the comments should be displayed.
2. In Excel, click on File > Options, click Advanced in the left panel, and then go to the Display section. In the group For cells with comments, show, check the Comments and indicators.

Keep us posted for us to assist you further.

Thank you.