Pivot Table sorting is not working. Name are sorting like month names.
I have a pivot table with Names and Data for each name. I select the LastName column as the first Row in the pivot table. Excel sorts the name March to the top of the list thinking it is a data with the month of March. I have made sure there are no hidden characters, turned off custom sort lists. Nothing works. This is a serios issue because if I need data for Mr March and scroll down to where it should be, I would conclude ther is no data for him. This should work as expected and not have to try some work around like i was an IT expert. Nothing has worked even applying the knowledge I have about programming. Any ideas?
copy paste issue in excel 2016
Dear Microsoft Team, We have been experiencing a copy-paste issue in Microsoft Excel since 14 October 2026, following the installation of Windows Security Update KB5127648 and Microsoft Excel 2016 Security Update KB5002934. The issue is specific to Sheet1 in the affected Excel workbook. The observed behavior is as follows: Copying any cell from Sheet2 and pasting it into Sheet1 works correctly. Copying any cell from Sheet1 and pasting it into another sheet or even within the same sheet does not work. No action is performed, and no error message is displayed. Copying content from Sheet1 and pasting it into Notepad works correctly. Copying text or content from Notepad and pasting it into Sheet1 also works correctly. Based on these observations, the issue appears to be specific to copying cells from Sheet1 rather than a general clipboard malfunction. Kindly investigate this issue and advise on a permanent resolution, as it started after the installation of the aforementioned security updates.copy paste issue in excel 2016
Dear Team, the copy paste issue comming since yesterday 14 oct 2016 after updating security update kb5127648 and security update for microsoft excel 2016 kb5002934, if i copy any cell from sheet2 and paste it on sheet1 it work well but if copy any cell from sheet1 and paste on the other sheet or on the same sheet is not performing while it paste normaly in notepad file, also copy anything from notepad and paste in the sheet1 is work well
Excel date formatting issue automatically changing date value to month
I am having one issue such that changing my date field as month field! I have used format cell option and used custom format M/DD/YYYY and entered 01/08/2018. but that is changing to 08/01/2018! Please find the screenshot attached. Could you please help me to resolve the issue. Because of which I'm not able to create forecast.
Excel x64/VBE execute AV: live segment-heap entry is PAGE_READWRITE (Windows 26H2)
Please assess this case with the Excel/VBA runtime and Windows heap teams and identify a supported serviced build or mitigation. The failure is intermittent; we are not claiming a confirmed Microsoft product defect or a specific permission-change mechanism. Environment - Windows 11 26H2, build 26300.9550; ntdll.dll 10.0.26100.9549. - Microsoft 365 Click-to-Run, Current Channel, Excel x64 16.0.20430.20146. - VBE7.DLL 7.01.1158, SHA256 8AD9E8D123B4FD84DE6DF7FC931D69A556540B38317DFCEF3B4CF7A5535D48E8. - Microsoft signatures of Excel, VBE7 and ntdll validated locally. - Kaspersky 21.27 com_antivirus.dll and product_info.dll were loaded. Their involvement is unknown; antivirus/AMSI and Windows mitigations were not disabled. - No Excel-specific heap override or AppCompat Layers override was found in the inspected locations. Excel IFEO contains MitigationOptions=256; this was not modified. Captured failure on 13 October 2026, 13:05 CEST A normally launched, separate Excel instance opened a read-only copy of a macro-enabled binary workbook. Startup and its initial data refresh completed, followed by four CalculateFullRebuild calls with EnableEvents=False, True, True, False. Each returned xlDone and ScreenUpdating=True. A first external COM helper released its references and exited. After approximately 65 seconds idle, a fresh external COM helper invoked a public Boolean status getter using Application.Run. The getter body only returns a module-level Boolean variable. CDB caught first-chance C0000005 before execution of that VBA getter body: - Exception parameter 0: 8 (execute); target 0x00000260bb2b947c. - !address: MEM_COMMIT, MEM_PRIVATE, PAGE_READWRITE (0x04), not executable. - !heap -x: live LFH Allocated block in segment heap 0x0000026091000000. - Block address 0x00000260bb2b8d70; requested size 4144; block size 4352; unused 208. - Entry bytes contain movq xmm5,r12, a load referring to VBE7!g_PPExSP, and a jump to VBE7!ProcCallEngine. - Call chain includes oleaut32!DispCallFuncAmd64, DispCallFunc, VBE7!DispCallFuncWrap, EpiInvokeMethod, CDispVbaStdMod::Invoke, EXCEL!HrGuardedDispatchInvoke, HrBookCallMacro and _HrGlobalRun. After allowing normal exception handling, Excel started its recovery process and the failing process exited with code 0. The COM caller received DISP_E_EXCEPTION (0x80020009). Thus exit code 0 and absence of a Windows crash dialog were not evidence of a healthy session. An earlier capture on the same machine showed an execute AV at another generated VBA entry during SheetCalculate dispatch. Users also reported black worksheet regions before unexpected Excel exit. We have not established that all rendering symptoms share this native cause. What has and has not been established The workbook source has no VirtualProtect/VirtualAlloc or heap-allocation calls. The runtime fault at a simple status getter is not explained by a long VBA loop or ScreenUpdating=False. The actor and moment that produced PAGE_READWRITE have not been captured. A subsequent monitored repetition, watching 18 initially executable VBA entry pages and then 22 pages after recalculation, completed without the AV or an observed matching protection-change call. Monitoring included selected overlapping NtAllocateVirtualMemoryEx/NtAllocateVirtualMemory/NtProtectVirtualMemory calls. This negative run does not retract the captured failure. A separate synthetic blank-workbook event/ordinary data-allocation test also did not reproduce this execute AV; we do not have a reliable minimal reproducer. Requested guidance 1. Is this generated VBA entry in a live 4144-byte segment-heap allocation, currently PAGE_READWRITE, consistent with a known serviced issue? 2. Which supported Office or Windows build, if any, addresses this precise failure class? 3. Which targeted next trace or supported mitigation should be used, preserving DEP/ASLR/AMSI and normal workbook functionality? 4. If further evidence is needed, please specify the minimum sanitized trace and a private support route. Full dumps and workbooks have been retained locally only. This report contains no workbook data, account identifiers, local user paths, credentials or full dump attachments. Any request for those files requires a separate decision by the owner. Related unconfirmed first-hand report under a different Windows version: https://techcommunity.microsoft.com/discussions/excelgeneral/excel-x64vbe-event-entry-loses-execute-permission-in-the-default-segment-heap/4563077 . I have not traced the same permission-changing call in my own process.
Problems network folders linked in excel after migrating to sharepoint (Excel,Sharepoint,PowerPivot)
I'm using Excel, Sharepoint, and PowerPivot with Office365 After migration to Sharepoint I need to redirect links in Excel that refer to other Excels contained in a previously network folder now in Sharepoint. But I cannot locate the sharepoint connector in my excel, as it seems I should as specified in Microsoft documentation. (See images) Any idea why it's not working for me or how it should be done? Best Regards.
Excel Nested Arrays: Find the Nesting Depth of Uniform and Ragged Arrays ARRDEPTH() & ISRAGGED()
Hey everyone! I’ve been diving deep into Excel’s new nested arrays features lately, and I absolutely love the flexibility they bring to data structuring. However, managing them can get a bit tricky, so I figured I’d build some specialized tools to handle them seamlessly. Public Interfaces & Arguments =ISRAGGED(array) Argument Description Default Behavior array Target nested structure to validate. Required =ARRDEPTH(array, [is_ragged]) Argument Description Default Behavior array Target nested structure to measure. Required [is_ragged] TRUE: Scans all branches for the deepest path. FALSE: Speed test on the first path only. FALSE (Omitted) TL;DR (What makes it tick): Function Name Type What It Does ARRDEPTH Public UI Returns nesting depth. Supports deep checking or fast linear testing. ISRAGGED Public UI Structural validator. Returns TRUE if array branches have uneven nesting. ANALYZE_NESTING Hidden Core Engine Multi-process recursive parser that tracks tree structure geometries. LINEARDEPTH Hidden Utility High-speed depth checker that evaluates the first element path exclusively. You can get both functions from my GitHub Gist: https://gist.github.com/Medohh2120/9cdf939036942c9672c57ccd6de696d3
#ref error using If and Vlookup
I'm trying to use this formula with the IF and Vlookup =IF(H13>=@'[Job Status.xlsx]Sheet1'!$A$2:$A$1048576, VLOOKUP(H13,'[Job Status.xlsx]Sheet1'!$A$2:$A$1048576,2,),"") The idea is, if I put in the job number in H13 and it looks up the job in the other sheet that has all the jobs listed, it will return the name of the job and the location of the job. I've used this formula to connect other sheets to this 'job status' workbook and it works fine. I don't understand why it is not working here. If I remove the @ symbol from the beginning of the formula, it makes it a #spill! error. In my other workbooks where this formula works, I didn't have to put the @ sign in. Thank You.
