Excel ScreenTips for Hyperlinks seem to get truncated to 255 characters

Hello - We have an Excel VBA application that makes heavy use of hyperlinks. Part of the logic of the application's implementation is to store information in the ScreenTip for the hyperlink that essentially contains the SQL WHERE clause for the query to use when calling the database to get the data associated with the link.

What we are seeing is that the application works fine but if there are sheets open that contain certain links when the user closes the workbook, they receive error when reopening it. What have been able to determine is that some of the ScreenTips are longer than 255 characters and that after reloading, they have been truncated to 255. Are you aware of this behavior and there is some setting we can use to get around this limitation ?

-Ken

December 16th, 2014 3:29pm

Hi,

According to your description, I have a couple of questions.

  • Which Excel version are you using?
  • Which error message did you get when reopen?

Then, my understanding is that the  Excel VBA application will add the hyperlink URL information to the screen tips when importing data. Like this:

 If I understand correctly, the screen tip has the character limitation 255. We could set more then 255 characters, but it'll only display 255 characters when mouse hover. It's by design.

If I misunderstand, please feel free let me know. I'll appreciate if you upload up some screenshots here.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Free Windows Admin Tool Kit Click here and download it now
December 17th, 2014 3:26am

Hello - We are using Excel 2010. Below are screen shots that should illustrate the issue along with some narrative for each.

#1 - Initial opening of the workbook. As you can see the Screen tip is more than 255 characters and is a well formed SQL WHERE clause.

#2 - After closing and then re-launching the workbook we get that initial error.

#3 - Clicking OK on #2, produces the message in this screen shot.

#4 - Mouse over on the same link shows screen tip that has been truncated to 255 characters.

I should make sure you know that we are loading the screen tips programmatically.

I could not paste all screen shots into one posting so will do multiple posts to get them all in.

December 17th, 2014 11:30am

Here are the other two screen shots.


  • Edited by Ken Paynter Wednesday, December 17, 2014 11:32 AM Missed screen shot
Free Windows Admin Tool Kit Click here and download it now
December 17th, 2014 11:31am

Hi Ken,

Im so sorry that I could not see useful information of the images clarity, even I have zoomed them. Would you like to send them to me directly (Email address:   ibsofc@microsoft.com) or re-upload.

Thanks for your understanding.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

December 18th, 2014 1:27am

Is there another e-mail address ? Every time I send a message it gets bounced back by your e-mail service. Even a test one with nothing in it.

Have you tried saving the images locally and opening them up from there ?

Free Windows Admin Tool Kit Click here and download it now
December 18th, 2014 2:39pm

Hi Sir,

I'm so sorry for the inconvenience, please resend them with the email address: ibsexc@microsoft.com. ( I have tested it and worked well).

==

Update:

We has fixed issue with the Email address(ibsofc@microsoft.com), I'll appreciate for you resending me.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"


December 19th, 2014 1:33am

Hello - I resent the images to the new e-mail address and have not heard anything back. Do I need to resend them ? Just let me know.

Regards,

-Ken

Free Windows Admin Tool Kit Click here and download it now
March 3rd, 2015 6:45pm

Hello - Any information yet on what our options are besides redesigning the system to use links in a different way ?

March 20th, 2015 2:54pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics