Alert message in excel for updating links.

%3CLINGO-SUB%20id%3D%22lingo-sub-1476508%22%20slang%3D%22en-US%22%3EAlert%20message%20in%20excel%20for%20updating%20links.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1476508%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20Yesterday%20in%20excel%20i%20tried%20to%20copy%20a%20macro%20to%20my%20personal%20library%20and%20from%20that%20time%20whenever%20I%20open%20excel%20I%20have%20this%20specific%20message%20%22This%20workbook%20contains%20links%20to%20one%20or%20more%20external%20sources%20that%20could%20be%20unsafe.%20If%20you%20trust%20these%20links%20update%20them%20to%20get%20the%20latest%20data%2C%20otherwise%20you%20can%20keep%20working%20with%20the%20data%20you%20have.%20After%20that%2C%20I%20have%20another%20message%20%22we%20can't%20update%20some%20of%20the%20links%20in%20your%20workbook%20right%20now.%20You%20can%20continue%20without%20updating%20their%20values%20or%20edit%20the%20links%20you%20think%20are%20wrong.%20I%20have%20to%20mention%20that%20i%20have%20some%20links%20to%20files%20using%20power%20query%20but%20this%20problem%20arose%20since%20i%20copied%20the%20macro%20to%20my%20personal%20library.%20What%20can%20i%20do%20to%20remove%20these%20messages%20because%20they%20are%20really%20annoying.%20Thank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1476508%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello, Yesterday in excel i tried to copy a macro to my personal library and from that time whenever I open excel I have this specific message "This workbook contains links to one or more external sources that could be unsafe. If you trust these links update them to get the latest data, otherwise you can keep working with the data you have. After that, I have another message "we can't update some of the links in your workbook right now. You can continue without updating their values or edit the links you think are wrong. I have to mention that i have some links to files using power query but this problem arose since i copied the macro to my personal library. What can i do to remove these messages because they are really annoying. Thank you in advance!

0 Replies