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
