Power Query/G&T freezes PC when Excel file is shared via MS Teams RRS feed

  • Question

  • Hi we have an E3 O365 tenant at work and I am currently using the 32bit Excel ProPlus, version 16.0.10730.20264.

    I have a file with 50 queries that works fine when saved locally. When I share it via a MS Team the file is unusable as it locks up my laptop completely. I have a Dell Precision 5520 laptop with 32Gb ram and Xeon E3-1505M v5 processor on Windows 7 so not a slow machine. I have a request in at work to change to the 64bit version of Office ProPlus but still waiting for that to happen. Does this look like a memory issue, with the 32bit Excel restriction, or is it that the queries will just not run well with a shared file? We don't use PowerBI as the company has opted for Tableau instead so can't use that.

    Wednesday, July 10, 2019 11:27 AM