SOLVED
Home

Teams and Power Query Excel file

%3CLINGO-SUB%20id%3D%22lingo-sub-749580%22%20slang%3D%22en-US%22%3ETeams%20and%20Power%20Query%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749580%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20an%20Excel%20file%20that%20I%20am%20sharing%20from%20within%20a%20Team.%20The%20file%20is%20created%20from%20within%20the%20current%20version%20of%20Excel%20ProPlus%20and%20is%20shared%20with%20someone%20else%20who%20also%20has%20ProPlus%20but%20just%20this%20one%20person.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20file%20has%2050%20Get%20%26amp%3B%20Transform%20queries%20in%20it.%20If%20the%20file%20is%20opened%20in%20the%20ProPlus%20desktop%20version%20of%20Excel%20from%20%3CSTRONG%3Ewithin%3C%2FSTRONG%3ETeams%20my%20computer%20locks%20up%2C%20so%20much%20that%20the%20only%20option%20is%20the%20power%20button%20to%20restart%20it.%20My%20laptop%20is%20running%20the%2032bit%20version%20of%20Office%20ProPlus%2C%20has%20a%20Xeon%20processor%20and%2032Gb%20of%20Ram.%20I%20hope%20to%20have%20the%2064bit%20version%20installed%20when%20our%20IT%20department%20get%20round%20to%20it%20just%20to%20see%20if%20that%20makes%20any%20difference%20to%20running%20the%20queries%20whilst%20shared..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20save%20the%20file%20somewhere%20else%20and%20open%20it%20then%20the%20file%20runs%20ok%2C%20it's%20just%20when%20it's%20shared%20via%20Teams.%20Is%20this%20what%20I%20should%20expect%3F%20I%20have%20shared%20a%20similar%20file%20that%20instead%20of%20using%20PowerQuery%20it%20uses%20VBA%20code%20to%20basically%20do%20the%20same%20thing.%20With%20that%20file%20we%20can%20both%20open%20the%20shared%20file%20and%20run%20the%20VBA%20code%20at%20the%20same%20time%20without%20any%20issues%20whatsoever.%20I%20wondered%20whether%20other%20people%20have%20managed%20to%20successfully%20use%20Power%20Query%20files%20whilst%20they're%20shared.%20The%20queries%20will%20normally%20run%20on%20any%20PC%20and%20when%20stored%20in%20the%20cloud%20without%20an%20issue%2C%20I'm%20just%20not%20sure%20on%20whether%20the%20sharing%20is%20causing%20an%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-749580%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EGet%20%26amp%3B%20Transform%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharing%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-749610%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20and%20Power%20Query%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749610%22%20slang%3D%22en-US%22%3EWorkaround%20is%20to%20use%20a%20sharepoint%20link%20to%20share%20the%20file!%20It%20won%E2%80%99t%20be%20opened%20in%20Teams%20then%20but%20rather%20in%20excel%20online!%20You%20can%20then%20open%20it%20in%20the%20desktop%20app%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-750002%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20and%20Power%20Query%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750002%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply%2C%20I%20opened%20it%20in%20SharePoint%20from%20the%20link%20in%20the%20Teams'%20Files%20menu%20'Open%20in%20SharePoint'.%20I%20will%20try%20loading%20it%20into%20a%20full%20SharePoint%20site%20and%20running%20it%20from%20there%20to%20see%20if%20that's%20what%20you%20meant.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seemed%20to%20be%20working%20fine%20but%20again%20the%20computer%20started%20acting%20like%20it%20was%20an%20old%20386SX.%20I%20used%20the%20Windows%20Task%20Manager%20to%20close%20Excel%20and%20there%20were%202%20Mashup%20processes%20running%20that%20didn't%20close%20with%20Excel.%20It%20was%20only%20when%20I%20force-closed%20those%20that%20the%20laptop%20was%20responsive%20again.%20It%20may%20be%20a%2032bit%20Office%20issue%20as%20the%20Excel%20app%20was%20using%20960kb%20and%20the%202%20Mashups%20had%20about%20250kb%20each.%20Will%20try%20the%20full%20SharePoint%20first...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-750017%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20and%20Power%20Query%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750017%22%20slang%3D%22en-US%22%3EDo%20you%20have%20any%20issues%20with%20other%20files%3F%3CBR%20%2F%3EIt%20seems%20somethings%20wrong%20with%20that%20one%20%3A%5C%3C%2Fimg%3E%3CBR%20%2F%3ETried%20creating%20a%20new%20file%20and%20copying%20over%20the%20data%20and%20formulas%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-750155%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20and%20Power%20Query%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750155%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20file%20works%20perfectly%20whilst%20stored%20in%20OneDrive...%3CSTRONG%3Eand%3C%2FSTRONG%3E%3CSTRONG%3Ealso%3C%2FSTRONG%3Eif%20I%20upload%20directly%20into%20a%20full%20SharePoint%20site.%20But%20not%20from%20within%20a%20Teams%20site%20at%20all.%20That's%20strange%20but%20may%20point%20to%20something%20that's%20not%20set-up%20correctly%20in%20our%20Teams%20config%20maybe.%20I%20will%20post%20in%20our%20company%20Yammer%20and%20see%20if%20someone%20else%20here%20can%20try%20a%20similar%20experiment.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-750211%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20and%20Power%20Query%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750211%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20file%20works%20perfectly%20whilst%20stored%20in%20OneDrive...andalsoif%20I%20upload%20directly%20into%20a%20full%20SharePoint%20site.%20But%20not%20from%20within%20a%20Teams%20site%20at%20all.%20That's%20strange%20but%20may%20point%20to%20something%20that's%20not%20set-up%20correctly%20in%20our%20Teams%20config%20maybe.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-750214%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20and%20Power%20Query%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750214%22%20slang%3D%22en-US%22%3ENa%2C%20nothing%20about%20Teams%20config!%20Something%20in%20there%20that%20Teams%20don%E2%80%99t%20like%3C%2FLINGO-BODY%3E
Highlighted
Mark_Adams
New Contributor

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.

6 Replies
Solution
Workaround is to use a sharepoint link to share the file! It won’t be opened in Teams then but rather in excel online! You can then open it in the desktop app

@adam deltinger 

 

Thanks for your reply, I opened it in SharePoint from the link in the Teams' Files menu 'Open in SharePoint'. I will try loading it into a full SharePoint site and running it from there to see if that's what you meant.

 

It seemed to be working fine but again the computer started acting like it was an old 386SX. I used the Windows Task Manager to close Excel and there were 2 Mashup processes running that didn't close with Excel. It was only when I force-closed those that the laptop was responsive again. It may be a 32bit Office issue as the Excel app was using 960kb and the 2 Mashups had about 250kb each. Will try the full SharePoint first...

Do you have any issues with other files?
It seems somethings wrong with that one :\
Tried creating a new file and copying over the data and formulas?

@adam deltinger 

 

That file works perfectly whilst stored in OneDrive...and also if I upload directly into a full SharePoint site. But not from within a Teams site at all. That's strange but may point to something that's not set-up correctly in our Teams config maybe. I will post in our company Yammer and see if someone else here can try a similar experiment. 

@adam deltinger 

 

That file works perfectly whilst stored in OneDrive...and also if I upload directly into a full SharePoint site. But not from within a Teams site at all. That's strange but may point to something that's not set-up correctly in our Teams config maybe. 

Na, nothing about Teams config! Something in there that Teams don’t like