Recent Discussions
Excel says two numbers are not equal
Column A are numbers typed into the cells. Column B, the numbers in B1 to B3 are also typed in. Cell B4 is SUM(b1:b3) C4 is =B4=A4 Can someone please explain why excel is saying the two numbers in A4 & B4 are not equal. I understand about using rounding or truncation with large calculations but I've never seen anything like this on such a simple calculation. I've tried this on a new spreadsheet and the results are the same. I am using Excel Version 16.109 (26033013) on a Mac. Thank you for your help.
Help with Excel pop out window
I found a free spreadsheet online that I wanted to use. I am able to manipulated it for my use case. But the original creator added these call out fields that I cannot seem to find out how to delete or change the syntax. I can't even find out what they are called. Any suggestions?? In the attachment, I select a filed and a little yellow box pops up. How do I change or delete these??Edge Browser Control stealing Focus
I am facing an issue with the Microsoft Access Edge (WebView2) browser control in VBA Office 365. I have two forms displayed side by side: The first form contains a grid/list of records. The second form contains an Edge browser control that loads an HTML file. When a record is selected (or navigated using arrow keys) in the grid, I dynamically delete and recreate an HTML file with details of the selected record, and then call the Edge browser control’s Navigate method to load that file. The problem is: Arrow key navigation works correctly in the grid when the Edge browser control is not used. Once I add the Edge browser Navigate call, the browser control takes focus. After that, arrow key navigation in the grid stops working because focus shifts to the browser. Attempts to manually set focus back to the grid (SetFocus, timers, etc.) are not reliable. Tried this in documentcomplete event also, but not working. The issue seems to be related to the asynchronous behavior of the Edge browser control, which keeps reclaiming focus. What is the best way to reliably prevent or reclaim focus from the Edge browser control so that keyboard navigation in the grid continues to work smoothly?PowerPoint NEW Image Editing Tools Explained — Remove Background, Upscale & Edit Images Instantly!
🚀 PowerPoint just received one of its most powerful updates ever! Microsoft has introduced a brand‑new built‑in image editing experience, allowing you to enhance visuals without leaving PowerPoint. In my latest YouTube video, I walk through all the new capabilities now rolling out in Microsoft 365, including: ✨ Remove background 🧽 Erase unwanted objects 🔄 Move elements inside an image 🔍 Upscale low‑resolution pictures ⚡ Auto‑enhance lighting & contrast 📝 Add or edit text directly on images All of this happens directly inside PowerPoint, making slide creation faster and more intuitive than ever. These features are now available on: 💻 Windows 🍎 Mac 🌐 PowerPoint for the Web If you work with presentations daily, this update is a real productivity boost. 📹 Watch the full breakdown and demo here ➡️ https://youtu.be/OZzfFi2qpAk Let me know what feature you find the most useful! 👇 #Microsoft365 #PowerPoint #Productivity #AI #Presentations #Microsoft365Insider #Creators
Excel Macros Spreadsheets Not Loading
I've spent some time with Microsoft Support (almost 3 hours, including uninstalling my MS 365 and reinstalling it), but I'm having an issue with my Excel Macro spreadsheets not loading at all. This is what I get each time. Also having an issue with non-Macro spreadsheets that I'm unable to use the Bold, Italic, and Underline functions (get the spinning wheel and then Excel Not Responding), as well as not able to use the Format function (get the same spinning wheel and then Excel Not Responding). I've been using these same Excel Macro Spreadsheets for over 15 years. Please help!
Word VBA, Unreachable table style setting?
I've noticed something that may be a missing feature in the Word VBA Object model. Styles in word can be of different kinds set by the WdStyleType when adding a style via expression.Add (Name, Type) method of the Styles Object (https://learn.microsoft.com/en-us/office/vba/api/word.styles.add). Using wdStyleTypeTable gives a Table Style. Table styles differ somewhat from other styles since you build up the style of a table by setting the formatting for different parts/features of the table. E.g. the first, or last row may differ in their style compared to the rest of the table. These kind of settings are reached via the Condition method of the TableStyle object (reachable from the Style.Table property). Specifying different "conditions" (of data type WdConditionCode) give you access to ConditionalStyle objects handling the settings for different parts of the table. In word you can modify the table styles by for example <right-clicking> a table style and selecting "Modify Table Style" This presents you with the following UI. The setting I am unable to reach via VBA is tied to the Condition "First Row" which can be reached by selecting the pull-down menu "Apply formatting to:" to Header Row, then clicking the button menu "Format" at the lower left and selecting "Table Properties...". This gives us the "Table Properties" UI in which we in the tab "Row" is given the options to enable "Repeat as header row at the top of each page". The effect of this can be seen in the "Description field" in the previous "Modify Style (Table Edition)" view. (You might have to select something else in "!Apply formatting to:" menu and then re-select "Header row" again to get the description field to update). We now have a "Repeat as header row" shown in the description for "Header rows". This is a setting which in VBA can be reached for an inserted Table via a Rows property: table.rows.HeadingFormat https://learn.microsoft.com/en-us/office/vba/api/word.row.headingformat However, it should be possible to set for the table style as well. In the resulting XML file (styles.xml) of the .docx file we find it in a <w:trPr> block as a <w:tblHeader/> tag. Note that this is the definition of a style in the styles.xml, not the declaration of an inserted table. Have anyone managed to reach this style setting via VBA or know of how it can be done? I've scanned through the methods and properties of Style, TableStyle, and ConditionalStyle object definitions and not found anything allowing me to set this "Table property" as part of the style. It would make most sense if it was available in the TableStyle object (https://learn.microsoft.com/en-us/office/vba/api/word.tablestyle) since that is where properties such as "AllowBreakAcrossPage" can be found. Maybe something they missed in the Word VBA model.
Printing/exporting messes up the document
I have a 67-page document with a lot of pictures too, and I use multilevel headings. When I try to print or export to .pdf, it messes up the whole document, I have now 102 pages, sometimes 92, the approx. 5000 word count is now 7000, and the order of the headings is messed up, so some parts of the document are moved across the document. What on Earth is this? I changed all the fonts to Arial. Tried every kind of printing setting. Nothing works.Excel repair strips all formulas from large .xlsm after March 2026 security update (KB5002849)
Hi everyone, I'm a master's student at Karolinska Institutet in Stockholm. My thesis is a health economic cost-effectiveness model built entirely in Excel — a gender-neutral static Markov cohort model with 34 worksheets. The file has become completely unusable after what I believe is the March 2026 security update, and I'm running out of options. The file: - .xlsm, ~46.5 MB compressed, ~370 MB uncompressed XML - 34 worksheets, four of which are 73–92 MB each (Markov trace sheets) - ~65,000 formulas, ~33,500 shared formulas - Heavy use of LET, LAMBDA, XLOOKUP, XMATCH, CHOOSECOLS, TAKE, MAP, SWITCH - 771 defined names including ~147 hidden _xlpm.* LET/LAMBDA variable placeholders - Stored on OneDrive via KI SharePoint, 34,000+ AutoSave revisions - Contains VBA (vbaProject.bin) The problem: Every time I open the file — on Excel for Mac or Excel Online — the repair engine triggers and strips ALL formulas from every sheet, replacing them with cached values. The file shrinks from ~46.5 MB to ~26 MB. Clicking "No" on the repair dialog just closes the file. There is no way to bypass the repair. What I've verified: - Extracted the .xlsm as a ZIP and confirmed all formulas (<f> tags) are fully intact in the raw XML - Libr€Office Calc can read the formulas but cannot execute them (Err:508 — no LET/LAMBDA support) - Removed 158 broken named ranges (#REF! and #NAME? entries) from workbook.xml and rebuilt the archive — repair engine still strips all formulas - The issue reproduces on every OneDrive version history copy (up until I largely used LET formulas in my sheets - but there is still 1,5months of changes lost) - The issue reproduces on both Excel for Mac and Excel Online Suspected cause: The March 10, 2026 security update (KB5002849) patched CVE-2026-26108, a heap overflow in Excel's file parsing during loading. The same patch was applied to Office Online Server (KB5002846). I believe the tightened parsing now rejects or flags my file's large XML structures as potentially malicious, triggering the repair engine to strip all formulas. This is consistent with: - The known _xlfn. namespace bug on Excel for Mac (reported by multiple users on Microsoft Q&A since late 2024) - The timing - the file was working before this update flawlessly up until March 16th - The fact that Excel Online is also affected (same server-side patch) My questions to the community: 1. Has anyone else experienced formula stripping on large workbooks after the March 2026 update? 2. Is there a way to bypass the repair engine on Mac, or roll back the specific security patch without downgrading all of Office? 3. Would opening this file on Windows Excel (pre-patch or current) preserve the formulas? If anyone with a Windows PC would be willing to try opening and re-saving this file, I would be incredibly grateful. 4. Is there now effectively a size/complexity ceiling for Excel workbooks that makes models like this unviable? If so - should I be migrating this to another environment (R, Python, etc.) going forward? This file represents six months of thesis work. The formulas are all there in the XML. I just need Excel to stop destroying them on open. Any help, pointers, or similar experiences would be hugely appreciated. Thank you, Florian Boschek
Look up two parts of a string in a cell
Hello All, I know all about the XLOOKUP() but at times I need a special type of a look up. if I have a cell with the text “Apples and Oranges” how can I write an XLOOKUP to evaluate the “Apples” and then evaluate the “Oranges” parts. for example if I have a list of fruits in a column, then in the next column I have true if the fruit has seeds and false if the fruit does not have seeds. now normally the XLOOKUP will look for the whole string, so if there is no fruit called “Apples and Oranges” it will fail and not return anything. But I do have “Apples” in one cell and it has true for having seeds, AND I do have “Oranges” and it has false for seeds (these are Naval oranges 🤪) so the XLOOKUP will not return false. how can I write an XLOOKUP to return “Apples”, “Oranges”, AND “Apples and Oranges”? I thought of replacing the part after the And but then I’ll lose the fine parts, then I tried splitting the string on “AND” and that did not work at all. I guess you can’t run an XLOOKUP on an array part??? any help will be greatly appreciated!
Losing borders in transition from Excel 97 to 2024 Pro Plus
I have a handy appointments calendar (.xls) that has used Excel 97 on a Windows 7 laptop for a long time. I want to run this on my latest laptop that has Excel 2024 Pro Plus on Windows 11. When I open this now, many of the cell borders, most of which are involved with conditional formatting, are either present when they should be absent or absent when they should be present. The calendar is useless as opened. I have worked to reformat the cells, but it has taken me hours to get from January to April and some aspects are still problematic, albeit acceptable. The conditional formatting process is very different between the two versions. Is there some trick to getting newer versions of Excel to properly recognize formatting from older versions? I created this calendar in Excel 97 very easily many years ago. I am not sure I could duplicate it, even from scratch, using Excel 2024.VBA concern: support for macros or controls not installed
Background: installed Zotero, a citation manager, to use on Word but it uses macros My Word doesn't seem to have VBA installed. Every time I open the app, error boxes appear. Screenshotted below: I have tried a few things to fix this but without benefit: Macros enabled in the trust centre VBA enabled in the trust centre Rapid and online repair completed I have attempted to 'change' the program in the Control Panel in order to access the 'expand/add features' option but this does not exist as an option for me. When I press 'change' only repair options appear for me. Screenshotted below: My impression is that somehow VBA was not installed when I downloaded Office form my account. I appreciate VBA is downloaded automatically but this has not been the case for me. Please advise on next steps. Thanks in advance.There seems to be a bug in the WORD Index.
Hello, I'm writing a document with an index. There are several Latin based names that require symbols, most notably a small e with an acute accent. The problem name is "Vélez." It will not index correctly putting a separate line for each entry. In troubleshooting the problem, I find that if I replace the symbol "é" with "e," it works okay. Interestingly, the name "Frémont" works okay too. Any ideas?
List Styles & Style Sets
Does anyone know if it is possible to include a list style within a style set? I know to add the styles I want to include in a style set into the style gallery, then save the style set under the design tab. However, even though the styles in my style set are linked to list styles for the numbering, those list styles do not get transferred to a document I add the style set to. I really need the list styles to also transfer to the document I'm adding the style set to. Of course, list styles do not show up in the styles pane or the style gallery (or at least I cannot determine how to get them to). Thoughts?
Office 365 no internet error
Outlook just stopped working yesterday. I have been using 356 for a couple of years now. One drive and Outlook both say I don't have internet access. Obviously I do. I can use one drive and outlook via a web browser, but not the desktop apps. I have tried most of the suggested fixes and nothing has worked. Anyone else having issues?Multi-line Text Box misleading text and cursor display
Starting with 365 Version 2603 on 4K monitor, in a multi-line text box, typing multiple words followed by line feeds (Enter key) then moving cursor back up to previous line causes trailing characters to disappear, entering characters at the end of the line shows the new character with the cursor in front of it, and other bizarre behavior. Selecting all the text shows it is all there but trailing characters at the end of a line can disappear depending on cursor position. If I change the monitor resolution to 2K, the issue goes away. If I rollback to version 2602 the issue goes away. This is an issue with version 2603 on 4K monitors. We have many customers reporting the same issue.How to Track Changes in Microsoft 365 Groups
An old PowerShell script tracked changes to Office 365 Groups. The techniques from 2016 wouldn’t be used today because features like the unified audit log didn’t exist then. We show what’s possible now by creating a new version of a Microsoft 365 Groups Change Report script to track additions, deletions, and changes for Microsoft 365 groups in a tenant. https://office365itpros.com/2026/04/06/microsoft-365-groups-change-report/
Events
in 6 hours
REGISTER HERE
As content continues to grow, organizations need better ways to manage inactive data without sacrificing security, compliance, or discoverability.
Join us for an overview of how M...
Online
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- You can now work with Copilot as a co-creator directly in your Word document on your iPhoneApr 06, 2026
- Comment threads are easier to find, read, and act on with the new Comments pane experience.Apr 06, 2026
