I have been using = Excel.CurrentWorkbook() to load all the tables in a workbook as the source for a query since I saw Mynda Treacy's post/instructions at
https://www.myonlinetraininghub.com/power-query-consolidate-excel-sheets
and it has been working just great.
I recently went to check that all the tabs I wanted were being picked up,but when I look at the query source I get a catastrpoohic error which is very long so I will paste it in full at the end of this message. Strangely though, to me, the query still seems to work.
I now rely on this, so I am rather desperate to find a solution.
Excel 365 beta v2103 build 13819.20006
Henry
Here is the error message in full:
Unexpected error: Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))
Details:
Microsoft.Mashup.Client.Excel.Shim.NativeExcelException: Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) ---> System.Runtime.InteropServices.COMException: Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))
--- End of inner exception stack trace ---
Server stack trace:
at Microsoft.Mashup.Client.Excel.Interop.NativeExcelInteropUtils.ValidateResult(Int32 result, Int32[] expectedValues)
at Microsoft.Mashup.Client.Excel.NativeExcelFunctionsC2RBase.Microsoft.Mashup.Client.Excel.INativeExcelFunctions.TryGetNamedObjectProperties(IntPtr workbookPointer, String name, NamedObjectProperties& namedObjectProperties)
at Microsoft.Mashup.Client.Excel.ExcelHost.<>c__DisplayClass6_0.b__0()
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3_0`1.b__0()
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_1.b__0(Object null)
Exception rethrown at [0]:
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.Mashup.Host.Document.ExceptionExtensions.CaptureAndRethrow(Exception e)
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback)
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions[T](SynchronizationContext context, Func`1 callback)
at Microsoft.Mashup.Client.Excel.ExcelHost.TryGetTable(PackageReference packageReference, String tableName, Int32 skip, Int32 take, Byte[]& content, Boolean& columnNamesGenerated, String& errorMessage)
at Microsoft.Mashup.Host.Document.Evaluation.ExcelService.TryGetTable(String name, Int32 skip, Int32 count, IDataReader& dataReader, Boolean& columnNamesGenerated, String& errorMessage)
at Microsoft.Mashup.Host.Document.Evaluation.Services.RemoteExcelServiceFactory.Stub.OnTableRequest(IMessageChannel channel, TableRequestMessage request)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)
Hi Henry,
As you're on the beta channel you should send a frown and let the Excel team look into it. Be sure to share a screenshot as these frowns get priority even if there's nothing to see in the screenshot. And of course, include your email address so they can get in contact with you.
Mynda
Thank you Mynda, I have done that and also included the full error message.
And thank you also for the lesson in the first place, as well as all the others that you post online. Always GREAT stuff 
And it's LAMBDA day!
My pleasure, Henry! Let me know if you don't hear back from Microsoft. Give them a week.
Hi Mynda
I don't know why it didn't occur to me before, but I tried looking at a copy of the file on my laptop last night; and no problem! It was a slightly older beta so I updated it to the latest and the same as on my desktop, and still no problem.
Ok, repair or reinstall ahead, but I had a final look on my desktop just now, and ALL IS WELL. And it's not like it was an intermittent problem, its been driving me crazy for a week. Hopefully, now all is well it will stay that way.Thanks for taking the time and effort to try to help though.
BTW, I do like your Lambda video, one of the, if not the, easiest to follow I have seen, although I still need to look at it a few more times. I'm a bit concerned that its use will make understanding (another person's) spreadsheets even more difficult that it can be at present.
Henry
Yes, I agree that LAMBDAs could get out of control in the wrong hands!
