Home

Excel 2016 Power Query crash

%3CLINGO-SUB%20id%3D%22lingo-sub-839374%22%20slang%3D%22en-US%22%3EExcel%202016%20Power%20Query%20crash%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-839374%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20an%20issue%20with%20a%20workbook%20with%20a%20number%20of%20PowerQueries%20in%20it.%20It's%20started%20failing%20every%20time%20that%20the%20last%20query%20in%20the%20chain%20runs.%20Sometimes%20it%20will%20crash%20to%20desktop%2C%20others%20it%20will%20give%20me%20the%20opportunity%20to%20%22Send%20a%20frown%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECopy%20details%20in%20that%20dialog%20always%20returns%20the%20same%20information%20which%20I've%20pasted%20below.%20I've%20not%20provided%20the%20whole%20stack%20trace%20(I've%20read%20in%20other%20posts%20that%20it's%20only%20the%20first%2010%20or%20so%20rows%20that%20are%20relevant)%20but%20please%20let%20me%20know%20if%20you%20need%20more.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CFONT%20face%3D%22courier%20new%2Ccourier%22%3EError%20Message%3A%3CBR%20%2F%3EAttempted%20to%20read%20or%20write%20protected%20memory.%20This%20is%20often%20an%20indication%20that%20other%20memory%20is%20corrupt.%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%3CFONT%20face%3D%22courier%20new%2Ccourier%22%3EStack%20Trace%3A%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.NativeExcelFunctionsMSI.Microsoft.Mashup.Client.Excel.INativeExcelFunctions.RefreshListObject(IntPtr%20workbookPointer%2C%20String%20listObjectName)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.Shim.NativeListObject.TryRefresh()%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.ConnectionManager.%26lt%3B%26gt%3Bc__DisplayClass19.%3CREFRESHFILLTARGETS%3Eb__18()%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.Shim.NativeSafeInvoker.Invoke%5BT%5D(Func%601%20func)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.ConnectionManager.RefreshFillTargets(IWorkbook%20workbook%2C%20Query%20query)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.PollingFillManager.RefreshConnection(IWorkbook%20workbook%2C%20Query%20query)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.Fill.FillManager.StartRefreshFill(IWindowHandle%20ownerWindow%2C%20IWorkbook%20workbook%2C%20Query%20query%2C%20IQueryServices%20queryServices)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.ExcelQueryServices.%26lt%3B%26gt%3Bc__DisplayClass6.%26lt%3B%26gt%3Bc__DisplayClass8.%3CSTARTREFRESHFILL%3Eb__5(IUndoScope%20scope)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.%26lt%3B%26gt%3Bc__DisplayClass2.%3CINVOKEUNDOABLEACTION%3Eb__0()%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.Mashup.Client.Excel.Shim.AddInAndNativeCoAuthServicesMSI.InvokeCoauthAction(IWorkbook%20workbook%2C%20UndoableActionType%20actionType%2C%20Action%20action)%3CBR%20%2F%3E%3C%2FINVOKEUNDOABLEACTION%3E%3C%2FSTARTREFRESHFILL%3E%3C%2FREFRESHFILLTARGETS%3E%3C%2FFONT%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERunning%20on%20Office%20Pro%20Plus%202016%20-%20Excel%20about%20dialog%20reports%20version%2016.0.4849.1000.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20much%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJM%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-839374%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Epowerquery%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-839468%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Power%20Query%20crash%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-839468%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F404183%22%20target%3D%22_blank%22%3E%40JarangMandi%3C%2FA%3E%26nbsp%3BI%20have%20same%20problem%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
JarangMandi
Occasional Visitor

Hi,

 

I've an issue with a workbook with a number of PowerQueries in it. It's started failing every time that the last query in the chain runs. Sometimes it will crash to desktop, others it will give me the opportunity to "Send a frown".

 

Copy details in that dialog always returns the same information which I've pasted below. I've not provided the whole stack trace (I've read in other posts that it's only the first 10 or so rows that are relevant) but please let me know if you need more.

 

 

Error Message:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Stack Trace:
   at Microsoft.Mashup.Client.Excel.NativeExcelFunctionsMSI.Microsoft.Mashup.Client.Excel.INativeExcelFunctions.RefreshListObject(IntPtr workbookPointer, String listObjectName)
   at Microsoft.Mashup.Client.Excel.Shim.NativeListObject.TryRefresh()
   at Microsoft.Mashup.Client.Excel.ConnectionManager.<>c__DisplayClass19.<RefreshFillTargets>b__18()
   at Microsoft.Mashup.Client.Excel.Shim.NativeSafeInvoker.Invoke[T](Func`1 func)
   at Microsoft.Mashup.Client.Excel.ConnectionManager.RefreshFillTargets(IWorkbook workbook, Query query)
   at Microsoft.Mashup.Client.Excel.PollingFillManager.RefreshConnection(IWorkbook workbook, Query query)
   at Microsoft.Mashup.Client.Excel.Fill.FillManager.StartRefreshFill(IWindowHandle ownerWindow, IWorkbook workbook, Query query, IQueryServices queryServices)
   at Microsoft.Mashup.Client.Excel.ExcelQueryServices.<>c__DisplayClass6.<>c__DisplayClass8.<StartRefreshFill>b__5(IUndoScope scope)
   at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.<>c__DisplayClass2.<InvokeUndoableAction>b__0()
   at Microsoft.Mashup.Client.Excel.Shim.AddInAndNativeCoAuthServicesMSI.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action)

 

Running on Office Pro Plus 2016 - Excel about dialog reports version 16.0.4849.1000.

 

Any help much appreciated.

 

JM

1 Reply

@JarangMandi I have same problem

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies