Forum Discussion
Sync Tables in Excel for Web
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
2 Replies
- what I can tell, Excel for the Web does not support Power Query for this function,
As you mentioned,it is impossible to snyc master sheet and sub sheet on server side.
I guess you may build your own web system with this function.- https://club.excelhome.net/forum.php?mod=viewthread&tid=1520437&mobile=
Probably like this,everyone login and view his own list.
