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
2 Replies
One thing I’d check is whether Excel is blocking external content or links in the file. Try Data → Refresh All, then check the connection/query properties and make sure automatic updates are enabled. If it still doesn’t update, opening the source file once and refreshing can help narrow down whether the issue is the link or the source itself.
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.
