Power query in excel 2021 refresh is not working

Magsumbol, Lee Michelle (Citco) 0 Reputation points

Power query in excel 2021 refresh is not working but same file in Office 2016 is working fine

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,704 questions
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,431 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,061 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 21,391 Reputation points Microsoft Vendor


    Did you use the same bit version of Office?

    I suggest you check if you're using the same 32/64bit version of Office 2021 as Office 2016.

    What kind of data source did you use to create the connection in Power Query?

    If possible, you can also try to re-create the connection in Office 2021.

    Which method of verification did you use to create the connection?

    Did you get any error messages about refreshing?

    Please be a bit more precise to explain your problem or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.