I haven't changed the queries and the general structure of the workbooks, the data comes from, also didn't change, just (some of) the values.ĭo you know, what might be causing this and how to resolve it? ", but the data is not updated, the numbers remain the same as before, even though the data in the connectedĪll the connections worked as intended, but now they don't. When I open the workbook in Excel (and no one else has it opened) and I hit refresh all, it refreshes them, at least it says "Last refreshed.The other workbook, the ones I (wanna) get the data from, are opened in Excel Online by others.I know, that the refreshing of the connections only works in excel and that no other user can have the workbook opened.In that workbook there are multiple connections to other workbooks that are also shared with others and used in Excel online. I have a workbook, which is shared with multiple other users and is normally used in excel online.I have a problem with a data querie/ connection in Excel not refreshing (not updating the values), even though it says it refreshed.
0 Comments
Leave a Reply. |