Windows 10: Cannot open excel file from sharepoint using file explorer

Hello,I encounter a very weird situation,I suddenly cannot open excel files, which are automatically saved at sharepoint, using file explorer.However, I can access the file using web browser. I can also open the excel file in desktop app, if I click the file from sharepoint web. Moreover, I can also open the excel desktop app and open the files I want directly from there .However, the only issue is I just cannot open the file by clicking it in file explorer.An error message saying make sure the file exists/ make sure file name does not consist < > [ ], etc pops up.I am using surface lapt

:)

 

Open a Sharepoint link in FIle explorer

Hi,

My company uses Sharepoint (and I despise it). My computer is synced to Sharepoint so all company files show in file explorer on my computer. People frequently send me links to files they want me to review and comment on or add a section to. I want to be able to easily open the sharepoint link they send me such that it opens the folder where the file is located in file explorer, NOT sharepoint, because 1-I hate using Sharepoint and 2-I will need to go into the file frequently for a period of time and I want to be able to find it, and 3-if someone does a save as of that file and starts a new version, I want to see that in the folder so that I am not working off of an old version. How can I do this? Can I write a macro to do it?

Things I have tried that don't work:

-Other sites have said to right click on the hyperlink in the email and then paste it into file explorer, but that does not work-It gives an error message saying that Windows can't find it.

-Right click on sharepoint hyperlink in the email and select Open with desktop app. This is not what I need. I want to be able to find it easily in file explorer.

-Open link in sharepoint, Select filename on the upper right of the screen, select the arrow next to location in the dropdown, use that screen to help me find my way to the file in file explorer. This is intensely frustrating and time consuming.

Would welcome any suggestions.

***moved from Windows / Windows 10 / Files, folders, and storage ***

 

excel file causes instability in "windows explorer"

When I open an excel file by double clicking on the name in windows explorer, the file opens OK but at the same

time, the explorer file list jumps up and down as it lists and de-lists the

excel temp file. It is very distracting. I can close the explorer window or

simply change to another folder. It occurs only on one of my computers and only on some excel files

It happens only with excel files and not with word or acrobat

Any suggestions where to look for the problem. We've reinstalled Office 10 and reset my windows profile. nothing helped so far.

 

Open a Sharepoint link in FIle explorer

Dear User,

Greetings! Thank you for posting in Microsoft Community.

I understand your frustration with using SharePoint and your preference for accessing files directly through File Explorer.

As far as I know, I'm sorry and I'm afraid there is no built-in feature to directly open a SharePoint link in File Explorer.

Writing a macro to automate this process isn't feasible as SharePoint links are specific to the web environment and not directly compatible with File Explorer.

We apologize for the inconvenience.

I recommend you try posting your concern to Microsoft Q&A Community with SharePoint tag and ask if there is any customized solution which can meet your requirement. Members and engineers over there are proficient in the knowledge of SharePoint customization and development queries. They will focus on the specific situation on your side and provide specific suggestions for you.



Thank you for your cooperation and understanding!

Sincerely,

Tina | Microsoft Community Moderator