I currently having a constant error, I have an excel that contains passwords of users and on some occasions, the special characters used such as @ or . cause a hyperlink to appear.
I only need to read range the text in the cells but I keep getting the error message as above:
Read range: Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document.
Is there anyway to change the settings that it will ignore hyperlinks and just focus on the text in the document?