I have a team using Excel for the Web.  They all have F3 licenses.

I have a table in a spreadsheet that contains a list of data that the team uses in their individual, local spreadsheets.  I would like to sync the table in the source list with a corresponding table in the individual sheets to allow them to have access to the most up to date information.

From what I can tell, Excel for the Web does not support Power Query for this function, which is what I would use on the desktop.
In addition, “Paste with Links” does not capture new rows in the table, only updates to the rows initially pasted.

Can anyone offer a suggestion on how could keep two tables synced (unidirectional only) including the addition of new rows?

Thank you

​I have a team using Excel for the Web.  They all have F3 licenses. I have a table in a spreadsheet that contains a list of data that the team uses in their individual, local spreadsheets.  I would like to sync the table in the source list with a corresponding table in the individual sheets to allow them to have access to the most up to date information. From what I can tell, Excel for the Web does not support Power Query for this function, which is what I would use on the desktop.In addition, “Paste with Links” does not capture new rows in the table, only updates to the rows initially pasted.Can anyone offer a suggestion on how could keep two tables synced (unidirectional only) including the addition of new rows? Thank you  Read More

​