If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Rate Thread | Display Modes |
#1
|
|||
|
|||
Removing this redundant message?
I have an Excel worksheet with several hundred hyperlinks to videos I've
made. So it's tiresome to get this message every time I click one to play it: https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0 I found several web articles such as this that seemed promising but didn't work. Probably incompatible with Win 10. None of the registry hacks like that which I've tried so far have exorcised the message. https://support.microsoft.com/en-gb/...007-office-pro So I'm still looking, and have posted in the Excel forum too. It's annoying that I can't be trusted to open files I created from scratch myself! Can anyone here suggest a solution please? Terry, East Grinstead, UK |
Ads |
#2
|
|||
|
|||
Removing this redundant message?
"Terry Pinnell" wrote in message ... I have an Excel worksheet with several hundred hyperlinks to videos I've made. So it's tiresome to get this message every time I click one to play it: https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0 I found several web articles such as this that seemed promising but didn't work. Probably incompatible with Win 10. None of the registry hacks like that which I've tried so far have exorcised the message. https://support.microsoft.com/en-gb/...007-office-pro So I'm still looking, and have posted in the Excel forum too. It's annoying that I can't be trusted to open files I created from scratch myself! Can anyone here suggest a solution please? http://www.majorgeeks.com/files/deta...n_button).html |
#3
|
|||
|
|||
Removing this redundant message?
Terry Pinnell wrote:
I have an Excel worksheet with several hundred hyperlinks to videos I've made. So it's tiresome to get this message every time I click one to play it: https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0 I found several web articles such as this that seemed promising but didn't work. Probably incompatible with Win 10. None of the registry hacks like that which I've tried so far have exorcised the message. https://support.microsoft.com/en-gb/...007-office-pro So I'm still looking, and have posted in the Excel forum too. It's annoying that I can't be trusted to open files I created from scratch myself! Can anyone here suggest a solution please? Terry, East Grinstead, UK Could you export the Excel table every once in a while as HTML, and open your table with a browser ? https://support.office.com/en-us/art...9-CF0530AB1968 If the links were local, you would expect them to be file:\\ or similar. It's not really a good idea to thwart Office security, if there's a possibility of you opening a doc you got off the Internet. If a dialog box pops up after you open something like that, the dialog box preventing instant execution could be a lifesaver. Paul |
#4
|
|||
|
|||
Removing this redundant message?
Terry Pinnell wrote:
I have an Excel worksheet with several hundred hyperlinks to videos I've made. So it's tiresome to get this message every time I click one to play it: https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0 I found several web articles such as this that seemed promising but didn't work. Probably incompatible with Win 10. None of the registry hacks like that which I've tried so far have exorcised the message. https://support.microsoft.com/en-gb/...007-office-pro So I'm still looking, and have posted in the Excel forum too. It's annoying that I can't be trusted to open files I created from scratch myself! Can anyone here suggest a solution please? Just a guess but wondering if this has to do with: Internet Options - Advanced - Security section (at the bottom) "Allow active content to run in files on My Computer" With Microsoft, you can never be sure they don't borrow security from other components in their OS or their other programs. Issues regarding the security mechanisms with MS Office should be addressed in a newsgroup that discusses that software. There is the Trust Center set of options in MS Office where you can decide on how to handle some actions. https://support.office.com/en-us/art...8-143336039bbe While you see "D:\path\file" in the dialog, I suspect your *hyperlinks* actually use the file:// or another URI protocol to point to the file. While it may seem strange, allowing links to "web" source might also mean to any URI resource, like file://. The article above provides help on MS Office 2013, 2010, and 2007. You never mentioned which version of Excel that you use. |
#5
|
|||
|
|||
Removing this redundant message?
VanguardLH wrote:
Terry Pinnell wrote: I have an Excel worksheet with several hundred hyperlinks to videos I've made. So it's tiresome to get this message every time I click one to play it: https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0 I found several web articles such as this that seemed promising but didn't work. Probably incompatible with Win 10. None of the registry hacks like that which I've tried so far have exorcised the message. https://support.microsoft.com/en-gb/...007-office-pro So I'm still looking, and have posted in the Excel forum too. It's annoying that I can't be trusted to open files I created from scratch myself! Can anyone here suggest a solution please? Just a guess but wondering if this has to do with: Internet Options - Advanced - Security section (at the bottom) "Allow active content to run in files on My Computer" With Microsoft, you can never be sure they don't borrow security from other components in their OS or their other programs. Issues regarding the security mechanisms with MS Office should be addressed in a newsgroup that discusses that software. There is the Trust Center set of options in MS Office where you can decide on how to handle some actions. https://support.office.com/en-us/art...8-143336039bbe While you see "D:\path\file" in the dialog, I suspect your *hyperlinks* actually use the file:// or another URI protocol to point to the file. While it may seem strange, allowing links to "web" source might also mean to any URI resource, like file://. The article above provides help on MS Office 2013, 2010, and 2007. You never mentioned which version of Excel that you use. dadiOH: Thanks, but couldn't get that to work with any reliability. Paul, Vanguard: Thanks both, appreciate the replies. See this illustration to remove any ambiguity: https://www.dropbox.com/s/cbvbkzti76...age-2.jpg?dl=0 No internet involvement. As mentioned, these are local files I created myself. I'd already opened a thread in the Excel forum I had tried Excel 365's Trust Centre settings. Not confident I've done it correctly but it had no effect: https://www.dropbox.com/s/tzo2f4ztnm...age-3.jpg?dl=0 Terry, East Grinstead, UK |
#6
|
|||
|
|||
Removing this redundant message?
Terry Pinnell wrote:
VanguardLH wrote: Terry Pinnell wrote: I have an Excel worksheet with several hundred hyperlinks to videos I've made. So it's tiresome to get this message every time I click one to play it: https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0 I found several web articles such as this that seemed promising but didn't work. Probably incompatible with Win 10. None of the registry hacks like that which I've tried so far have exorcised the message. https://support.microsoft.com/en-gb/...007-office-pro So I'm still looking, and have posted in the Excel forum too. It's annoying that I can't be trusted to open files I created from scratch myself! Can anyone here suggest a solution please? Just a guess but wondering if this has to do with: Internet Options - Advanced - Security section (at the bottom) "Allow active content to run in files on My Computer" With Microsoft, you can never be sure they don't borrow security from other components in their OS or their other programs. Issues regarding the security mechanisms with MS Office should be addressed in a newsgroup that discusses that software. There is the Trust Center set of options in MS Office where you can decide on how to handle some actions. https://support.office.com/en-us/art...8-143336039bbe While you see "D:\path\file" in the dialog, I suspect your *hyperlinks* actually use the file:// or another URI protocol to point to the file. While it may seem strange, allowing links to "web" source might also mean to any URI resource, like file://. The article above provides help on MS Office 2013, 2010, and 2007. You never mentioned which version of Excel that you use. dadiOH: Thanks, but couldn't get that to work with any reliability. Paul, Vanguard: Thanks both, appreciate the replies. See this illustration to remove any ambiguity: https://www.dropbox.com/s/cbvbkzti76...age-2.jpg?dl=0 No internet involvement. As mentioned, these are local files I created myself. I'd already opened a thread in the Excel forum I had tried Excel 365's Trust Centre settings. Not confident I've done it correctly but it had no effect: https://www.dropbox.com/s/tzo2f4ztnm...age-3.jpg?dl=0 Terry, East Grinstead, UK The topic is addressed here, but I don't know if you'll like the answer or not. https://support.microsoft.com/en-us/...007-office-pro The warning you're getting, is caused by the file extension indicating a file type with exploit potential. It probably isn't an Alternate Stream attached to the file that marks it as "downloaded from the Internet", and instead, is a check of whether it's a file type that has known exploits. The JPG and TIF libraries were bugged at one time, and multiple platforms and programs used the open source libraries for those, without doing a code inspection. I'm sure I've still got programs here, which are vulnerable to attacks on those "features" (program links to the older "unfixed" versions of those libraries). The MP4 is probably the same thing - some CODEC which has issues and suffers stack overflow or somesuch, and the warning is an attempt to protect you (they're warning you of the remote possibility and are not actually detecting an exploit-in-motion). You would think the Alternate Stream marker would be sufficient, as that would give the user an opportunity to mark files as "Yes, I know where this came from and... I approve". It's not clear in that article, whether their registry adjustments do enough to entirely eliminate the symptoms. So you'll have to test it. Paul |
#7
|
|||
|
|||
Removing this redundant message?
Paul wrote:
Terry Pinnell wrote: VanguardLH wrote: Terry Pinnell wrote: I have an Excel worksheet with several hundred hyperlinks to videos I've made. So it's tiresome to get this message every time I click one to play it: https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0 I found several web articles such as this that seemed promising but didn't work. Probably incompatible with Win 10. None of the registry hacks like that which I've tried so far have exorcised the message. https://support.microsoft.com/en-gb/...007-office-pro So I'm still looking, and have posted in the Excel forum too. It's annoying that I can't be trusted to open files I created from scratch myself! Can anyone here suggest a solution please? Just a guess but wondering if this has to do with: Internet Options - Advanced - Security section (at the bottom) "Allow active content to run in files on My Computer" With Microsoft, you can never be sure they don't borrow security from other components in their OS or their other programs. Issues regarding the security mechanisms with MS Office should be addressed in a newsgroup that discusses that software. There is the Trust Center set of options in MS Office where you can decide on how to handle some actions. https://support.office.com/en-us/art...8-143336039bbe While you see "D:\path\file" in the dialog, I suspect your *hyperlinks* actually use the file:// or another URI protocol to point to the file. While it may seem strange, allowing links to "web" source might also mean to any URI resource, like file://. The article above provides help on MS Office 2013, 2010, and 2007. You never mentioned which version of Excel that you use. dadiOH: Thanks, but couldn't get that to work with any reliability. Paul, Vanguard: Thanks both, appreciate the replies. See this illustration to remove any ambiguity: https://www.dropbox.com/s/cbvbkzti76...age-2.jpg?dl=0 No internet involvement. As mentioned, these are local files I created myself. I'd already opened a thread in the Excel forum I had tried Excel 365's Trust Centre settings. Not confident I've done it correctly but it had no effect: https://www.dropbox.com/s/tzo2f4ztnm...age-3.jpg?dl=0 Terry, East Grinstead, UK The topic is addressed here, but I don't know if you'll like the answer or not. https://support.microsoft.com/en-us/...007-office-pro The warning you're getting, is caused by the file extension indicating a file type with exploit potential. It probably isn't an Alternate Stream attached to the file that marks it as "downloaded from the Internet", and instead, is a check of whether it's a file type that has known exploits. The JPG and TIF libraries were bugged at one time, and multiple platforms and programs used the open source libraries for those, without doing a code inspection. I'm sure I've still got programs here, which are vulnerable to attacks on those "features" (program links to the older "unfixed" versions of those libraries). The MP4 is probably the same thing - some CODEC which has issues and suffers stack overflow or somesuch, and the warning is an attempt to protect you (they're warning you of the remote possibility and are not actually detecting an exploit-in-motion). You would think the Alternate Stream marker would be sufficient, as that would give the user an opportunity to mark files as "Yes, I know where this came from and... I approve". It's not clear in that article, whether their registry adjustments do enough to entirely eliminate the symptoms. So you'll have to test it. Paul Sorted! I wrote a simple Macro Express Pro script activated by the opening of the window 'Microsoft Office'. I'd hesitated in trying that obvious approach not only because it's crude but also because I was unduly pessimistic about its speed. In fact it takes maybe only about a quarter of a second between clicking the cell and seeing the video open. Still long enough to see the darned thing, of course, but I'll settle for that until someone fixes it properly. Terry, East Grinstead, UK |
#8
|
|||
|
|||
Removing this redundant message?
Terry Pinnell wrote:
I wrote a simple Macro Express Pro script activated by the opening of the window 'Microsoft Office'. I'd hesitated in trying that obvious approach not only because it's crude but also because I was unduly pessimistic about its speed. In fact it takes maybe only about a quarter of a second between clicking the cell and seeing the video open. Still long enough to see the darned thing, of course, but I'll settle for that until someone fixes it properly. Isn't that similar (but perhaps less coding effort) to what dadiOH already suggested? |
#9
|
|||
|
|||
Removing this redundant message?
VanguardLH wrote:
Terry Pinnell wrote: I wrote a simple Macro Express Pro script activated by the opening of the window 'Microsoft Office'. I'd hesitated in trying that obvious approach not only because it's crude but also because I was unduly pessimistic about its speed. In fact it takes maybe only about a quarter of a second between clicking the cell and seeing the video open. Still long enough to see the darned thing, of course, but I'll settle for that until someone fixes it properly. Isn't that similar (but perhaps less coding effort) to what dadiOH already suggested? Yes, but mine works ;-) Terry, East Grinstead, UK |
#10
|
|||
|
|||
Removing this redundant message?
Terry Pinnell wrote:
I have an Excel worksheet with several hundred hyperlinks to videos I've made. So it's tiresome to get this message every time I click one to play it: https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0 I found several web articles such as this that seemed promising but didn't work. Probably incompatible with Win 10. None of the registry hacks like that which I've tried so far have exorcised the message. https://support.microsoft.com/en-gb/...007-office-pro So I'm still looking, and have posted in the Excel forum too. It's annoying that I can't be trusted to open files I created from scratch myself! Can anyone here suggest a solution please? Terry, East Grinstead, UK SUMMARY of methods I've tried to remove the redundant message ================================================== =========== Suggestion #1 ------------- https://www.technipages.com/disable-...d-data-message Expand the plus sign next to HKEY_CURRENT_USER then Software then Policies then Microsoft then Office then 16.0 then Common Select the “Common” key, select “New” on the “Edit” menu, and then click “Key“. Type “Security“, and then press “Enter“ to name the key. On the “Edit” menu, point to “New“, and then select “DWORD Value“. Type “DisableHyperlinkWarning“, and then press “Enter“ to name the entry. In the right pane, right-click “DisableHyperlinkWarning“, and then select “Modify“. In the “Edit DWORD Value” dialog box, select “Decimal“, and then type “1” under “Value data“. Close Regedit and restart the computer. TRIED. Still get the redundant message. Suggestion #2 ------------- https://support.microsoft.com/en-gb/...007-office-pro Or http://www.thewindowsclub.com/disabl...arnings-office To enable or to disable the hyperlink warnings in 2007 Office programs and in Office 2010 programs when an http:// address, a notes:// address, or an ftp:// address is used, you must create a new registry subkey. To do this, follow these steps: Click Start, and then click Run. In the Open dialog box, type regedit, and then click OK. Notes You have to modify only one of these registry subkeys. You do not have to modify both. If the Security subkey already exists, go directly to step 6 after you select the Security subkey. In Registry Editor, locate one of the following registry subkeys for 2007 Office: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\C ommon Or, in Registry Editor, locate one of the following registry subkeys for Office 2010: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\C ommon Click the registry subkey, point to New on the Edit menu, and then click Key. Type Security, and then press Enter to name the key. On the Edit menu, point to New, and then click DWORD Value. Type DisableHyperlinkWarning, and then press Enter to name the entry. In the right pane, right-click DisableHyperlinkWarning, and then click Modify. In the Edit DWORD Value dialog box, click Decimal, and then type 1 or 0 under Value data. Note A value of 0 enables the hyperlink warning message. A value of 1 disables the hyperlink warning message. Click OK. TRIED (modified by adding key to 16.0 because I use Excel 365). Still get the redundant message. Suggestion #3 ------------- https://getadmx.com/?Category=Office...erlinkwarnings EXCEL Options Trust Center Trusted Locations Add new location... The files whose hyperlinks I am opening (and getting the daft message) are all in sub-folders beneath D:\Videos+Projects. I therefore added that to the 'User Locations' section. I don't understand the 'Policy Locations' section, which is currently empty. TRIED. Still get the redundant message. (I also tried enabling 'Allow Trusted Locations on my network (not recommended)' even though I don't really understand it in this context, but no change there either. Unchecked that subsequently. Terry, East Grinstead, UK |
Thread Tools | |
Display Modes | Rate This Thread |
|
|