Power Query error when executing a formula

Hello everyone,

We get this error when executing a formula in Excel

Feedback Type:
Frown (Error)

Error Message:
Container unexpectedly exited. Exit code: 0xC000026F. PID: 23028

Stack Trace:
   at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

Stack Trace Message:
Container unexpectedly exited. Exit code: 0xC000026F. PID: 23028

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, String messageDetail)
   at Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)
   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__DisplayClass14_0.<HandleException>b__0()
   at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   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.Delegate.DynamicInvokeImpl(Object[] args)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
   at Microsoft.Mashup.Client.UI.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle)
   at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
   at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
   at Microsoft.Mashup.Client.Excel.QueriesEditorWindow.ShowModal(ILegacyUIHost uiHost, FormulaHistoryManager formulaHistoryManager, ApplicationTracingHost applicationTracingHost, ExcelServices excelServices, ConnectionManager connectionManager, DialogManager dialogManager, IFillManager fillManager, LoadQueryManager loadQueryManager, PackageManager packageManager, IFileDialogManager fileDialogManager, IInteractiveMsalProvider msalProvider, ITelemetryService telemetryService, IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, IOfficeRegistryAccessor officeRegistryAccessor)
   at Microsoft.Mashup.Client.Excel.UI.LegacyMashupClientUIServices.ShowQueriesEditorWindow(WindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, QueryServices queryServices, Queries queries, QueryDefinition queryDefinition)
   at Microsoft.Office.PowerQuery.Adapter.MixedMashupClientUIServices.ShowQueriesEditorWindow(WindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, QueryServices queryServices, Queries queries, QueryDefinition queryDefinition)
   at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, IUndoScope undoScope, QueryDefinition queryDefinition)
   at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.<>c__DisplayClass15_0.<ShowModalQueriesEditorWindow>b__1(IUndoScope undoScope)
   at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action)
   at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action)
   at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook workbook, UndoableActionType actionType, Action`1 action)
   at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)
   at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, QueryDefinition queryDefinition)
   at Microsoft.Mashup.Client.Excel.UI.LegacyMashupClientUIServices.AddExcelNamedObject(WindowHandle ownerWindow, IWorkbook workbook, WorkbookPackage workbookPackage, String newQueryName, String formulaText)
   at Microsoft.Office.PowerQuery.Adapter.MixedMashupClientUIServices.AddExcelNamedObject(WindowHandle ownerWindow, IWorkbook workbook, WorkbookPackage workbookPackage, String newQueryName, String formulaText)
   at Microsoft.Mashup.Client.Excel.DialogManager.AddExcelNamedObject(IWindowHandle ownerWindow, IWorkbook workbook, String namedObjectName, String newQueryName)
   at Microsoft.Mashup.Client.Excel.NativeExcelConnectorC2RBase.<>c__DisplayClass68_0.<CreateCurrentWorkbookQuery>b__0()
   at Microsoft.Mashup.Client.Excel.Native.NativeExcelCallbackInvoker.InvokeAndReturnHResult(Action action)
   at Microsoft.Mashup.Client.Excel.NativeExcelConnectorC2RBase.CreateCurrentWorkbookQuery(IntPtr uiFrame, IntPtr workbookPointer, MarshalledNamedObjectIdentifier namedObjectIdentifier)


Supports Premium Content:
True

Formulas:


section Section1;

shared TestTbl = let
    Source = Excel.CurrentWorkbook(){[Name="TestTbl"]}[Content]
in
    Source;

Works for his colleagues, its just him that gets the error. Fully updated Windows 11 Pro. User has M365 apps for Enterprise and Business Premium license - why both I don't know. I have a feeling this could be due to a new Office365 update since last week, it was working for him.

We have tried

- Creating a new local Windows profile.
- Repairing/reinstalling Office365.
- Clearing Power Query cache.
- Repairing/reinstalling .NET 4.0 & VCRedists
- excel /safe — same error.

Any help would be appreciated.