I received the "Do you want to open this file?" message when I tried to open files on a mapped network drive (N for me). I went to Internet options' Security tab and clicked on Local intranet.

If when you click to open your Favorites links, the File Download Security Warning box opens unnecessarily in Windows, see this fix.