Yes, I set up the Trusted Location from within Excel Options. The correct folder path is shown and I have included subfolders (though there aren't any). I still get the warning message...
Are the files local to your PC?
How are you inserting the hyperlink?
I was able to duplicate the warning when the location was not "trusted". When the location was added to the trusted locations, I was able to insert the hyperlink without any warning. I even clicked on the cell and it played the wav file.
Soooooooooooo. You're missing something. :)
OK, will look again (and post back of course). Thanks!
(Yes, local files on the PC. I inserted the hyperlink by right clicking the cell, choosing 'hyperlink' and browsing to the file).
Last edited by martinlest; 26 Oct 2013 at 15:45.
Hopeless! I go into Excel, Click the Office button in the top left-hand corner, choose Excel Options, go to the Trust Center and then Trust Center Settings and Trusted Locations. See screenshot. The path is correct.
The warning comes up every time. I can't see what I am missing - will have to give up at some stage (before the frustration gets to me!).
Martin
In the same Excel document by the way, I can open some hyperlinks and not others: links to .xlsx, .bmp, .jpg or .docx files (for example) open fine. But those to .wav, .wmv or .mp3, for instance, do not. I need to disable the warning on the basis of file type I guess? I would, if I knew how.. I'll search a bit longer.
What is the E drive? Is the folder shared? I think there's some restriction on "trusted locations". I could be wrong (working from memory) but a trusted location can't be on a NAS drive or in a shared folder since by definition, these are not secure.
Yes, it is a shared folder. But why would I be able to open certain file types and not others (from the same folder)? I'll try adding a hyperlink for a .wmv file in a folder that is not shared in any case and see what happens.
Hello
I work in an office using multiple computers with the same OS. We use an Access database with SQL backend to open files on a shared drive.
I currently have a similar problem with xml files triggering the “Some files can contain viruses or otherwise …”
Recently we had a huge problem with this popup and found that it seemed to have been caused by someone associating all file types with VLC media player. This caused huge problems but I have slowly rectified these.
With multimedia files I found that only by associating the extension with the latest version of Windows Media Player 11 did this resolve it. I did this by editing the HKEY_CLASSES_ROOT/ext DEFAULT key with windows media player11 e.g. WMP11.AssocFile.MP3
I also found that with non multimedia files the Default value could be set to txtfile and this would resolve the issue.
I have now found the problem occurring on xml files being opened with Access on one machine only.
Can anyone make any suggestions to resolve this issue please?
Thanks
p.s.The reason I am posting in this thread is that this issue is so specific.
Quote