Linking Tables

Copper Contributor



I am trying to link two excel tables in online excel.  This issue is very easy to solve by using power query however I need the dashboards to be used via excel-online for digital display.  Unfortunately, excel will not allow power queries to operate in excel-online.  Is there a way to simply link the excel table in one file (the source) and relay that same table to a separate file so that it reflects everything being inserted into the source table?    



1 Reply


Power Query in Excel for web works with the sources in the same file, so far external sources are not allowed.

Not sure if there is the simple way to sync data in different workbooks. Variant could be Move data between workbooks automatically with Office Scripts & Power Automate | Excel Off The Grid ...