Not able to open shared excel over MS365

Question

I am not able to open a shared excelsheet via one drive on my laptop

You can find below the first error

Then I tried to open it via the desktop app as you can see below, but it takes forever and does not open

Is there a way to download the shared file from OneDrive please

Answer 1

Hi nightearth,

Sorry for this inconvenience caused by this issue.

After our test, we can click Open in App and it can work perfectly in desktop Excel. Based on your screenshot, you are using mac but category of this case is Windows.

We assume that you are suing Office for mac. So we suggest you try these steps to narrow down this issue.

1. Go to Macintosh HD open the Library folder. Click Containers click and Move this folder to other local path.

Open Finder> Click on Commnad + Shift + G> Enter ~/Library/Containes> Scroll to com.microsoft.Excel> Move to other location  like Desktop.

Then restart PC try to launch Excel application from Online again.

2. Open other shared Excel file in Excel Online and try to open in Excel application again. To check if only this situation happens to specific file. 
3. Change a different browser to test the result.

In the shared tab of OneDrive, we can’t sync or download these files, we can only see them in the shared with me tab. As a workaround, you can open this shared file in Excel directly. Open Excel application, after sign in click Home button-> Shared, find this shared file and open it in Excel application. Moreover, i want to share this article with you about the file size limits for workbooks in SharePoint Online.

If the issue still persists, we want to collect more information to move further:

1. Does the issue happen to other Online files?
2. Can you take a screenshot of the Excel version? Excel-> About Excel. (Please remove personal information.)

Regards,

Ivy

Answer 2

Hi nightearth, 

Can you access shared document after trying my suggestion? 

Please feel free to post back if you still need help on this issue. 

Regards,

Ivy

Answer 3

Hi Ivy,

Thank you so much for you close attention to my annoying issue that my team and me are facing with sharing excel sheet over OneDrive.

Honestly, I do not like to play with OS files so I tried to open the file on WIN 10 Pro PC and I am still facing the same issue.

Answer 4

Hi nightearth, 

Thanks for your efforts of this issue.

As you can’t open this file in both Excel for Mac and Windows. To better understand this issue, we want to conform this steps results with you:

1. Can you open this File in Excel directly via Excel-> Open -> Shared with me?  Can you see this file?
2. Can you open other shared files in OneDrive Online shared tab? Can you let owner to share this file to your colleagues to check if colleagues can open it?
3. If it’s possible , could you please ask the file owner to share a “Anyone can open this file” link with us so that we can test in our end. To protect your personal information, you can send the linkin PM.(This file-> Shared)

 

We really want to help so please don’t mind these steps. We will provide further assistance for you after checking these results.

Regards,

Ivy

Answer 5

Hi nightearth, 

Can you open this shared Excel document in desktop application now? Did my suggestion work?

Please feel free to contact us if you need further help.

Regards,

Ivy