Forum Discussion
Data Tab
Except Open in Dekstop doesn't work if Excel Desktop is not installed - subscription is without Office desktop apps.
Seeing as the screenshot is of a browser window, I am going to assume you have opened the file in "Excel Online." This is usually the default option when you click on the file in OneDrive, Teams, SharePoint, in Outlook, etc.
As SergeiBaklan has said, this means you will have limited functionality available to you in comparison to working with the file in Excel Desktop. To switch to Desktop, click the Open in Dekstop button at the top to the right of all the tabs where the data tab is.
This "should" open the file in your desktop version of Excel. If you do not have a desktop versionof Excel then one needs to be installed before you can get external data into the Excel workbook.
Except Open in Dekstop doesn't work if Excel Desktop is not installed - subscription is without Office desktop apps.
thanks for your help and everyone in the community. right, excel desk top version has to be installed.
Thanks SergeiBaklan., I did add that in my reply.
