question

PatGonyon-4398 avatar image
0 Votes"
PatGonyon-4398 asked emizhang-msft commented

does excel in onedrive for business have a get data from external sources option?

on desktop excel you are able to make a data connection with microsoft query to another database. I cannot find this option in onedrive. when I copied an existing spreadsheet to onedrive and tried to refresh the data the error says the external data refresh failed.

office-excel-itprooffice-onedrive-client-itpro
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@PatGonyon-4398

According to your description, your issue is not much related to SharePoint Online. Therefore, we will remove the "office-sharepoint-online" tag.

And your issue is more related to office. I will add “office-onedrive-client-itpro” and “office-excel-itpro” tags.

Thank you for your support and understanding.

Have a nice day!

0 Votes 0 ·

Hi @PatGonyon-4398,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 Votes 0 ·

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered

Hi @PatGonyon-4398,
Did you mean you cannot refresh data from OneDrive in web?
Not all features are supported in Excel for Web, as the article said: The last known value for an external reference is displayed in a browser window. External references must be updated using Excel.
Refer to this support article and check if you can get any help:
https://support.microsoft.com/en-us/office/differences-between-using-a-workbook-in-the-browser-and-in-excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6
Please let us know if you would like further assistance.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.