Share via

Power query in excel 2021 refresh is not working

Magsumbol, Lee Michelle (Citco) 0 Reputation points
2024-03-12T10:29:16.8566667+00:00

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.
4,364 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,694 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,988 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 23,906 Reputation points Microsoft Vendor
    2024-03-13T06:27:53.7333333+00:00

    Hi,

    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.