asked on
Hyperlink formula returning #Value! error
hyperlink formula not working.xlsxI have a file with a hyperlink formula. This formula works fine on another sheet (just sending you a sample) but it keeps returning a Value error. I have tried removing spaces from the email addresses, formatting it as text and I still keep getting the Value message... help appreciated! Yes, uploading the file would have definitely helped... :-=(
Microsoft ExcelMicrosoft Office
Last Comment
Rainer Jeschor
It is EXCEL that has the limit of 255 characters in a Hyperlink.
if you have less than 255 characters -( remove some Email Text ) it is working fine
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
could you please attach a sample?
Thanks