1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

PowerQuery Opens Files on Refresh

I've been using PowerQuery for a couple years now and have never experienced this issue.

For context, this query wasn't complex to begin with. It loads one tab from 20-30 documents found within a folder on a shared drive. No transformations to the raw data, other than promoting headers. Even recreated the document from scratch while troubleshooting.

Whenever I go to Refresh in the document, it begins opening reports from the folder at random. Doesn't appear to follow a pattern, just randomly. Not all of them, just whichever ones it feels like opening.

It does eventually refresh but takes forever and I have to close out of 10-15 reports while it does. It will also begin opening documents while I'm editing in PowerQuery and prompt that I cannot close the window while in PowerQuery.

Is this a new bug during an update? I've never experienced this before.

submitted by /u/AloofBidoof
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#PowerQuery
#Refresh
#documents
#shared drive
#tab
#reports
#raw data
#promoting headers
#troubleshooting
#folder