Can adds/updates on a subsite Excel worksheet automatically update parent site worksheet?

Question

question

DANNETTE-9380 asked Apr 8, '22 EmilyDu-MSFT commented Apr 15, '22

Can adds/updates on a subsite Excel worksheet automatically update parent site worksheet?

SharePoint 2016: Using a shared Excel worksheet on a parent site currently and would like to create subsites that present just the filtered view of this same worksheet for the subteams. Ideally, end users of the subsites would make changes to their list and any updates or additions made on the subsite worksheet would automatically be reflected on the parent worksheet as well.

Is that possible?

Just trying to have a single spot for the subteams that feed into the overall parent team to reduce work effort by updating on the single shared worksheet. It's just too many users (50+) trying to access one worksheet.

office-sharepoint-server-administration sharepoint-workflow

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-04-11T08:57:42.71Z

EmilyDu-MSFT answered Apr 11, '22 EmilyDu-MSFT commented Apr 15, '22

@DANNETTE-9380

Based on your description, I understand that you want yo create a view for main site users and another view for sub site users in a shared Excel worksheet. When sub site users update data in the sub site view, data will automatically be updated in the main site view.

In the shared Excel worksheet -> View tab -> Custom view -> Add -> Add view for sub site users. Then sub site users can choose the newly created view to view and update data.

Reference:

https://support.microsoft.com/en-us/office/create-apply-or-delete-a-custom-view-ce722bf9-0b4a-49a5-94ba-438fde18fc2b

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

EmilyDu-MSFT · Apr 15 at 08:11 AM

@DANNETTE-9380

I’m checking how the things are going on about this issue. Whether the answer helps you?

If there is any problem with this issue, feel free to let me know.

0 ·

question