Excel 2016 Power Query not backwards compatible with Excel 2013? RRS feed

  • Question

  • Hi All,

    Has anyone come across this error when trying to refresh a power query connection that uses oData to connect to a Project Online PWA?

     "The connection count 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"

    The Excel file was created in 2016. The PC that is trying to use the file is 2013. There is no option to in 2016 to save the file as a 2013 file - that just doesn't exist. This problem has occurred on 2 of 2 Office 2013 PC's.


    The Project Management Group http://www.TPMGAustralia.com

    • Edited by ConradDo Tuesday, November 3, 2015 5:29 AM
    Tuesday, November 3, 2015 5:28 AM