Excel PowerQuery Instability

%3CLINGO-SUB%20id%3D%22lingo-sub-739239%22%20slang%3D%22en-US%22%3EExcel%20PowerQuery%20Instability%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-739239%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20using%20PowerQuery%20for%20a%20long%20time%20and%20one%20thing%20that%20has%20not%20changed%20is%20it's%20instability.%26nbsp%3B%20When%20I'm%20using%20two%20workbooks%2C%20which%20both%20have%20a%20PowerQuery%20they%20become%20unstable%2C%20a%20'SEND%20A%20FROWN'%20error%20comes%20up%20and%20half%20the%20time%2C%20Excel%20crashes%20(all%20open%20WorkBooks%20crash%2Fdisapear)%2C%20Excel%20comes%20back%20trying%20to%20repair%20all%20of%20them.%3C%2FP%3E%3CP%3ENo%20matter%20how%20many%20times%20they%20are%20repaired%20(including%20manually)%2C%20they%20still%20do%20it.%26nbsp%3B%20If%20I%20don't%20need%20them%20to%20interact%20with%20each%20other%2C%20I%20can%20open%20them%20up%20in%20different%20instances%20(Win%2BR%20%26gt%3B%20excel%20-x)%2C%20but%20sometimes%20I%20need%20them%20working%20together.%3C%2FP%3E%3CP%3EBelow%20is%20the%20detail%20of%20the%20error%20from%20the%20'SEND%20A%20FROWN%20error'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20going%20on%2C%20why%20is%20not%20fixed%20yet%20and%20what%20can%20I%20do%20about%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3EFeedback%20Type%3A%3CBR%20%2F%3EFrown%20(Error)%3CBR%20%2F%3E%3CBR%20%2F%3EError%20Message%3A%3CBR%20%2F%3EAttempted%20to%20read%20or%20write%20protected%20memory.%20This%20is%20often%20an%20indication%20that%20other%20memory%20is%20corrupt.%3CBR%20%2F%3E%3CBR%20%2F%3EStack%20Trace%3A%3CBR%20%2F%3EError%3A%20Attempted%20to%20read%20or%20write%20protected%20memory.%20This%20is%20often%20an%20indication%20that%20other%20memory%20is%20corrupt.%3CBR%20%2F%3Eat%20WorkbookQueriesNavigatorViewHost.prototype.showNodeContextMenu%20(ms-pq%3A%2F%2Fpq.microsoft.com%2Fts%2FTaskPane%2FWorkbookQuery%2FWorkbookQueriesNavigatorViewHost.js%3A122%3A13)%3CBR%20%2F%3Eat%20Anonymous%20function%20(ms-pq%3A%2F%2Fpq.microsoft.com%2Fts%2FShared%2FResultViews%2FNavigatorViewControl.js%3A175%3A21)%3CBR%20%2F%3Eat%20n.event.dispatch%20(ms-pq%3A%2F%2Fpq.microsoft.com%2Fopensource%2Fjquery%2Fjquery-2.1.1.js%3A3%3A6348)%3CBR%20%2F%3Eat%20r.handle%20(ms-pq%3A%2F%2Fpq.microsoft.com%2Fopensource%2Fjquery%2Fjquery-2.1.1.js%3A3%3A3114)%3CBR%20%2F%3E%3CBR%20%2F%3EStack%20Trace%20Message%3A%3CBR%20%2F%3EAttempted%20to%20read%20or%20write%20protected%20memory.%20This%20is%20often%20an%20indication%20that%20other%20memory%20is%20corrupt.%3CBR%20%2F%3E%3CBR%20%2F%3EInvocation%20Stack%20Trace%3A%3CBR%20%2F%3Eat%20Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String%20message%2C%20Exception%20exception%2C%20Nullable%601%20stackTraceInfo)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle%20activeWindow%2C%20IUIHost%20uiHost%2C%20FeedbackPackageInfo%20feedbackPackageInfo%2C%20Exception%20e%2C%20Boolean%20useGDICapture)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.%26lt%3B%26gt%3Bc__DisplayClass1.%3CHANDLEEXCEPTION%3Eb__0()%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception%20e)%3CBR%20%2F%3Eat%20System.RuntimeMethodHandle.InvokeMethod(Object%20target%2C%20Object%5B%5D%20arguments%2C%20Signature%20sig%2C%20Boolean%20constructor)%3CBR%20%2F%3Eat%20System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object%20obj%2C%20Object%5B%5D%20parameters%2C%20Object%5B%5D%20arguments)%3CBR%20%2F%3Eat%20System.Reflection.RuntimeMethodInfo.Invoke(Object%20obj%2C%20BindingFlags%20invokeAttr%2C%20Binder%20binder%2C%20Object%5B%5D%20parameters%2C%20CultureInfo%20culture)%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.UI.Shared.JsExportWrapper.%26lt%3B%26gt%3Bc__DisplayClass2.%3CINVOKEMEMBER%3Eb__0()%3CBR%20%2F%3Eat%20Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeHost(Func%601%20invokeHost)%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ESupports%20Premium%20Content%3A%3CBR%20%2F%3ETrue%3C%2FINVOKEMEMBER%3E%3C%2FHANDLEEXCEPTION%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-739239%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

I've been using PowerQuery for a long time and one thing that has not changed is it's instability.  When I'm using two workbooks, which both have a PowerQuery they become unstable, a 'SEND A FROWN' error comes up and half the time, Excel crashes (all open WorkBooks crash/disapear), Excel comes back trying to repair all of them.

No matter how many times they are repaired (including manually), they still do it.  If I don't need them to interact with each other, I can open them up in different instances (Win+R > excel -x), but sometimes I need them working together.

Below is the detail of the error from the 'SEND A FROWN error'.

 

What is going on, why is not fixed yet and what can I do about it.

 

Feedback Type:
Frown (Error)

Error Message:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Stack Trace:
Error: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at WorkbookQueriesNavigatorViewHost.prototype.showNodeContextMenu (ms-pq://pq.microsoft.com/ts/TaskPane/WorkbookQuery/WorkbookQueriesNavigatorViewHost.js:122:13)
at Anonymous function (ms-pq://pq.microsoft.com/ts/Shared/ResultViews/NavigatorViewControl.js:175:21)
at n.event.dispatch (ms-pq://pq.microsoft.com/opensource/jquery/jquery-2.1.1.js:3:6348)
at r.handle (ms-pq://pq.microsoft.com/opensource/jquery/jquery-2.1.1.js:3:3114)

Stack Trace Message:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo)
at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.Mashup.Client.UI.Shared.JsExportWrapper.<>c__DisplayClass2.<InvokeMember>b__0()
at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeHost(Func`1 invokeHost)


Supports Premium Content:
True

 

0 Replies