Forum Discussion

tweacle's avatar
tweacle
Copper Contributor
Aug 02, 2022

What am I doing wrong when using sharepoint on excel

Hi   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 w...
SharePoint Online
MagnusGoksoyrOLDProfile's avatar
MagnusGoksoyrOLDProfile
Bronze Contributor
Aug 03, 2022

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.

shreked's avatar
shreked
Copper Contributor
Aug 04, 2022
Sorted. Big massive thanks
  • tweacle's avatar
    tweacle
    Copper Contributor
    Aug 30, 2022

    shreked Sorry it may be me being dumb here.  When someone new wants to see on their excel sheet. I know that I have to open in sharepoint as previous comments but do I have to put some data in and then save it before closing in sharepoint for it to show in excel list?

Resources