What am I doing wrong when using sharepoint on excel

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.