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משלו...
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.