Forum Discussion
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_EekelenPlatinum Contributor
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.