Forum Discussion
hyperlink error
Hi i have a sheet i have set up for meter readings that i bill to end users. I have set a hyperlink up to automatically fill out the emails for me but for some reason some of them seem to be comi...
Hi Nikolino
thank you for this it was very helpful.
I have not done coding before so am not comfortable with this unfortunately.
I have just gone through the system and cant see any issues in regards to the formula but what i have noticed is that shortening the length of email address seems to clear the error.
Is there a way i can alter the hyperlink setup to allow for extra data length in regards to the email address?
Many thanks
M
thank you for this it was very helpful.
I have not done coding before so am not comfortable with this unfortunately.
I have just gone through the system and cant see any issues in regards to the formula but what i have noticed is that shortening the length of email address seems to clear the error.
Is there a way i can alter the hyperlink setup to allow for extra data length in regards to the email address?
Many thanks
M
The maximum length of a hyperlink address in Excel is 255 characters. This includes the protocol (e.g., "http://"), domain, path, query parameters, and any additional characters used for encoding. It's important to keep these limitation in mind when working with hyperlinks in Excel to ensure they function correctly and meet your requirements. If you encounter any issues or have specific requirements that go beyond these limitations, alternative approaches or VBA programming may be necessary.
- Hi Nikolino
ok thank you
i have altered the body slightly which has cleared the issue
Many thanks
M