https://www.biinsight.com/browsing-cubes-remotely-from-excel/
Browsing Cubes Remotely from Excel Trough a VPN Connection without Using Windows Authentication