Multiple power queries from the same data source

  • Hi

    I have created three power queries to have a different view of the same information, but for whatever reason, any new data entered in either of the Amazon tabs gets only updated in one power query which I have created last - please see attached file.

    I am new to the power queries and not sure if it's possible to have multiple power queries from the same data source? I would be grateful if you could review my power queries and let me know what might have caused this issue.

    Also, not sure if this should go on a separate thread, but I have researched that if you have the below VBA code in the data source tabs, power queries should automatically update themselves, but I find that it is very slow. Any thoughts on how to make the refreshing faster?

    Private Sub Worksheet_Change(ByVal Target As Range)
    End Sub



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!