Unexpected Error - Attempted to read or write protected memory. This is often an indication that other memory is corrupt. RRS feed

  • Question

  • Hello,

      I continue to get this message when using a VBA script to pull in new data from power query in Excel. It happens in the same workbooks on both a windows 10 and windows 7 machine - both running O365 version 1708 (Build 8431.2250). But only seems to happen in some workbooks, and not others - even thought the functional steps taken are basically the same in all workbooks. Anyone have any thoughts on this? I'd love to provide more info, but not even sure where to start...



    Wednesday, May 16, 2018 6:11 PM


  • Hi Joe,

    I am wondering if you can share the  problematic workbook or the VBA script with us. Just make sure you are not sharing any sensitive data with us - please make sure to scramble or remove it before sharing the workbook.


    Guy Hunkin - Excel Team

    Sunday, May 27, 2018 5:14 PM