Hyperlinks to another file are changed to unicode characters

H

Harry

I have a spreadsheet which has hyperlinks to other files. Some of these files
are .msg files .

The file name includes [ and ] characters.
When we create the hyperlink and click on it, the hyperlinked file opens
right up.
However, once we save the file, the [ and ] characters are replaced with
their unicode eqivelant %5b and %5d.

When we try to click on the hyperlinks, Excel gives us an error message.

Can someone suggest a workaround?

thanks,
Harry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top