Forum Discussion
Data Tab
When I click on data tab, my options are refresh connection or refresh all connections. Can someone tell me why I don't have get external data? Thanks
Except Open in Dekstop doesn't work if Excel Desktop is not installed - subscription is without Office desktop apps.
9 Replies
Hi lovingizneverez , What version and license of Excel do you have? Best take a screenshot of the backstage page you see with File > Account.
not sure if this is what you are talking, but here is a screen shotIngeborgHawighorst
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.
