1

How to avoid security certificate errors/warnings raised by excel when retrieving data using querytables

view story
linux-howto

http://superuser.com – How can I avoid security certificate errors/warnings raised by excel when retrieving data using querytables from a server that has multiple certificates (we do not wish to revert to the use of ActiveX components). Our servers are using SNI and publish several certificates. The first time a querytable is executed excel reports that the certificate does not match the server and therefore cannot be trusted. On OSX the user can opt to 'always trust' the certificate and no longer gets the warning/error. How can I do this on Windows? When I accept the certificate everything works fine until I clos (HowTos)