Excel 2010 and 2016

Copper Contributor

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.