Aug 08 2020 08:17 AM
Dear team members.
Im a school teacher and was wondering about a way to keep my students informed about their tasks and grades. Therefore I´ve created an Excel sheet with the information of the whole group (my personal overview) and then I created a file for each student. The information in the student file is linked to the spaces of my general source file.
My problem is that the data is only updated in the student file if I have it open. Ideally I only open my source file where I edit all the data and, without opening all the other sheets, the links are updated automatically. I´ve already followed various online advice (changing configuration of links and even trust center) but can´t make it happen. Does anyone have other ideas of what is going wrong?
Thanks in advance.
Aug 08 2020 08:51 AM
Aug 08 2020 01:46 PM
Dear @NikolinoDE,
Thank you very much for your fast reply. I was checking out the name manager you suggested, but I can´t see where it helps me here. Maybe you can give me an example how to use it?
I was looking for a way to overcome the error message of deactivated links:
I believe that this is the reason why my students can´t see recent changes on Onedrive that I made in my class overview because those changes are also only reflected if I open each students file on my computer. Which is not my idea - to have all student files open at once in order for them to get updated immediately.
Aug 09 2020 03:20 AM