Excel 2016 Power Query crash
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. JMfixed date
Hello, I have this problem: I need when I write something in cell B1 then G1 gives me the date(date of writing). I've tried this formula in G1: =IF(B1<>"";NOW();"") but it doesn't work because whenever I open the file next day it gives me the date for that next day, not the date when I wrote something in cell B1 I hope it's clear thank you in advance
