In Excel you can use the "Get Data" functions to display information between different spreadsheets. Can this be done in ProjectWise V8i or Connect?
I don't think think so.The Get Data tools is Microsoft and uses M$ data 'Connector's to different applications using different interface standards.There are 'Connector's for Projectwise, Assetworks etc that you can use in Excel, Power Bi, MS Forms.You can download and upload using some connectors but you need to have them configured correctly and need Bentley IMS user with correct permissions.Not that easy for a normal user.
You might find this YouTube interesting..
How to Connect Power BI with ProjectWise [Bentley Systems]https://www.youtube.com/watch?v=lhDtbBMu2bIIt is one way to access the PW file in local PW cache..but there is a connector to access files from the PW datastore directly or via the PW Web Interface.