Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document. clientRequestId

(0) Share

Report

Posted on by goliaaat

Hello

I have a problem with reading xlsx files

Even though I deleted all urls

I see the same error

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (1)

v-monli-msft on at

Like (0)

Report

Hi @goliaaat,

I saw the error was from the field of picking tables in excel file. Have you made sure that you have formatted the data as table style in Excel?

https://support.office.com/en-us/article/Format-an-Excel-table-6789619F-C889-495C-99C2-2F971C0E2370

Regards,

Mona

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,
@v-monli-msft

All of the sudden my app stopped working today and now I am getting this error;

Tables didnt load correctly.
Failed to read Excel workbook stream. Failure reason: Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document.
clientRequestId: 56762065-be49-4111-a4e9-b18838b08cd4
serviceRequestId: 56762065-be49-4111-a4e9-b18838b08cd4;56762065-be49-4111-a4e9-b18838b08cd4;56762065-be49-4111-a4e9-b18838b08cd4;56762065-be49-4111-a4e9-b18838b08cd4;56762065-be49-4111-a4e9-b18838b08cd4
Session ID: 178af976-33d6-4cf4-ae2f-9e52be235c75

what can I do to fix this?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (3)

Report

Afternoon,

I was puzzled by this for a bit too, but worked out the issue. Certainly for me anyway.

To resolve this, it seemed to be caused by the formatting of some of the data within cells in my table. Namely emails had been converted into hyperlinks. Once I formatted thema s plain text. It stopped this issue.

Just need to be careful when modifying\adding cells manually that may convert data to hyperlinks.

Was this reply helpful? Yes No
AuriKlipsch 6 on at

Like (2)

Report
Modern.ie VM Password: Passw0rd!
Easy way to remove Hyperlinks from Excel sheet:

Press Alt+F11 to open the VB editor.
Add the VB sub below and Save. Ignore macro-free worksheet error if prompted, unless you want to save this macro.
Close, then go to Macros and run the macro. It will remove all hyperlinks from the active sheet.

Sub RemoveHyperlinks()

' Remove all hyperlinks from the active sheet.
ActiveSheet.Hyperlinks.Delete

End Sub

Based on this video: How To | Remove all Hyperlinks from Excel - YouTube
Worked for me 🙂

Good luck!

Was this reply helpful? Yes No