What am I doing wrong when using sharepoint on excel

New Contributor



i have a person who is a member of a sharepoint file / group and they cannot see it on excel when they open it.


they’ve tried opening sharepoint on office 365 and opened file ok but when went back into excel to open it not find it.


what are we doing wrong please? 


2 Replies

@tweacleI have experienced that the Document Library in the SharePoint site does not appear in Excel if you have not been inside and worked in the document library via the desktop version of Excel before. If this person enters the SharePoint site, selects the file and selects "open" and then selects "Open in app", the file should be opened in the desktop version of Excel. The next time the person opens Excel, selects "Open" and "Sites", Excel should "remember" the address and appear under "Frequent" and he/she should be able to open the SharePoint site's document library and its files from there.
Another thing you can try is to go to the SharePoint site and choose to follow the site. Then it can be displayed under "Following" when you open Excel and select "Open" and "Sites".
Hope one of these variants solves the problem.


Sorted. Big massive thanks