XL Connect Questions


I have a couple of questions regarding XL Connect (I think we are on version 5)

Can you find out what a calculation is doing / looking at for example: E10GLMTDNET where exactly does this get its information from?

Are there any issues running XL Connect with Office 365 (we have been told we should only use Excel 2013 with our version)

Does anyone use XL Connect over a VPN?

If anyone knows or can point me in the direction where find this out that will be great.