Forum Discussion
@gmt in hyper link
Hi I'm an IT manager and one of my clients has an excel issue Some of his hyper links target got all massed up and has @gmt in them. like that": @GMT-2020.10.12-04.00.05\הזמנות,%20תעודות%20משלו...
Anyway, until you have all the data ready, I'll send you this approach as well as possible.
Maybe it fits with that.
A possibility:
Tools>
Options>
General>
Web Options>
Files Deactivate the option "Update links when saving".
Or is it an Excel file with hyperlinks located on a mapped drive that different users should access?
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Hi
Thank you for your answer.
yes this excel file is used by 2 different users and is located on a server.
will your solution :"
A possibility:
Tools>
Options>
General>
Web Options>
Files Deactivate the option "Update links when saving".
still works.
- Excel Version and Server Version?
- If the problem relates to a specific sheet, then it is very useful to upload this file (without sensitive data, please delete). If it refers to several worksheets, it is useful to describe whether this happens in a special folder or if it happens to all worksheets / workbooks.
However, the more precise information you have, the more precise answer you can expect.
But as I said, a first step would be to let us know what excel version you / the customer is using and the operating system.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates) - To be sure, it is correct (as far as I could understand it from the translation) because all saved Excel workbooks can be seen like this "@ GMT-2020.10.12-04.00.05,% 20-% 20-% 202020-10163. pdf "in the server?
... and you can't open it?
Is this only for files that you have placed on the server or only files that are shared with other users?
As you yourself know, if you cannot see or understand the surroundings of the problem, a lot of questions arise.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)