Forum Discussion
Power Query from external data pulling into Excel not updating
Hello, I have an Excel Power Pivot that was already created. I have refreshed the query to pull in FY24 data. The query updates, but the FY24 data does not pull in. Can you please assist me?
It is located in a shared drive in my organizations network file folder.
Can you go through this if it could help
https://support.microsoft.com/en-gb/office/refresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440#:~:text=In%20the%20Workbook%20Queries%20pane,Home%20%3E%20Query%20%3E%20Refresh%20preview.
Hi. I performed those steps, but with no success. I did find a coworker to help me and we resolved the issue. Thank you for your help!
Can you provide your fix? I am having the exact same issues affecting almost 100 users
- I went into Advanced Editor to write in an additional step.