Forum Discussion

CrazyKZ's avatar
CrazyKZ
Copper Contributor
Jul 05, 2023

Can't open Excel files from Sharepoint

I can't open any Excel files form Sharepoint. I can see the files and even open them locally, but they won't open from Sharepoint.

I ran a full Office online repair but that didn't help. 

I have no add-ins. 

My Trust Center in Excel indicates the path of the drive.
I've rebooted multiple times. No updates to Windows nor Office are needed. 

Some files can be opened, others can't. The main issue is running my macro from a file that is on Sharepoint that reads from a Sharepoint file in the same directory. It says that it can't open it. Then when I go point to it and try to open it, it also says that it can't open the file. 

 

It seems that the culprit might be one or several MS updates that happened recently. Is there a known issue related to Sharepoint and macro's running on a network drive?

 

This is happening with two PC's in two different locations, both logged in with my Microsoft account. 

I uninstalled two MS updates this morning, but that didn't fix the problem.

I can save a file to Sharepoint and even see it, but when I try to open it it says "I'm sorry, we couldn't open xyz file."

 

 

Resources