Forum Discussion
SaraBo
Sep 11, 2023Brass Contributor
How to include a picture from a hyperlink (to Sharepoint doclib) in Word?
I want to create a Worddoc where a picture changes automatically once the pic in the Sharepoint doclib is replaced. (the Worddoc and the SP have accessrights for the same group of people on the same ...
SaraBo
Sep 12, 2023Brass Contributor
Thx for your reply. How I have things set up in SP (Sharepoint) the sharing part is correctly setup. As in as I am able to access the file in SP directly, the Word app using the same link should also have access. Right now in Excel it is possible to do a similar thing with the =IMAGE() function. So thanks to your reply I thought of trying the same there.
In Excel I get the #BLOCKED error and some more info on Active Content. In the infopage that is linked in the Excel error message it says Word has the same (unfortunetly the screenshots in this page haven't been changed recently it seems: https://support.microsoft.com/en-us/office/active-content-types-in-your-files-b7ff2e8a-4055-47d4-8c7d-541e19f62bea). I will have to check where to change these settings. I'll keep you posted if I find a solution!
In Excel I get the #BLOCKED error and some more info on Active Content. In the infopage that is linked in the Excel error message it says Word has the same (unfortunetly the screenshots in this page haven't been changed recently it seems: https://support.microsoft.com/en-us/office/active-content-types-in-your-files-b7ff2e8a-4055-47d4-8c7d-541e19f62bea). I will have to check where to change these settings. I'll keep you posted if I find a solution!
SaraBo
Sep 12, 2023Brass Contributor
It's getting more weird by the minute...
- So it seems any hyperlink is considered a Linked Data Type/Active Content and thus a danger (in Excel, in Word it seems to see the safety)... whilst the link is coming from the same tenant?!? Hoping that Copilot will finally be able to make the whole of MS365 recognize same tenant links as secure...
- I found the Trust Center through the Info tab and refreshed the links from there (in Word, in Excel the links are stored elsewhere, not even in the queries and connections but only in the function). Why not add some more consistency here too?
Conclusion: whatever I do there's nothing changing. But given the #BLOCKED error in Excel I'd suppose there is a security-setting involved blocking this productivity-enhancer. Would it be worth trying to find out which setting it is, knowing that we'll probably be getting a no-go afterwards from IT dept...
- So it seems any hyperlink is considered a Linked Data Type/Active Content and thus a danger (in Excel, in Word it seems to see the safety)... whilst the link is coming from the same tenant?!? Hoping that Copilot will finally be able to make the whole of MS365 recognize same tenant links as secure...
- I found the Trust Center through the Info tab and refreshed the links from there (in Word, in Excel the links are stored elsewhere, not even in the queries and connections but only in the function). Why not add some more consistency here too?
Conclusion: whatever I do there's nothing changing. But given the #BLOCKED error in Excel I'd suppose there is a security-setting involved blocking this productivity-enhancer. Would it be worth trying to find out which setting it is, knowing that we'll probably be getting a no-go afterwards from IT dept...