"Repeat header row" is set, but not repeating I'm creating Microsoft Word templates for accessibility. I have tables that are set to repeat the header row on each page, with breaking across rows disabled. The setting is complete, but the header row on page 2 (and beyond) are not displaying. These were new templates created from scratch this year from a new document. They are not copied and pasted from older documents. Any guidance would be appreciated. lbry Copper Contributor Aug 31, 2026 Place Word Word 93 Views 0 likes 5 Comments "Repeat header row" is set, but not repeating Excel Desktop Filter Checkboxes Not Visible – Windows 11 / Office Home & Student 2021 Excel Desktop Filter Checkboxes Not Visible – Windows 11 / Office Home & Student 2021 I am facing a persistent display/rendering issue in the Excel desktop application when using filters. When I apply a filter to a column, the filter dropdown opens correctly and the values are displayed. The filter functionality itself also works. However, the checkboxes beside the individual values are not visible properly. As shown in the attached screenshot, the values such as 11, 12, 22, and 34 are displayed in the filter list, but the checkbox controls beside them are either missing/not rendered correctly. Interestingly, the Select All checkbox area also appears abnormal. System details Operating System: Windows 11 Microsoft Office: Home & Student 2021 Application: Microsoft Excel Desktop Office is fully updated with the latest available updates. The same Excel file works correctly in Excel for the Web, where all filter checkboxes are displayed normally. Troubleshooting already performed by Microsoft Support Microsoft Support has already remotely checked the system and tried several troubleshooting steps, including: Reinstalling Microsoft Office Creating/modifying relevant Windows Registry entries Creating system restore/checkpoints during troubleshooting Creating and testing with a new Windows user profile Checking and installing all available Office updates Unfortunately, the issue still persists. Since the problem does not occur in Excel for the Web, it appears to be specific to the Excel desktop application's UI/rendering on my Windows 11 system. Has anyone experienced a similar issue with filter dropdown checkboxes not rendering or appearing invisible in Excel Desktop? Could this be related to: Excel hardware graphics acceleration/rendering Windows display scaling or DPI settings GPU/display drivers Office 2021 UI rendering Windows 11 accessibility/display settings A known Excel Desktop bug Any suggestions, known fixes, or confirmation of a similar issue would be appreciated. Screenshot attached for reference. komatiramakanth Copper Contributor Aug 31, 2026 Place Excel Excel admin community excel office 365 124 Views 0 likes 2 Comments Excel Desktop Filter Checkboxes Not Visible – Windows 11 / Office Home & Student 2021 Advanced Filter Hello. I created a filter that has 2 conditions. 1. If the Ref Cert or the SK Cert is YES, bit should appear. The problem is that if the columns with Ref Exp or SK Exp is blank, then it gives me a 0 or if it does have a date, then it gives me the number equivalent. The original table, it does have dates. I tried to format the columns so it would give me an actual date, but it doesn't work. It only works for the blank cells. This is the actual formula. =FILTER(C3:N500,((H3:H500)="YES")+((J3:J500)="YES"))&IF(ISBLANK(I3),"",I3) Array is C3 : N500 (This is the table where is information is coming from) Ref Cert is H3 : H500 SK Cert is J3 : J500 This is what the finish product looks like. BaltaD Tin Contributor Aug 31, 2026 Place Excel Excel Formulas and Functions 112 Views 0 likes 3 Comments Advanced Filter Infinite Sign-In Redirect Loop on Power BI Hi Community, I am stuck in an infinite sign-in redirect loop while trying to log into Power BI (app.powerbi.com). It repeatedly redirects between the login page and authentication screen without loading the dashboard. Steps I have tried so far: Cleared browser cache and cookies. Tried accessing via Incognito / Private mode. Checked third-party cookie settings. Could you please guide on how to resolve this authentication redirect issue or if there is any tenant-level setting blocking access? Thanks! IBAD_IMRAN Copper Contributor Aug 31, 2026 Place Excel Excel community 103 Views 0 likes 2 Comments Infinite Sign-In Redirect Loop on Power BI Running a Regular Check for New Graph Permissions Use PowerShell to Check for New Graph Permissions with a View to Updating Permissions Used by Apps. After Microsoft released some new Graph permissions, thoughts turned to how to discover new permissions after they are released. Code is the best way to perform automatic checks, and this article explains how to use PowerShell to check a last known set (stored in SharePoint Online) against the current set. Any variations are reported to administrators via email. https://office365itpros.com/2026/08/31/new-graph-permissions-check/ TonyRedmond MVP Aug 31, 2026 Place Microsoft 365 Microsoft 365 Azure AD Microsoft Graph 6 Views 0 likes 0 Comments Running a Regular Check for New Graph Permissions Little blue circles These little solid blue circles with me initials in white keep popping up at random in my spreadsheets. How do I get rid of them? GeoffDavis Copper Contributor Aug 30, 2026 Place Excel Excel excel 64 Views 0 likes 2 Comments Little blue circles How to properly redact a PDF? I need to share a PDF that contains names, email addresses, and other confidential details that must be removed first. Simply placing black boxes over the text does not seem secure, since the original content may still be searchable, selectable, or recoverable, so I need a way to permanently redact a PDF. Because the document contains sensitive information, I would prefer not to upload it to an online tool. I’m looking for either a built-in option or professional third-party desktop software that can permanently redact both text and images while processing the file locally. It would also be useful to remove hidden information from a PDF before sharing, including comments, document metadata, and any other embedded details. What is the safest way to handle this, and how can I verify that a PDF is properly redacted before I send it? Michelle_Scott77 Brass Contributor Aug 30, 2026 Place Microsoft 365 Microsoft 365 compliance security 63 Views 0 likes 2 Comments How to properly redact a PDF? When #VALUE! isn’t an error: The hidden reference behavior of Excel’s dynamic arrays 1. Mechanism Overview Functions such as TAKE, DROP, OFFSET, and INDIRECT normally produce a range when supplied with scalar parameters. When instead a 1-D or 2-D numeric array is passed to one of these parameters, Excel attempts to generate multiple range outputs (one per array element). Since Excel’s grid architecture does not allow a single function call to return multiple ranges in parallel, the function fails. The visible result is an array filled with #VALUE!. Example patterns: =TAKE(range, {1;2;3;4}) =DROP(range, {1;2;3;4}) =OFFSET(range, {1;2;3;4}, {1,2,3}) =INDIRECT("A1:B"&{1;2;3;4}) Excel returns: { #VALUE!; #VALUE!; #VALUE!; #VALUE! } Although the values appear identical, each #VALUE! is associated with a distinct internal range reference corresponding to the attempted slice, offset or address. This is a side effect of Excel’s reference-binding layer, which attaches metadata to #VALUE! propagation structures when a reference-producing function fails after partially resolving its operands. 2. Behavior Characterization 2.1 Reference Retention Each #VALUE! error produced by the above functions contains a deferred reference representing the range the function attempted to construct. The reference is not materialized because: a multi-range return is not allowed, and the evaluation is aborted at the final conversion stage. However, the binding phase (operand resolution) has already created a reference object. This object is preserved internally and passed forward along the calculation chain. 2.2 Deferred Evaluation Functions that inspect operand values (e.g., SUM, MIN, COUNT) cannot extract data from these encapsulated #VALUE! tokens and will propagate the error. Functions that inspect operand references — such as MAP, SCAN, REDUCE, MAKEARRAY, and aggregation functions that re-evaluate their inputs individually — trigger evaluation at the point of consumption. Example: =MAP( TAKE(range, {1;2;3;4}), SUM ) In each MAP iteration: ref is a #VALUE! carrying an unresolved range reference. SUM(ref) requests value-level evaluation of that range. The reference is resolved at that moment only. The resulting scalar is passed downstream. Thus, the #VALUE! error acts as a strict thunk. 3. Functional Implications for Formula Construction 3.1 Range-Object Semantics The technique enables modeling of ranges as first-class reference structures, not arrays of extracted values. This allows: passing range slices through pipelines keeping intermediate objects lightweight avoiding large intermediate spillage reducing recalculation costs for multi-slice operations 3.2 Lazy Slice Evaluation Using {n1; n2; …} arrays in index parameters creates a vector of deferred slices. Functions downstream resolve these slices on demand and only for the specific iteration that needs them. This is especially useful for: sliding-window logic multi-pass transformations tree/graph-like iterative algorithms in Excel dynamic partitioning of ranges recursive constructions implemented with SCAN/REDUCE fredson_alves Copper Contributor Aug 30, 2026 Place Excel Excel excel Formulas and Functions office 365 155 Views 2 likes 2 Comments When #VALUE! isn’t an error: The hidden reference behavior of Excel’s dynamic arrays Changing the font for envelope printing I'm using Office Professional Plus 2019. Word prints envelopes in a tiny light font that's almost impossible to read. There's an "Options" button on the dialog box for printing an envelope. When I clicked it, Word opened a dialog that had "Font..." buttons for the delivery address and return address. I clicked the "Delivery" button, and Word opened a "Font" dialog. I changed the font, then clicked the "Set as Default" button and "OK." Then I did the same for the return address. Then I printed an envelope, and Word used the same tiny light font as before. When I opened the "Font" dialogs again, they showed the original settings. What am I doing wrong... or what is Word doing wrong, and how can I fix it? The procedure seems pretty simply an not prone to misunderstanding, but it isn't dong what I think it should. DevoutSkeptic Copper Contributor Aug 30, 2026 Place Word Word 69 Views 0 likes 2 Comments Changing the font for envelope printing Excel puzzle - can't type into cell, exhausted support steps, need a tech wizard ! Excel desktop app on Mac won't let me edit cells (Word is fine) already tried a full uninstall/reinstall with support MacBook Air, macOS Tahoma 26.2 - Microsoft 365 Premium subscription - Excel for Mac, Version 16.111.1 Problem: In the Excel desktop app I can navigate the sheet and select/highlight cells, but I cannot type into a cell or into the formula bar Already tried with a Microsoft support agent: 1. Confirmed subscription is active 2. Removed the Office license from Keychain Access 3. Fully removed the Office apps, emptied the Trash. 4. Reinstalled Office from account.microsoft.com 5. Result: Excel still won't let me type in a cell or in the formula bar, even in a new book 6. "Allow editing directly in cells" enabled. 8. Confirmed the keyboard itself is fine: Cmd+C works inside Excel, types normally in TextEdit 9. Opened Excel in safe mode (held Shift while launching) and creating a new blank workbook — issue persisted. Microsoft support agent confirmed this isn't a subscription/activation issue and isn't a general keyboard/OS issue, since Word, TextEdit, and Excel's own search box all accept input normally — the problem is specifically isolated to typing into a cell or the formula bar in Excel. Any ideas on what else could be blocking keyboard input specifically in Excel's grid/formula bar (e.g. a stuck editing mode, add-in, or accessibility permission specific to Excel) would be ! VERY ! appreciated. LeeVGreenwood777 Copper Contributor Aug 28, 2026 Place Excel Excel Excel on Mac office 365 130 Views 0 likes 1 Comment Excel puzzle - can't type into cell, exhausted support steps, need a tech wizard ! Does a LET variable get computed even if it's only referenced inside IFNA's fallback argument? In the formula below, expensiveMatch is defined in LET but only referenced as IFNA's fallback argument: =LET( matchRow, XMATCH(1, (A1=Sheet2!$A$1:$A$1000)*(B1=Sheet2!$B$1:$B$1000)), x, INDEX(Sheet2!$C$1:$C$1000, matchRow), expensiveMatch, INDEX(Sheet3!$C$1:$C$500, XMATCH(A1&B1, Sheet3!$A$1:$A$500&Sheet3!$B$1:$B$500)), IFNA(x, expensiveMatch) ) Question: When x resolves successfully (no #N/A), does expensiveMatch still get computed because it's a top-level LET variable - or does Excel skip it since IFNA's fallback argument is never reached? I know IFNA short-circuits its fallback argument, and LET avoids recomputing a variable if referenced multiple times - but I haven't found much documentation on the behavior of Let. Is the below a more efficient way to write the formula? =LET( matchRow, XMATCH(1, (A1=Sheet2!$A$1:$A$1000)*(B1=Sheet2!$B$1:$B$1000)), x, INDEX(Sheet2!$C$1:$C$1000, matchRow), IF(ISNA(x), INDEX(Sheet3!$C$1:$C$500, XMATCH(A1&B1, Sheet3!$A$1:$A$500&Sheet3!$B$1:$B$500)), x ) ) Is this restructuring necessary, or does the first version already skip the unused computation? Basically I'm wondering if Let computes lazily/defers calculation in the way SQL's optimizer works. Input from anyone with insight or knowledge into the calc engine would be greatly appreciated. Thanks (Currently on Microsoft Excel for Microsoft 365 MSO (Version 2607 Build 16.0.20228.20190) 64-bit) PFoleyPEP Copper Contributor Aug 28, 2026 Place Excel Excel excel Formulas and Functions office 365 297 Views 0 likes 7 Comments Does a LET variable get computed even if it's only referenced inside IFNA's fallback argument?

AutoSave disabled when opening SharePoint-synced files from Finder after macOS Tahoe 26.6 update Files stored in SharePoint Online and synchronized locally through OneDrive are opened as local documents when launched from Finder. Office applications display "Saved to my Mac" and AutoSave is turned off by default. However, opening the exact same files through Word/Excel > Open > Sites, or via SharePoint "Open in Desktop App", correctly identifies them as cloud documents. In that scenario, AutoSave is enabled and collaboration/version history features work as expected. Troubleshooting already performed: OneDrive reset and re-linked SharePoint library re-synced Signed out and back into both Office and OneDrive Removed Microsoft credentials from macOS Keychain and re-authenticated Recreated local OneDrive sync relationships Verified OneDrive File Provider extensions are enabled Verified Office applications and OneDrive are fully up to date Tested with newly created files and existing files Tested "Always Keep on This Device" with no change in behavior The issue appears to be specific to the Finder-to-Office launch path after upgrading to macOS Tahoe 26.6. Before upgrading to macOS Tahoe 26.6, opening the same SharePoint-synchronized files directly from Finder correctly preserved cloud document identity and AutoSave was enabled as expected. I discussed this issue in detail with Apple Support, but they quickly dismissed it, saying that the problem is not on Apple's side and that I should contact Microsoft instead. koklucinar Tin Contributor Aug 28, 2026 Place Microsoft 365 Microsoft 365 excel mac microsoft 365 microsoft 365 apps microsoft 365 apps for enterprise 896 Views 6 likes 10 Comments AutoSave disabled when opening SharePoint-synced files from Finder after macOS Tahoe 26.6 update Error 0x426-0x0 from KB5094126 — 3 months unresolved — ACCC & Fair Trading complaints filed I am a Microsoft 365 Business subscriber experiencing persistent error 0x426-0x0 since June 2026 following Windows Update KB5094126 which broke OLE Automation functionality — confirmed by Microsoft's own release health documentation. Despite the following attempts to resolve this: More than 6 support calls under Case Reference 2605140030001387 Escalation to Executive Customer Relations Manager Swetha Singh Escalation to VP Lisa Sinacola and CEO Satya Nadella ACCC complaint filed — Reference REF4769926 Queensland Office of Fair Trading complaint filed — CRN 203225877721512 Microsoft has refused to permanently fix the issue, refused to apply Business subscription compensation of $129.60, and suggested I purchase additional paid support to fix a bug caused entirely by their own Windows Update. Every single morning I require 15 minutes of manual Quick Repair just to open software I pay for monthly. This has been ongoing for 3 months. Is anyone else experiencing this issue? Has anyone found a permanent fix that survives Windows updates? BiopacQLD4220 Copper Contributor Aug 28, 2026 Place Deployment & Networking Deployment & Networking kb5094126 office 365 window11 72 Views 0 likes 1 Comment Error 0x426-0x0 from KB5094126 — 3 months unresolved — ACCC & Fair Trading complaints filed Help me solve this Excel Power Query editor issue I've been facing this issue in the power query editor. Kindly help me in this. I've already done an online repair but it didn't solve the issue. man77 Copper Contributor Aug 28, 2026 Place Excel Excel admin excel office 365 140 Views 0 likes 3 Comments Help me solve this Excel Power Query editor issue OneDrive files opened from Finder not recognized as cloud files on Mac Office for Mac: OneDrive files opened from Finder no longer recognized as cloud files – AutoSave disabled Hi everyone, I am experiencing a persistent issue with Microsoft 365 for Mac and OneDrive that started suddenly around August 10, 2026. The same setup and workflow had worked without problems for more than two years before that. Problem My Office files are stored in OneDrive and synchronized to my Mac via the standard macOS File Provider. When I open an Excel or Word file by double-clicking it in Finder, the Office application opens the file, but it apparently does not recognize it correctly as a OneDrive/cloud file. For example: AutoSave is disabled real-time co-authoring does not work as expected when I try to enable AutoSave manually, Office behaves as if the file were local and asks me to upload/save it to OneDrive – even though the file is already stored and synchronized in OneDrive However, if I open the exact same file from within Excel or Word via the OneDrive/Online Locations option, everything works correctly: AutoSave is enabled immediately co-authoring works changes made by another user appear in real time This behavior is reproducible with multiple files and affects both Excel and Word, so it does not appear to be an issue with one particular workbook or application. Environment MacBook Air M2 current macOS version current Microsoft 365 version current OneDrive version OneDrive Personal files synchronized through the standard macOS File Provider I have also tested opening files directly from: ~/Library/CloudStorage/OneDrive/... The result is the same: when opened from Finder, Office does not appear to recognize the file correctly as a cloud file and AutoSave remains disabled. Troubleshooting already performed I have already: completely reset and reconfigured OneDrive allowed OneDrive to fully resynchronize verified the files and folders in OneDrive on the web confirmed that OneDrive reports everything as synchronized restarted Finder and macOS removed and recreated Finder shortcuts/favorites tested without Finder favorites or aliases tested directly from ~/Library/CloudStorage/OneDrive updated macOS updated all Microsoft 365 applications updated OneDrive None of these steps changed the behavior. Key diagnostic result The following comparison is consistently reproducible: Finder → OneDrive file → double-click → Excel/Word → AutoSave OFF → file appears not to be recognized as an active OneDrive cloud document → co-authoring does not work correctly Excel/Word → Open → OneDrive/Online Locations → same file → AutoSave ON immediately → cloud functionality works → co-authoring works correctly This suggests that OneDrive synchronization itself is functioning correctly. The issue seems specifically related to the handoff between macOS Finder / Apple File Provider / OneDrive and Microsoft 365 for Mac when a OneDrive file is opened from Finder. Important detail This is not a workflow that has never worked on macOS. For more than two years, we routinely opened our synchronized OneDrive Word and Excel files directly from Finder. Office recognized them as cloud files, AutoSave was available, and collaborative editing worked normally. The behavior changed suddenly around August 10, 2026, without us intentionally changing the OneDrive folder structure or our workflow. Question Has anyone else encountered this recently? In particular: Is this a known regression in Microsoft 365 for Mac, OneDrive for Mac, or their integration with Apple's File Provider? Why would Office recognize a file as a OneDrive cloud document when opened through the application's Online Locations, but not when the exact same synchronized file is opened from Finder? Is there a way to reset or repair the Microsoft 365/OneDrive cloud-file recognition or File Provider integration without resetting the entire OneDrive again? Are there any relevant logs, caches or diagnostics that could show why Office considers a Finder-opened OneDrive file to be local? Opening every document through the Office application's Online Locations is a possible workaround, but it is not a practical long-term solution when working with a larger shared folder structure in Finder. I have already contacted both Apple Support and Microsoft Support. Apple referred me to Microsoft, and Microsoft Support subsequently recommended that I raise the issue here in the Tech Community. Any insight from Microsoft staff, MVPs or others familiar with Microsoft 365 for Mac, OneDrive and the macOS File Provider would be greatly appreciated. BBKRLP Copper Contributor Aug 28, 2026 Place Microsoft 365 Microsoft 365 excel mac microsoft 365 apps word 326 Views 1 like 3 Comments OneDrive files opened from Finder not recognized as cloud files on Mac How to batch convert JPG files to PDF? I have a large number of JPG images that I need to convert into PDF files. In some cases, each image should be saved as a separate PDF, while in others, I need to combine several images into a single PDF in the correct order. Doing this manually would take a long time, so I’m looking for a free and reliable method that can handle both tasks efficiently. It would be helpful if it could work offline, and I’m also open to using third-party software. Could anyone recommend a suitable solution? Thanks in advance. AveryMorgan200 Brass Contributor Aug 28, 2026 Place Microsoft 365 Microsoft 365 microsoft 365 apps 72 Views 0 likes 2 Comments How to batch convert JPG files to PDF? Backout Plan for EWS to MS Graph API upgrade for SharePoint|sapiens Microsoft has announced the retirement of Exchange Web Services (EWS) in Exchange Online, effective October 1, 2026. After this date, EWS-based integrations will no longer be supported. To ensure uninterrupted email functionality, all affected SharePoint|sapiens solutions must be upgraded to use the Microsoft Graph API. My question is this - if we upgrade to Graph and our SharePoint|sapiens solution goes sideways somehow, is backout / rollback to EWS an option? I realize we could only roll back until 10/1 since that's the EWS retirement date, but our leadership may request that we make our solution functional temporarily (if the upgrade causes a problem) by rolling back. chagedorn49 Tin Contributor Aug 28, 2026 Place Microsoft 365 Microsoft 365 Microsoft Graph sharepoint 80 Views 0 likes 2 Comments Backout Plan for EWS to MS Graph API upgrade for SharePoint|sapiens Microsoft To Enforce WAM for Delegated Interactive Graph Sessions In a GitHub post, Microsoft says that interactive Graph sessions using the default Microsoft Graph Command Line Tools app will use the Web Account Manager (WAM) in the future. Some administrators use older versions of the Microsoft Graph PowerShell SDK for continued access to browser-based authentication, but this won’t be possible once Microsoft makes the server-side change to enforce WAM on an undefined future date. Teams and Exchange Online also use WAM, apparently for better security. https://office365itpros.com/2026/08/28/interactive-graph-sessions-wam/ TonyRedmond MVP Aug 28, 2026 Place Microsoft 365 Microsoft 365 Microsoft Graph 21 Views 0 likes 0 Comments Microsoft To Enforce WAM for Delegated Interactive Graph Sessions Add-in Error: We could't connect to the '{0}' catalog server for this add in For the past month every time I try to use an Add-In in word I get the following error "we couldn't connect to the '{0}' catalog server for this add in." I have tried from multiple computers, Safari, Chrome, different accounts, etc. and nothing is working. It is a personal account and I use word online. It happens for multiple add-ins and I have reached out to the companies directly and they said it was a Microsoft issue. cmflynn Copper Contributor Aug 28, 2026 Place Word Word 568 Views 0 likes 10 Comments Add-in Error: We could't connect to the '{0}' catalog server for this add in Cannot access forms link Cannot access forms link. IS there some setting for restrictions? zaibamulla Copper Contributor Aug 28, 2026 Place Microsoft Forms Microsoft Forms Forms Responses 2.6K Views 0 likes 10 Comments Cannot access forms link 2 MIN READ What's New in Excel (August 2026) Welcome to the August 2026 edition of What's New in Excel! msexcel Excel Blog Aug 25, 2026 blog excel what's new 8.6K Views 0 likes 1 Comment What's New in Excel (August 2026) 2 MIN READ SmartArt is becoming more accessible in PowerPoint With this update, PowerPoint can now generate meaningful accessibility descriptions for SmartArt automatically. shireensalma Microsoft 365 Insider Blog Aug 24, 2026 accessibility powerpoint windows 651 Views 0 likes 0 Comments SmartArt is becoming more accessible in PowerPoint