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

DANNETTE 1 Reputation point
2022-04-08T18:25:51.123+00:00

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.

SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
571 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,934 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Du-MSFT 45,746 Reputation points Microsoft Vendor
    2022-04-11T08:57:42.71+00:00

    @DANNETTE

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.