get & transform
1 Topic
Teams and Power Query Excel file
Hi, I have an Excel file that I am sharing from within a Team. The file is created from within the current version of Excel ProPlus and is shared with someone else who also has ProPlus but just this one person. The file has 50 Get & Transform queries in it. If the file is opened in the ProPlus desktop version of Excel from within Teams my computer locks up, so much that the only option is the power button to restart it. My laptop is running the 32bit version of Office ProPlus, has a Xeon processor and 32Gb of Ram. I hope to have the 64bit version installed when our IT department get round to it just to see if that makes any difference to running the queries whilst shared.. If I save the file somewhere else and open it then the file runs ok, it's just when it's shared via Teams. Is this what I should expect? I have shared a similar file that instead of using PowerQuery it uses VBA code to basically do the same thing. With that file we can both open the shared file and run the VBA code at the same time without any issues whatsoever. I wondered whether other people have managed to successfully use Power Query files whilst they're shared. The queries will normally run on any PC and when stored in the cloud without an issue, I'm just not sure on whether the sharing is causing an issue.Solved26KViews0likes6Comments