Can't edit cells in Excel 2010 since Sept 2026 patch Tuesday
I can't edit cells in Excel 2010 spreadsheets since Sept 2026 patch Tuesday. How do I reverse this back to the former working software. There was one comment that said it might be caused by a Windows 10 security update. Since Windows 10 isn't supposed to get security updates anymore, how can that be an issue? Ron
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/9cdf939036942c9672c57ccd6de696d3After seven years of being helped and even offering some help to others ...
... I think AI has effectively put this site out of business. So although I'll check in a few more times over the next month or so, and will definitely miss the virtual friends (real people) I've met, with whom I've exchanged messages...but other than that, it's a sad farewell. Thanks for the memories.
Add-in not working in EXCEL 2024 HOME SUBSCRIPTION.
I have office home 2024 subscription. Recently, when I try to add an add-in from the add-in tab in excel it shows error. It was working fine. I had python and some other add-ins through the add-in menu. Can somebody help? I have tried all methods suggested by AI tools.
What's the simplest way to make a genuinely random name selection system using Microsoft tools?
For example, suppose I have a list of participants in Excel and want to randomly select one winner without manually choosing from the list. Would you use RAND/RANDBETWEEN in Excel, Power Automate, or another Microsoft 365 approach? I'm also interested in preventing the same person from being selected twice when several winners are needed. I'd appreciate an approach that's easy for someone without much Excel or Power Automate experience to understand.
VBE The XLSM file can't save macros
Two computers: On my personal computer, the VBE module shows 'no open projects,' most of the buttons are greyed out, and if I try to click any non-greyed button, it gives an 'error in loading DLL.' On my work computer, the issue is: after creating a new XLSX document and saving it as an XLSM file, it opens fine; however, once I insert a Macro, it shows that the file is corrupted, and repairing it deletes my macro. I’ve tried reinstalling, adding trusted folders, modifying the registry, and rolling back to version 2607, but nothing worked. The personal computer is set to the US region and I downloaded the English version of 365, while the work computer is set to CN and I downloaded the Simplified Chinese version of 365. Also, the USER folder on my personal computer was moved to the D drive. I contacted Microsoft support, and the staff suggested I post in this community .I'm looking for a practical way to calculate Pakistan salary income tax in Excel.
The goal would be to enter a monthly salary and have the spreadsheet estimate the applicable tax and resulting take-home amount. Ideally, the calculation should be easy to update when the applicable tax slabs or salary-related rules change. For someone building this in Excel, would you recommend keeping the tax slabs in a separate lookup table and using formulas against that table, rather than hard-coding the rates into one large formula? I'm particularly interested in approaches that make the spreadsheet easier to maintain when tax rules change.Referenced cells do not identify themselves with color
For some reason when I create a formula that references other cells, I cannot get those cells to "identify" themselves with a specific color. For example, in the image below the formula references cells B7, B8, B6, etc but they are just black text and don't show up in color per standard excel documents. Usually they "glow" with a specific color so you can find them easily in big spreadsheets. How do I get the colors back?
