Recent Discussions
How to Fix Microsoft 365 Activation Failed: A Complete Troubleshooting Guide
Seeing the “Microsoft 365 Activation Failed” message can be frustrating, especially when you need to open Word, Excel, PowerPoint, or Outlook and get work done. In many cases, the problem is not as serious as it looks. Activation can fail because of an incorrect Microsoft account, an expired subscription, an internet connection problem, conflicting Office installations, outdated Office apps, or an issue with the device’s date and time settings. Link to the post
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)How to Update Teams Settings After Transferring Meetings
When discussing the transfer ownership of calendar events, we pointed out the Teams meeting problem. Essentially, if an event is a Teams meeting, details of the online meeting are not updated to allow the new owner to control its settings. The result is that recordings and other online meeting artifacts can end up in the wrong place. Microsoft should fix the problem. In the meantime, a PowerShell script illustrates the issue and shows how a fix might work. https://office365itpros.com/2026/08/25/teams-meeting-transfer/
How to convert pictures to pdf on iPhone?
Hi everyone, I’m trying to convert several pictures on my iPhone into PDF files so I can email or upload them more easily. Sometimes I need to combine the pictures into a single PDF, but I also need to batch-convert them so that each picture becomes a separate PDF. I’ve seen suggestions about using the Files app or the Print menu, but I haven’t found a way to do this with either option. Is there a built-in way to do this on an iPhone, or can it be done through OneDrive or another Microsoft app? I’d like the pictures to remain in the correct order and stay clear without making the PDF unnecessarily large. Any advice would be appreciated. Thanks!
Entra MFA for seniors using W365 Biz Basic
Entra MFA for seniors using W365 Biz Basic, these folks cannot and will not deal with mobile auth apps or keyfobs. This is a Historical Society. Need MFA bypass or non-technical solution that Senior Citizens with only enough knowlege to work MS Word can handle. There is zero risk of data loss or hackers or the like. We have nothing to lose as all is websearch and simple word docs. MFA without SMS or voice is going to put a lot of non-tech seniors out of their livelihoods. Need a simple non-tech solution. MS is so worried about CYA with regard to security, that they are pushing people out of technology. Do I have to go to Google Docs for a solution? Libre? It's not MS responsibility to remove all possibilities for poor decisions. Give us the tools for wise decisions, but quit binding us up. I need a solution or I'll have to move these folks off M365.
Print to PDF and crashing issue - Access Version 2607 and 2608
Multiple customers are reporting crashing and print to pdf issues after updateing to Access version 2607 and 2608. Versions with the issue: Version 2607 (Build 16.0.20228.20190), Version 2608 (Build 16.0.20326.20072), and Version 2608 (Build 16.0.20326.20100) Working version is version 2606 (Build 16.0.20131.20154), rolling back to this will resolve these issues. Crashing (Build 16.0.20326.20022) Some users reported that crashes occur shortly after opening the Access application. Here is the event log error. Faulting application name: msaccess.exe, version: 16.0.20326.20100, time stamp: 0x6a83d187 Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000 Exception code: 0xc0000409 Fault offset: 0x00007ffb274a628f Faulting process id: 0x5BF8 Faulting application start time: 0x1DD2FF382F4BC5A Faulting application path: C:\Program Files\Microsoft Office\root\Office16\msaccess.exe Faulting module path: unknown Report Id: a6329f20-3c01-439f-a152-a7cdb6ef74b4 Faulting package full name: Faulting package-relative application ID: PDF not formatting correctly (Build 16.0.20228.20190 and Build 16.0.20326.20072) Exporting the Access report to PDF will cause the following issues. When exporting a multi-page report as PDF, the second page displays at a quarter of its original size. Some users experience the right margin being slightly larger, causing the right size to be cut off. Some text on the report are changed to a different font type and size after exporting PDF. Form textbox, label and buttons display properties are changed after previewing a report (Replicated on Build 16.0.20228.20190) After closing the print preview of a report, the Access form's textbox, label and buttons are not displayed correctly. Some text are not visible, background color seems to have changed, font type are different as well. The Access application is required to be closed and reopen to fix the issue.Changing Endnotes from Roman to Arabic Numerals in MS Word Online, 2021
I think the title is pretty self-explanatory. I can't figure out how to change my document endnotes from Roman to Arabic numerals (from i, ii, iii to 1, 2, 3.) The document is going to a publisher and needs to be formatted in Chicago Style, so it is imperative that I change this. The first chapter of the book has 170 citations, so doing each one individually, while an option, would be very tedious. Any help would be appreciated!
Is Warehouse management APIs are available in business central?
Hi Team, I have use case like to enter goods item level and need to store it in business central.Like i need to do like to create purchase order from invoice document and do inventory put Away through API .Create PO API is there.Please guide me to get inventory put-away API? Thanks, ArdraWhy is Microsoft being a bully in regard to security defaults?
Hi, I received this email today: The security defaults setting for your domain.com tenant will be turned on by May 11, 2023 You’re receiving this email because you’re a global administrator for domain.com. To help protect your organization, we’re always working to improve the security of Microsoft cloud services. As part of this, we’re enabling the security defaults setting in your tenant that includes multifactor authentication, which can block more than 99.9 percent of identity attacks that attempt to compromise your accounts. When you log in to your account between April 27, 2023, and May 11, 2023, you’ll see a message prompting you to proactively enable security defaults. If you haven’t logged in or enabled this setting when that timeframe ends, we’ll enable it for you automatically. This is my subscription, I pay for it and Microsoft has no right to tell me what to do!!!! Angry I already disabled my security defaults in Azure admin centre a long time ago and do not want security defaults on because there may be situations where my mobile is unavailable, there is no signal or the battery is flat. Microsoft can suggest this, but cannot force their clients to enable this if they don't want to. There are many of my clients that don't want to authenticate a second time because it would cause a nightmare with their employees. Forcing someone is dictatorship. In a democratic society people get to choose what they want to do. I read that I can use conditional access policies but Microsoft is going to hit you with an additional Azure AD Premium subscription on top of what you are already paying. Many of my clients are small businesses who try to keep their costs down. Currently inflation is rampant and many small businesses are going bust. Thanks Microsoft for increasing our cost of living and running a business. This is my 2 cents worth on this subject.OneNote To Do tag changed to a radio button
After a recent update, the to-do tag still behaves like a checkbox but is styled as a radio control:. Here's why I say that. Some UI differences between radio and checkbox are: - Circle outlines convey a radio button control, and selection fills in most/all of the outline - Square outlines convey a checkbox control, and selection usually does not fill in the entire outline Radio controls are mutually exclusive by design (selecting one de-selects the others). They are not appropriate for a to-do list. I can get close to the original UI by customizing the tag, but not entirely: Is this bothering anyone else as much as me?August 2026 RDP font display glitch
In the last days, we have received two independent reports of font display problems in our MS Access based application. The symptoms are as follows: Some labels or text boxes are shown in a legacy system font instead of the font specified in the control (Segoe UI). Also, the label/text box is shown with a white background instead of transparent. Moving the Access window "fixes" the glitch. It happens at seemingly random places in our application at seemingly random times. Both reports have in common that the Access application is running inside an RDP session. In report 1, a work-from-home user used Remote Desktop to connect to their office Windows 11 PC, and, in report 2, a user executed the application on a Windows Terminal Server. Here are a few screenshots to illustrate the problem. The left side is the glitch, the right side is how it is supposed to look. The first row shows labels, the second row text boxes in a continuous subform. Report 1 is 16.0.20228.20186, 32 bit, M365 SAEC. Report 2 is 16.0.14334.20848, 32 bit, Office 2021 LTSC. Is this a known issue, or shall we continue to collect data about this glitch? Unfortunately, we haven't found a reliable way to reproduce it, so our ability to test it with different versions is limited.What Are Some Best Practices for Securing SharePoint?
SharePoint has become an important part of how modern organizations store documents, share information, collaborate on projects, and manage business processes. But as more sensitive information moves into SharePoint, security needs to become a priority rather than an afterthought. Link to the post
Security Admin Center Tenant Allow/Block List Not Able to Block IPv4?
While using the Security Admin Center Tenant Allow/Block List we have been able to block specific email addresses and IPv6 IP addresses but are unable to block IPv4 IP addresses. We have tried both using the console and the CLI but have turned up unsuccessful both times when it comes to IPv4. A large majority of the phishing attempts that we encounter come from IPv4 addresses but we have been unable to block any of these. Will there ever be functionality for IPv4 within the Tenant Allow/Block list or is the only option to use conditional access policies? Also why is this enterprise tool only functional with IPv6 and without documentation stating that it does not work for IPv4?Отчёт о проблеме с многоязычной поддержкой в Microsoft Word
Описание проблемы В операционной системе Windows, установленной на английский язык (США), Microsoft Word не корректно переключает проверку орфографии и выравнивание текста при работе с многоязычными документами, особенно с языками, использующими кириллицу (русский) и иврит (RTL). Несмотря на многократные попытки изменить настройки языка проверки правописания в Word, система продолжает использовать американский английский для проверки орфографии и не поддерживает корректное выравнивание и проверку для других языков. Это делает практически невозможным корректную работу с многоязычными документами, что является серьёзным препятствием для пользователей, работающих с несколькими языками в одной системе. Технические детали ОС Windows настроена на английский язык (США). Microsoft Word продолжает использовать проверку орфографии US English, игнорируя настройки смены языка. Попытки сменить язык проверки орфографии через интерфейс Word и системные настройки не приводят к результату. Отсутствует поддержка корректного выравнивания текста для языков RTL (например, иврит). Проблема наблюдается при работе с русским и ивритом, а также другими языками, отличными от английского. Влияние на пользователей Невозможность корректно проверять орфографию на нужном языке. Некорректное выравнивание текста, что ухудшает читаемость и оформление документов. Серьёзные ограничения для пользователей, работающих с многоязычными документами. Рекомендации Обеспечить корректное переключение языка проверки орфографии в зависимости от языка текста. Поддержать автоматическое выравнивание текста в соответствии с направлением языка (LTR/RTL). Улучшить интеграцию языковых настроек Windows и Microsoft Word для многоязычных сценариев. Данный отчёт предназначен для передачи команде разработчиков Microsoft, отвечающей за локализацию и поддержку многоязычности в Office и Windows.
Custom notification sounds on multiple accounts in New Outlook
So, with this configuration/setting, am I correct in assuming that whatever sound I choose for a New Mail notification should apply to all accounts (I have four)? No matter what I do, I can configure only the Primary account sound, while all others insist on using the default sound. Very frustrating...
Recent Blogs
- With this update, PowerPoint can now generate meaningful accessibility descriptions for SmartArt automatically.Aug 24, 2026
- You can now share direct cloud links to specific locations within a document in Word for Windows and for Mac.Aug 13, 2026
