Can't open Excel files from Sharepoint

[CrazyKZ]

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."

[#2]

yes, same issue in our company.

we need help

[#3]

@Dave_Zwyssig2245 

Two interesting articles regarding MS 365:

https://support.microsoft.com/en-us/office/how-do-i-turn-on-autosave-dbd19b49-ff3a-48f5-8294-671e33a...

https://learn.microsoft.com/en-us/officeupdates/update-history-microsoft365-apps-by-date

So far so good when I use the open method from within Excel and not using the File Explorer. I have to open Excel, point to the MS site, then the Sharepoint drive, then scroll to the file to open.

Way slower, but at least it works now. :) 

[#4]

@CrazyKZ 

So you are saying it's running well at past?

[#5]

@Kidd_Ip 

Yes, for 10 years until last week.