Usage of external data source in Excel for iPad

%3CLINGO-SUB%20id%3D%22lingo-sub-1883684%22%20slang%3D%22en-US%22%3EUsage%20of%20external%20data%20source%20in%20Excel%20for%20iPad%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1883684%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%E2%80%98ve%20got%20a%20question.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20update%20an%20Excel-sheet%20in%20Excel%20for%20iPad%20which%20i%E2%80%98ve%20created%20in%20Excel%20for%20Mac%20and%20which%20is%20using%20an%20external%20data%20source%20%3F%20I%20made%20an%20Excel-sheet%20with%20share-prices.%20On%20my%20Mac%20i%20can%20update%20this%20sheet%20with%20actual%20share-prices%20but%20not%20on%20Excel%20for%20iPad.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20generally%20possible%20to%20work%20in%20Excel%20for%20iPad%20with%20external%20data%20sources%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thank%E2%80%98s%20in%20advance%20for%20your%20help%20!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1883684%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1883928%22%20slang%3D%22de-DE%22%3ESubject%3A%20Usage%20of%20external%20data%20source%20in%20Excel%20for%20iPad%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1883928%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867781%22%20target%3D%22_blank%22%3E%40MatzeHH%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EMy%20knowledge%20of%20the%20ipad%20is%20limited%20to%20the%20essentials%20(to%20put%20it%20mildly).%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EBut%20during%20my%20research%20I%20came%20across%20the%20following%20information%2C%20which%20I%20am%20sending%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E*%20It%20is%20better%20to%20have%20an%20imprecise%20answer%20than%20none%20at%20all%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E(Nikolino).%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EOn%20the%20Data%20tab%2C%20in%20the%20Connections%20group%2C%20click%20Update%20All.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ETo%20update%20only%20the%20selected%20data%2C%20click%20Update.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EYou%20can%20also%20right-click%20a%20cell%20in%20the%20range%20or%20table%2C%20and%20then%20click%20Update.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3ESources%3A%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EExcel%20for%20iPad%20Help%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fexcel-for-ipad-help-6b5dc2e1-a8e4-48e6-bb69-cb9a3964bc91%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fexcel-for-ipad-help-6b5dc2e1-a8e4-48e6-bb69-cb9a3964bc91%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FP%3E%3CP%3ERefresh%20an%20external%20data%20connection%20in%20Excel%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frefresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frefresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good day, 

 

i‘ve got a question. 

 

Is it possible to update an Excel-sheet in Excel for iPad which i‘ve created in Excel for Mac and which is using an external data source ? I made an Excel-sheet with share-prices. On my Mac i can update this sheet with actual share-prices but not on Excel for iPad. 

 

Is it generally possible to work in Excel for iPad with external data sources ?

 

Many thank‘s in advance for your help ! 

2 Replies

@MatzeHH 

My knowledge of the ipad is limited to the essentials (to put it mildly). But during my research I came across the following information, which I am sending you.

* It is better to have an imprecise answer than none at all (Nikolino).

 

On the Data tab, in the Connections group, click Update All. To update only the selected data, click Update. You can also right-click a cell in the range or table, and then click Update.

Sources:

Excel for iPad Help

https://support.microsoft.com/en-us/office/excel-for-ipad-help-6b5dc2e1-a8e4-48e6-bb69-cb9a3964bc91?...

Refresh an external data connection in Excel

https://support.microsoft.com/en-us/office/refresh-an-external-data-connection-in-excel-1524175f-777...

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

@Nikolino soory for late reply  

many thank‘s for your research, but it is still not working. In the iPad-version there‘s a data-tab but you‘ve got only 4 options under this tab and unfortunately no refresh-button like in the desktop-version. 

 

In the meantime i accepted that currently there‘s no possibility to use the moibile Excel-version for my purposes. 

 

Once again many thank‘s & Regards

Matthias