Arranging, splitting, hiding, or switching windows.Page break, page layout, and custom views.In fact, all you can do is create a private sheet view, open a new spreadsheet window, freeze panes, or hide and show headings and gridlines.Īll of the other features are missing, such as: There are no forecast or outline groups that you find on the Excel for desktop ribbon at all.Įven with all of those Data menu features missing, it is good at least that Microsoft Excel online does provide the ability to bring in stock and geography data sources from the internet.Data tools group lacks text to Columns, flash fill, consolidate, and relationships.No ability to “Get Data” from external sources like text, web, or database files.The following Data menu features are missing from Microsoft Excel online: None of those missing features are found in any hidden menus either. The Data MenuĪt first glance, it’s pretty clear that Microsoft Excel online only has about half of the features present in the Excel for desktop version.

You just have to go about finding them somewhat differently than you do in Excel for desktop. We do not triage on weekends.If you change the Pick a category dropdown to All, you see that just about all of the formula functions you’d expect to be present in Excel are there. Normally, response time is <10 hours Monday through Friday. Our triage team will respond to you in less than 72 hours. Thank you for taking the time to report an issue. It worked for internal users, but it returns empty value for guest users too. I tried to get workbook url via getFilePropertiesAsync. The guest uploads the Office Add-in manifest file.The guest opens a workbook which is from your tenant in Excel on the web.Invite a guest user to join your tenant.Build an Office Add-in for Excel on the web.returns workbook url for internal users, but it returns empty value for guest users.

should return workbook url for guest users.

Browser (if using Office on the web): Edge.

We invited external users to our tenant and to use the Office Add-in. We have an Office Add-in deployed to Excel on the web in our company tenant. Provide required information needed to triage your issue

Excel web