This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 57.99999999999999%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Hi,
I hope you are doing well. I am exploring Microsoft Graph Explorer for excel API and testing get worksheets in workbook endpoint. Although I have provided correct drive-item-id , I'm keep getting following error.
{
"error": {
"code": "FileOpenUserUnauthorized",
"message": "You do not have permissions to open this file in the browser.",
"innerError": {
"code": "unauthorizedUncategorized",
"message": "Required authentication information for the resource is either missing or invalid.",
"innerError": {
"code": "FileOpenUserUnauthorized",
"message": "You do not have permissions to open this file in the browser."
},
"date": "2024-03-20T09:56:42",
"request-id": "4270-9686-cfe5528d974b",
"client-request-id": "b7e4b-a36a-3003-449e4d4f90f0"
}
}
}
I have given all permission for onedrive and file still it is no use.
Can anyone help me with this error?
Which API endpoint are you calling?
I'm calling this endpoint.
https://graph.microsoft.com/v1.0/me/drive/items/{drive-item-id}/workbook/worksheets
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 25%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
hi, i am having the same error, how did you solve it. i am getting this error when i am accessing excel sheets from microsoft graph api. Although it says i have no permission, i have granted and confirmed all permission within my microsoft azure and in my vanilla javascript code. I am getting this error as well in the microsoft graph explore and still confirmed the file permission. but still having the error. Could someone please help me out this is a project i am undertaking for my final year at Univerisity.
Error message :
{
"error": {
"code": "FileOpenUserUnauthorized",
"message": "You do not have permissions to open this file in the browser.",
"innerError": {
"code": "unauthorizedUncategorized",
"message": "Required authentication information for the resource is either missing or invalid.",
"innerError": {
"code": "FileOpenUserUnauthorized",
"message": "You do not have permissions to open this file in the browser."
},
"date": "2024-03-26T18:12:33",
"request-id": "1e02f6e1-c233-4ded-a43c-f1b71991c02b",
"client-request-id": "16eadc3d-0f7a-d6c3-9a58-2a628af98d61"
}
}
}
Apparently, i checked my access token, i think for some reason i have lile two token, one token has the permission :
as you can see it says token in the network pannel.
if i open the first token which has preflight it comes up as this :
if i open the second token it comes up with this :
I think the error maybe i have two token but then again i need a way to solve this. Can someone please help me out, i am getting the same error in microsoft graph explore when i retreive any excel files.
I will appreciate it please if someone can get back to me. Thank You
Hi @kishan parmar
Please make sure you have granted the Files.ReadWrite permission.
Hope this helps.
If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.
Hi @kishan parmar
Is there anything else I can help you with regarding this issue? If you still need further help, please feel free to let me know. If your question has been solved, then you can click "Accept Answer", which may help members with similar questions find the answer easily. Thank you very much!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 53%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 59%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Hey I am also facing this error and I have granted the access in Graph. But for the apps that I have installed I am getting this error. How to grant access to this Permission for other apps that I have installed.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 75%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
I opened a new question about this problem, ı have too the same problem. You can follow the link below.