Forum Discussion
How can links to external sources be updated without opening the file?
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 whol...
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.
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.
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.