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

Have you encountered some users who can't refresh Power Query?

I’m running into a Power Query refresh issue in Excel that I haven’t been able to resolve through Googling.

We have an Excel file with Power Query connections that a team uses to refresh and pull updated data. The file is stored in a shared Google Drive folder, and both teams involved have the same access permissions.

Here’s the issue:

  • One team is able to refresh the queries without any problems.
  • Another team receives errors when trying to refresh, with error messages that the source file cannot be found or that columns are missing.

Additional context:

  • We are all using Microsoft 365.
  • Permissions appear to be identical across both teams.
  • I am able to refresh the file successfully without errors, so are other people within my team, so obviously not a source file issue.
  • I’ve created other Power Query–based Excel files in the same shared folder, and the affected team can refresh those without any issues.
  • The problem seems isolated to this specific file.

Has anyone encountered this issue before? Has anyone resolved this issue before?
My last ditch effort would be to just recreate the whole thing and see if that fixes it.

Here's the error message if you're interested. It doesn't help: https://i.imgur.com/Gss7SHt.png

submitted by /u/TheRiteGuy
[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
#Excel compatibility
#Excel alternatives
#rows.com
#financial modeling with spreadsheets
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#google sheets
#cloud-based spreadsheet applications
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Power Query
#Excel
#refresh issue