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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies