Nov 13 2020 12:58 AM
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 !
Nov 13 2020 02:32 AM
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
Refresh an external data connection in Excel
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Nov 20 2020 12:05 AM
@NikolinoDE soory for late reply :flushed_face:
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
Sep 20 2022 05:03 PM
@NikolinoDE You could not be more wrong about that. In what world is an incorrect answer better than no answer at all? I mean, this idea isn’t debatable in the least. It’s flat out dumb. If you don’t know the answer, don’t answer it!
Sep 21 2022 01:31 AM
There are people who can find a problem with every suggested solution and there are people who get a step further with every suggested solution.
Any proposal for a solution generates energy, energy generates work and work creation.
No proposal for a solution, it produces inaction, inaction creates stagnation, stagnation creates… Nothing, Rien, Nichto, Nanimonai.
In this forum there is no place for insults to impose one's personal point of view,
Everyone has their own point of view, that doesn't mean that the other's point of view is "stupid" .
Realizing one's own stupidity can be painful.
But by no means stupid (Oliver Hassencamp).