Forum Discussion
Oussama_Rahmani90
Oct 25, 2023Copper Contributor
unable to open Excel file from Sharepoint
"Hello, I am experiencing issues with certain users unable to open files from SharePoint in Excel desktop, although they can do so in the browser. Accessing files from local drives or OneDrive is fun...
jmmcdaniel
Oct 25, 2023Brass Contributor
Here are some troubleshooting steps for the issue of being unable to open Excel files from SharePoint in Excel desktop:
Office Repair: Go to 'Programs and Features' on your PC, select Microsoft Office, and click 'Change'. Choose 'Online Repair'. This fixes most of the Office-related issues.
Office Updates: Ensure Excel and other Office applications are updated to the latest version. Updates might contain patches for software conflicts caused by the MS365 update.
Clear Cache: Clear the Office cache. This can be found in C:\Users[username]\AppData\Local\Microsoft\Office[version number]\OfficeFileCache. Backup, then delete the content of the folder.
Check Permissions: Ensure that users have appropriate permissions on SharePoint. Sometimes, users can view in a browser but not in the desktop due to different permission levels.
File Associations: Ensure .xlsx files are associated with Excel desktop. You can check this in the default apps or programs setting of your operating system.
Disable Add-ins: Start Excel in Safe Mode (by holding 'Ctrl' while starting Excel) to see if any add-ins are causing the issue. If it works in Safe Mode, disable add-ins one by one to identify the culprit.
Office Repair: Go to 'Programs and Features' on your PC, select Microsoft Office, and click 'Change'. Choose 'Online Repair'. This fixes most of the Office-related issues.
Office Updates: Ensure Excel and other Office applications are updated to the latest version. Updates might contain patches for software conflicts caused by the MS365 update.
Clear Cache: Clear the Office cache. This can be found in C:\Users[username]\AppData\Local\Microsoft\Office[version number]\OfficeFileCache. Backup, then delete the content of the folder.
Check Permissions: Ensure that users have appropriate permissions on SharePoint. Sometimes, users can view in a browser but not in the desktop due to different permission levels.
File Associations: Ensure .xlsx files are associated with Excel desktop. You can check this in the default apps or programs setting of your operating system.
Disable Add-ins: Start Excel in Safe Mode (by holding 'Ctrl' while starting Excel) to see if any add-ins are causing the issue. If it works in Safe Mode, disable add-ins one by one to identify the culprit.
- petrhorcickaJul 20, 2024Copper Contributor
jmmcdaniel I've got a same issue and be suspicious that it's caused by the fact that given person is not a member of organization using the SharePoint, i.e. I've got granted access for my personal email and verification code. Can somebody please confirm or deny that hypothesis?
- Dave PatrickNov 11, 2020MVP
The tombstoned ones you could try demote, reboot, promo them again. Also check the required ports are flowing between all.
https://www.microsoft.com/en-us/download/details.aspx?id=24009
- sijoJoseNov 18, 2020Copper Contributor
Dave Patrick If the issue is with ports, then the communication itself will fail right.., there will not be any output.
Here the issue is partial output is received- Dave PatrickNov 18, 2020MVP
I'd check that both ends got the domain network profile, then check the route between them exists and any other firewalls allow the required ports to flow.