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
Highlighted
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
Highlighted

@JarangMandi I have same problem

Related Conversations
Round Down to the nearest 5
jshea23 in Excel on
0 Replies
help with formulae
Gavc1 in Excel on
1 Replies
print macro for variable print area
tomb999 in Excel on
0 Replies
Mailing worksheets in excel
Bruno1250 in Excel on
4 Replies
Ribbon or right clicking will not go further out
51218 in Excel on
0 Replies
How to automate a timesheet template?
fishfish31 in Excel on
1 Replies