power query "Attempted to read or write protected memory" RRS feed

  • Question

  • Hi

    Does anyone else get this message when opening multiple spreadsheets containing Power Query.  Only happens when two or more sheets are open.  The excel books also contain some vba code to refresh lists and queries.  Reading forums I am not sure how to diagnose the issue or whether this is likely to be a VBA or a PQ issue.

    The same workbooks used to run fine on Windows 7, Excel 2013 64 bit.  The error shows in Windows 10 Excel 2016 64bit.  Office 365 desktop.
    When this happens it is usually necessary to kill Excel through the task manager

    Any guidance would be helpful.


    • Edited by PQUK Wednesday, March 7, 2018 9:14 PM
    Wednesday, March 7, 2018 11:30 AM