Error: 401 - FileOpenUserUnauthorized - Graph API

Question

Error: 401 - FileOpenUserUnauthorized - Graph API

Baris 0

When I make a request to this endpoint in the doc then ı get the following error and ı am sure, ı have the necessary "permissions" for the request.

Error and Message:

Error: 401 - FileOpenUserUnauthorized
Message: You do not have permissions to open this file in the browser.

I did some research and the same problem is mentioned in forums here:

CarlZhao-MSFT 46,371 Reputation points

2024-05-27T10:09:10.58+00:00

Hi @Baris

Let me check your access token. Try decoding your access token using jwt.ms and share the screenshot.
Baris 0 Reputation points

2024-05-27T10:20:31.9833333+00:00

I use graph explorer and here my permission, my token is correct format ı guaranteed.
DasDune Thailand 5 Reputation points

2024-05-28T02:19:24.7666667+00:00

Same for me, my app runs without problem for years, and this morning got this error. My query is : https://graph.microsoft.com/v1.0/me/drive/items/E97916D0B5077B6C!4981/workbook/worksheets('Documents')/usedRange.

Not working in MS Graoh Explorer either.

I guess the problem is on Microsoft side. Any clues ?
Baris 0 Reputation points

2024-06-03T09:36:58.7333333+00:00

Maybe, it would be nice to get an answer from microsoft dev team. You can open a “service request” here.
Abhishek 10 Reputation points

2024-06-05T02:26:46.77+00:00

I am running into this for personal OneDrive accounts. I consented Files.ReadWrite but still running into the same issue.

"https://graph.microsoft.com/v1.0/me/drive/items/<id>/" works to get Excel workbook but "https://graph.microsoft.com/v1.0/me/drive/items/<id>/workbook/worksheets" show following error.

Any help here would be appreciated.
François Gélinas 0 Reputation points

2024-06-07T00:23:24.8366667+00:00

Did you find a solution? My app also was running fine and than get this error.
Echologr 0 Reputation points

2024-06-23T20:17:36.99+00:00

Hi! I want to back this. Having the same problem with a personal account. A free one is working fine.

Thanks!

Echologr
Abylin Johnson 0 Reputation points

2025-02-25T06:43:57.9633333+00:00

I allow my users to integrate their Excel sheets with my application. However, when I try to do so, I get the same error. I have granted my application the Files.ReadWrite.All permission. As Tran Trong Nghia mentioned, the integration works fine if I open any sheet from my OneDrive; however, after some time, the error starts occurring again. Can you suggest a solution for this? I can’t ask my users to keep their sheets open on a desktop.
Prabhpahul Singh 0 Reputation points

2025-03-02T21:06:18.5366667+00:00

I am having the same error integrating excel through api I have the permissions mentioned, also it was working two weeks back. Similar issue with used-range api, returning bad request
XJ 0 Reputation points

2025-05-19T08:12:04.43+00:00

Hi Abylin, have you found a solution for this? Having the same dilemma right now. I have to open the excel file on a browser every now and then (expires after a while) so I can do graph calls.

1 answer

Your answer

CarlZhao-MSFT 46,371 Reputation points

2024-05-27T10:09:10.58+00:00

Hi @Baris

Let me check your access token. Try decoding your access token using jwt.ms and share the screenshot.
Baris 0 Reputation points

2024-05-27T10:20:31.9833333+00:00

I use graph explorer and here my permission, my token is correct format ı guaranteed.
DasDune Thailand 5 Reputation points

2024-05-28T02:19:24.7666667+00:00

Same for me, my app runs without problem for years, and this morning got this error. My query is : https://graph.microsoft.com/v1.0/me/drive/items/E97916D0B5077B6C!4981/workbook/worksheets('Documents')/usedRange.

Not working in MS Graoh Explorer either.

I guess the problem is on Microsoft side. Any clues ?
Baris 0 Reputation points

2024-06-03T09:36:58.7333333+00:00

Maybe, it would be nice to get an answer from microsoft dev team. You can open a “service request” here.
Abhishek 10 Reputation points

2024-06-05T02:26:46.77+00:00

I am running into this for personal OneDrive accounts. I consented Files.ReadWrite but still running into the same issue.

"https://graph.microsoft.com/v1.0/me/drive/items/<id>/" works to get Excel workbook but "https://graph.microsoft.com/v1.0/me/drive/items/<id>/workbook/worksheets" show following error.

Any help here would be appreciated.
François Gélinas 0 Reputation points

2024-06-07T00:23:24.8366667+00:00

Did you find a solution? My app also was running fine and than get this error.
Echologr 0 Reputation points

2024-06-23T20:17:36.99+00:00

Hi! I want to back this. Having the same problem with a personal account. A free one is working fine.

Thanks!

Echologr
Abylin Johnson 0 Reputation points

2025-02-25T06:43:57.9633333+00:00

I allow my users to integrate their Excel sheets with my application. However, when I try to do so, I get the same error. I have granted my application the Files.ReadWrite.All permission. As Tran Trong Nghia mentioned, the integration works fine if I open any sheet from my OneDrive; however, after some time, the error starts occurring again. Can you suggest a solution for this? I can’t ask my users to keep their sheets open on a desktop.
Prabhpahul Singh 0 Reputation points

2025-03-02T21:06:18.5366667+00:00

I am having the same error integrating excel through api I have the permissions mentioned, also it was working two weeks back. Similar issue with used-range api, returning bad request
XJ 0 Reputation points

2025-05-19T08:12:04.43+00:00

Hi Abylin, have you found a solution for this? Having the same dilemma right now. I have to open the excel file on a browser every now and then (expires after a while) so I can do graph calls.

Answer 1

Tran Trong Nghia 5

I had the same problem. I solved it by accessing One Drive, then opening the Excel file in the browser. Then I called the /workbook/worksheets API and it worked. I also had the problem of the /search api returning an empty list. And I tried searching for a file by keyword on the One Drive web (remember to press Enter to display the results). And this api also worked again.

帛松杨 0 Reputation points

2025-06-23T02:36:55.5633333+00:00

What you said is useful. I want to write data into Excel, but this only works for a short time. After a while, I write again and it reports an error.

Share via

Error: 401 - FileOpenUserUnauthorized - Graph API

1 answer

Your answer