Forum Discussion

LindaBee05's avatar
LindaBee05
Copper Contributor
Sep 07, 2026

Linked data not updating

Hi I have a rostering spreadsheet where each person has their own spreadsheet with their rota they select a shift in their spreadhseet. I have a main spreadhseet

where I link each spreadhseet to my my main rota  so I can see what shifts they have selecteeneed and be able to resolve any conflicts i.e 2 peole selecting sam eshift. The issue is when data is updated in the individual spreadhseet it is not pulling through to my main spreadsheet. I used Data and get data form Excel file to link the workbooks. Not sure what I am doing wrong

 

When Dr Adams adds a Y in Thursday it is not showing in my spreadhseet

 

 

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    LindaBee05​ 

    Please show how you have linked the individual sheet to the main sheet.  It seems that whatever you do works for Wednesday / N Ward as you show two names in the main sheet. Difficult to determine whey it doesn't work on Thursdays.