How can links to external sources be updated without opening the file?

%3CLINGO-SUB%20id%3D%22lingo-sub-1574768%22%20slang%3D%22en-US%22%3EHow%20can%20links%20to%20external%20sources%20be%20updated%20without%20opening%20the%20file%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574768%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20team%20members.%3C%2FP%3E%3CP%3EIm%20a%20school%20teacher%20and%20was%20wondering%20about%20a%20way%20to%20keep%20my%20students%20informed%20about%20their%20tasks%20and%20grades.%20Therefore%20I%C2%B4ve%20created%20an%20Excel%20sheet%20with%20the%20information%20of%20the%20whole%20group%20(my%20personal%20overview)%20and%20then%20I%20created%20a%20file%20for%20each%20student.%20The%20information%20in%20the%20student%20file%20is%20linked%20to%20the%20spaces%20of%20my%20general%20source%20file.%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20is%20that%20the%20data%20is%20only%20updated%20in%20the%20student%20file%20if%20I%20have%20it%20open.%20Ideally%20I%20only%20open%20my%20source%20file%20where%20I%20edit%20all%20the%20data%20and%2C%20without%20opening%20all%20the%20other%20sheets%2C%20the%20links%20are%20updated%20automatically.%20I%C2%B4ve%20already%20followed%20various%20online%20advice%20(changing%20configuration%20of%20links%20and%20even%20trust%20center)%20but%20can%C2%B4t%20make%20it%20happen.%20Does%20anyone%20have%20other%20ideas%20of%20what%20is%20going%20wrong%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1574768%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574798%22%20slang%3D%22de-DE%22%3ERe%3A%20How%20can%20links%20to%20external%20sources%20be%20updated%20without%20opening%20the%20file%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574798%22%20slang%3D%22de-DE%22%3EMaybe%20with...%20%3CBR%20%2F%3E%20Name%20Manager%3A%20Range%20names%20made%20easy%20%3CBR%20%2F%3E%20Description%20If%20you%20are%20in%20need%20of%20a%20utility%20to%20manage%20defined%20names%20in%20your%20Excel%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20models%2C%20this%20one%20is%20a%20must-have.%20List%20all%20names%20in%20your%20active%20workbook.%20Filter%20them%20using%2013%20filters%2C%20e.g.%20%22With%20external%20references%22%2C%20%22With%20errors%22%2C%20Hidden%2C%20Visible.%20Show%20just%20names%20that%20contain%20a%20substring.%20Show%20just%20names%20unused%20in%20worksheet%20cells.%20Edit%20them%20in%20a%20simple%20dialog%20or%20make%20a%20list%2C%20edit%20the%20list%20and%20update%20all%20names%20in%20one%20go.%20Delete%2C%20hide%2C%20unhide%20selected%20names%20with%20a%20single%20mouse%20click.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fwww.jkp-ads.com%2Fofficemarketplacenm-en.asp%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.jkp-ads.com%2Fofficemarketplacenm-en.asp%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fwww.jkp-ads.com%2Fofficemarketplacenm-en.asp%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.jkp-ads.com%2Fofficemarketplacenm-en.asp%3C%2FA%3E%20%3CBR%20%2F%3E%20The%20third-party%20products%20that%20these%20article%20discusses%20are%20manufactured%20by%20companies%20that%20are%20independent%20of%20me.%20I%20makes%20no%20warranty%2C%20implied%20or%20otherwise%2C%20about%20the%20performance%20or%20reliability%20of%20these%20products.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%20*%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%20%3CBR%20%2F%3E%20*%20Beware%20of%20scammers%20posting%20fake%20support%20numbers%20here.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1575195%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20links%20to%20external%20sources%20be%20updated%20without%20opening%20the%20file%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1575195%22%20slang%3D%22en-US%22%3E%3CP%3EDear%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20your%20fast%20reply.%20I%20was%20checking%20out%20the%20name%20manager%20you%20suggested%2C%20but%20I%20can%C2%B4t%20see%20where%20it%20helps%20me%20here.%20Maybe%20you%20can%20give%20me%20an%20example%20how%20to%20use%20it%3F%3C%2FP%3E%3CP%3EI%20was%20looking%20for%20a%20way%20to%20overcome%20the%20error%20message%20of%20deactivated%20links%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22FrauPhilipp_0-1596919243909.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F211129i68E93172F20C77FF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22FrauPhilipp_0-1596919243909.png%22%20alt%3D%22FrauPhilipp_0-1596919243909.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20believe%20that%20this%20is%20the%20reason%20why%20my%20students%20can%C2%B4t%20see%20recent%20changes%20on%20Onedrive%20that%20I%20made%20in%20my%20class%20overview%20because%20those%20changes%20are%20also%20only%20reflected%20if%20I%20open%20each%20students%20file%20on%20my%20computer.%20Which%20is%20not%20my%20idea%20-%20to%20have%20all%20student%20files%20open%20at%20once%20in%20order%20for%20them%20to%20get%20updated%20immediately.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1576190%22%20slang%3D%22de-DE%22%3ERe%3A%20How%20can%20links%20to%20external%20sources%20be%20updated%20without%20opening%20the%20file%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576190%22%20slang%3D%22de-DE%22%3EI'm%20not%20sure%2C%20but%20under%20%22This%20workbook%22%20try%20the%20following%20code.%20%3CBR%20%2F%3E%20This%20means%20that%20the%20reporting%20windows%20are%20deactivated%20not%20the%20link%20itself.%20%3CBR%20%2F%3E%20--------------------------------------------%20%3CBR%20%2F%3E%20Private%20Sub%20Workbook_Open()%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20'Turn%20messages%20off%20%3CBR%20%2F%3E%20Application.DisplayAlerts%20%3D%20False%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20End%20Sub%20Private%20Sub%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Workbook_BeforeClose(Cancel%20As%20Boolean)%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20'Turn%20messages%20back%20on%20%3CBR%20%2F%3E%20Application.DisplayAlerts%20%3D%20True%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20End%20Sub%20------------------------------------------%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Nikolino%20I%20know%20I%20%3CBR%20%2F%3E%20don't%20know%20anything%20(Socrates)%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%20%3CBR%20%2F%3E%20*%20Beware%20of%20scammers%20posting%20fake%20support%20numbers%20here.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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.

3 Replies
Highlighted
maybe with...
Name Manager: Range names made easy
Description

If you are in need of a utility to manage defined names in your Excel models, this one is a must-have. List all names in your active workbook. Filter them using 13 filters, e.g. "With external references", "With errors", Hidden, Visible. Show just names that contain a substring. Show just names unused in worksheet cells. Edit them in a simple dialog or make a list, edit the list and update all names in one go. Delete, hide, unhide selected names with a single mouse click.

https://www.jkp-ads.com/officemarketplacenm-en.asp

The third-party products that this article discusses are manufactured by companies that are independent of me. I makes no warranty, implied or otherwise, about the performance or reliability of these products.

Nikolino
I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
* Beware of scammers posting fake support numbers here.
Highlighted

Dear @Nikolino,

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:

FrauPhilipp_0-1596919243909.png

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.

Highlighted
ich bin mir nicht sicher, aber probieren Sie unter "Diese Arbeitsmappe" folgende Code.
Damit werden die Melde fenster deaktiviert nicht der Link selbst.
--------------------------------------------
Private Sub Workbook_Open()

'Meldungen ausschalten
Application.DisplayAlerts = False

End Sub


Private Sub Workbook_BeforeClose(Cancel As Boolean)

'Meldungen wieder einschalten
Application.DisplayAlerts = True

End Sub
------------------------------------------
Nikolino
I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
* Beware of scammers posting fake support numbers here.