Home

Excel 2010 and 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-503646%22%20slang%3D%22en-US%22%3EExcel%202010%20and%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-503646%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20am%20using%20Microsoft%20excel%202010.%26nbsp%3BI%20am%20making%20a%20document%20using%20supplement%20PowerQuery%20for%20Excel%202010.%20When%20I%20open%20this%20a%20document%20from%20Excel%202016%2C%20i%20see%20a%20mistake%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20connection%20could%20not%20be%20refreshed.%20This%20problem%20could%20occur%20if%20the%20connection%20was%20copied%20from%20another%20workbook%20or%20the%20workbook%20was%20created%20in%20a%20newer%20version%20of%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat's%20the%20matter%3F%20How%20to%20fix%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-503646%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-504549%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202010%20and%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-504549%22%20slang%3D%22en-US%22%3EI%20think%20the%20powerquery%20version%20you%20are%20using%20for%20Excel%202010%20is%20newer%20than%20the%20one%20currently%20in%20your%20Excel%202016%20installation.%20Open%20the%20PowerQuery%20query%20editor%2C%20click%20%22File%22%2C%20%22Options%20and%20Settings%22%2C%20then%20click%20%22Query%20options%22%2C%20%22Diagnostics%22%20tab%20to%20find%20the%20version%20number%20of%20PQ.%3C%2FLINGO-BODY%3E
Margisha
Occasional Visitor

I am using Microsoft excel 2010. I am making a document using supplement PowerQuery for Excel 2010. When I open this a document from Excel 2016, i see a mistake:

The connection could not be refreshed. This problem could occur if the connection was copied from another workbook or the workbook was created in a newer version of Excel.

 

What's the matter? How to fix?

1 Reply
I think the powerquery version you are using for Excel 2010 is newer than the one currently in your Excel 2016 installation. Open the PowerQuery query editor, click "File", "Options and Settings", then click "Query options", "Diagnostics" tab to find the version number of PQ.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
11 Replies