@gmt in hyper link

%3CLINGO-SUB%20id%3D%22lingo-sub-1944696%22%20slang%3D%22en-US%22%3E%40gmt%20in%20hyper%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1944696%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3BI'm%20an%20IT%20manager%26nbsp%3B%20and%20one%20of%20my%20clients%20has%20an%20excel%20issue%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20of%20his%20hyper%20links%20target%20got%20all%20massed%20up%20and%20has%26nbsp%3B%40gmt%20in%20them.%3CBR%20%2F%3Elike%20that%22%3A%26nbsp%3B%40GMT-2020.10.12-04.00.05%5C%D7%94%D7%96%D7%9E%D7%A0%D7%95%D7%AA%2C%2520%D7%AA%D7%A2%D7%95%D7%93%D7%95%D7%AA%2520%D7%9E%D7%A9%D7%9C%D7%95%D7%97%25202020%5C10163.pdf%3C%2FP%3E%3CP%3E(%20sorry%20for%20the%20hebrew)%3C%2FP%3E%3CP%3Enow%20when%20he%20tries%20to%20open%20one%20of%20them%20by%20pressing%20the%20link'%20he%20gets%20an%20error%20saying%3A%20unable%20to%20open%20attached%20file.%3CBR%20%2F%3EI've%20looked%20all%20over%20google%20but%20didn't%20find%20a%20solution%20for%20that.%3CBR%20%2F%3EAny%20ideas%3F%3C%2FP%3E%3CP%3ETnx%20a%20lot%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1944696%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1944930%22%20slang%3D%22de-DE%22%3ESubject%3A%20%40gmt%20in%20hyper%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1944930%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F887161%22%20target%3D%22_blank%22%3E%40asicohen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20translation%20makes%20no%20sense%20to%20me%2C%20the%20software%20is%20probably%20not%20yet%20mature%20enough%20to%20understand%20idioms.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWhatever...%20w%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3Eith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20add%20an%20MS%20Excel%20file%20(without%20sensitive%20data)%20to%20your%20project.%3C%2FP%3E%3CP%3EExplain%20your%20plans%20in%20relation%20to%20this%20file.%20So%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3C%2FP%3E%3CP%3EA%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3EPlease%20no%20Picture%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Add%20a%20MS%20Excel%20file%20(without%20sensitive%20data)%20to%20your%20project.%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20also%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1944997%22%20slang%3D%22de-DE%22%3ESubject%3A%20%40gmt%20in%20hyper%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1944997%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F887161%22%20target%3D%22_blank%22%3E%40asicohen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAnyway%2C%20until%20you%20have%20all%20the%20data%20ready%2C%20I'll%20send%20you%20this%20approach%20as%20well%20as%20possible.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EMaybe%20it%20fits%20with%20that.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EA%20possibility%3A%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ETools%26gt%3B%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EOptions%26gt%3B%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EGeneral%26gt%3B%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWeb%20Options%26gt%3B%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EFiles%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EDeactivate%20the%20option%20%22Update%20links%20when%20saving%22.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EOr%20is%20it%20an%20Excel%20file%20with%20hyperlinks%20located%20on%20a%20mapped%20drive%20that%20different%20users%20should%20access%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1945516%22%20slang%3D%22en-US%22%3ERe%3A%20%40gmt%20in%20hyper%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1945516%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F887161%22%20target%3D%22_blank%22%3E%40asicohen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%20a)%20the%20client%20updated%20on%20Excel%20which%20supports%20dynamic%20arrays%20(he%20may%20don't%20know%20about%20that%20if%20is%20on%20365%20subscription)%20and%20b)%20hyperlinks%20are%20created%20by%20and%2For%20used%20in%20some%20formulas.%20With%20shifting%20on%20dynamic%20arrays%20Excel%20adds%20implicit%20intersection%20character%20%22%40%22%26nbsp%3B%20if%20it%20is%20not%20sure%20you%20are%20working%20with%20array%20or%20single%20value.%3C%2FP%3E%0A%3CP%3EStraightforward%20solution%20is%20to%20manually%20remove%20all%20%22%40%22.%20But%20better%20to%20correct%20formulas.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAgain%2C%20that's%20only%20a%20variant%2C%20small%20sample%20file%20with%20only%20few%20records%20could%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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משלוח%202020\10163.pdf

( sorry for the hebrew)

now when he tries to open one of them by pressing the link' he gets an error saying: unable to open attached file.
I've looked all over google but didn't find a solution for that.
Any ideas?

Tnx a lot 

9 Replies

@asicohen 

The translation makes no sense to me, the software is probably not yet mature enough to understand idioms.

Whatever... with your permission, if I can recommend you, add a MS Excel file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

 

* Add a MS Excel file (without sensitive data) to your project. Knowing the Excel version and operating system would also be an advantage.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

@asicohen 

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)

 

@asicohen 

As variant a) the client updated on Excel which supports dynamic arrays (he may don't know about that if is on 365 subscription) and b) hyperlinks are created by and/or used in some formulas. With shifting on dynamic arrays Excel adds implicit intersection character "@"  if it is not sure you are working with array or single value.

Straightforward solution is to manually remove all "@". But better to correct formulas. 

Again, that's only a variant, small sample file with only few records could help.

@Nikolino 

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.

@Nikolino 

Just to make sure I understand.

add an empty excel file to the problematic one, delete all sensetive data from the rest of the workbook and attach it here?

Excel Version and Server Version?

@Nikolino 

Microsoft Windows Server 2016 Standard x64

office 365 business standard

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)