Hover text/No hover text !!!

Question

Hello, following a previous question on Excel Online on Sharepoint, I noticed some cells with a lot of text has their content displayed as a hover text when the mouse pointer was on a cell (not the selected cell but the one with the pointer on it). So I managed to add a special formatting to my Excel file (adding one ' character plus 1 bold space at the beginning of each cells) in order to see that hover text. Problem, the host doesn't have Information Rights Management attached with the Sharepoint Server 2016 Standalone service, so I decided to try it at Microsoft directly... I managed to have IRM working at MS but this time, no more hover text on the formatted Excel file... So I am back to the starting point, having half of the wanted features on the host (hover text showing the whole cell content), and the othe half at MS (IRM). 

This litteraly drives me crazy not to have the same behavior...

Is there anyone at MS able to answer me: is there any setting in Office 365 to have this hover text with Excel Online ???

I tried a lot of permissions/IRM combinations and cannto have this hover test to work, and I start being desperate to have this working...

Best Regards

Answer 1

Hello Jim, I figured out that the "Hyperlink" method had a screentip feature documented, so I did a VBA script to transform all my cells into hyperlinks and it now works fine both with Excel and Excel Online. I also had to disable the "styles" for "hyperlink" & "followed hyperlink" objects to keep my original cell formats, but at least, now, the full cell content can be viewed.

Best Regards,

Bertrand #happy

Answer 2

OK Jim, thanks for the feedback.

Answer 3

Hi Bertrand,

Thanks for your sharing, glad to hear you can now preview the cell contents. This will surely benefit other community members who are under similar situation.

Best Regards,

Jim