Recent Discussions
Access Query Problem
Good afternoon. I have been trying to track down a very strange error that my database has thrown for the first time ever... the query performs a complex math equation based on temperature, chlorine residual and pH time to compute the amount of time required to meet disinfection. This month the temerpature of the water has been historically high and the time required historically low. See the screenshot below. The math is evaluating the time required is greater than the time achieved (which it is not). The query is pasted below. I have recreated the math in excel and cannot duplicate this error. It seems exclusive to Access. When the formula evaluates as 10.0 the results are “YES” if the formula evaluates as 9.9 the result becomes “NO” but should be yes… Any advice would be greatly appreciated. Also, this post keeps getting flagged as SPAM... This is attempt number 5.. Fingers crossed.
Using the FILTER Function
I have a spreadsheet with a long list that I need to search to determine if a specific word or term is included in the list. In some cases, I want to search for part of the word or term, e.g., I may want to search for "Asset" but want to know all the terms where "Asset" is included, e.g., "Asset Management" would show up in my results as "Asset" is included in the term. I don't want to have to use FIND every time I need to search. I tried to set it up using the FILTER function, but I must not understand how it works, as I continue to get errors. Can you please suggest a way to best approach this? Is the FILTER function the best way, or can you suggest another option? Thank you.How to share calendar from Shared mailbox to mobile app
Hi, In our organization, we have the following requirement: to create three calendars within a shared mailbox and make them visible to members on both PC and the mobile app. On the PC, they are visible, but not on the Outlook app. On the app, we can only see the main shared mailbox calendar, not the three additional ones. The goal is to visually distinguish the three types of appointments on the app. We tried using categories (tags), but the colors have to be reset for each member. Any suggestions? Thanks
How can specific users be exempted from a tenant-scoped Microsoft 365 Apps Policy?
Hello, I am looking for guidance regarding Microsoft 365 Apps Cloud Policy Service behavior and policy precedence. Current configuration: In Microsoft 365 Apps Admin Center → Policy Management (config.office.com), we have the following policies: Policy 1 Name: Shorten Meeting Global Scope: Tenant Priority: 0 Configured settings: Shorten appointments and meetings = Enabled Reduce the end time of short appointments and meetings = 5 minutes Reduce the end time of long appointments and meetings = 10 minutes Policy 2 Name: Test Scope: User (Security Group) Priority: 1 Assigned only to a dedicated test group Relevant settings configured as Not Configured Observed client behavior: On corporate-managed devices, affected users receive the following registry values: HKCU\Software\Policies\Microsoft\Cloud\Office\16.0\Outlook\Options\Calendar shortenevents = End_Early endearlyshort = 5 endearlylong = 10 The Outlook option: File > Options > Calendar > Shorten appointments and meetings is greyed out. Additional validation: Using the same Microsoft 365 account on an external non-corporate device: The above registry path is not present. The Outlook option is editable. Testing performed: A user-scoped Cloud Policy was created and assigned to a dedicated security group. For the "Shorten appointments and meetings" setting, only the following options are available: Enabled Not Configured There is no Disabled option. but the Tenant policy continued to apply and the Outlook option remained locked. Questions Is there a supported way to exempt specific users from a tenant-scoped Microsoft 365 Apps Cloud Policy when the setting only supports "Enabled" and "Not Configured" and does not provide a "Disabled" option? Does Not Configured in a User-scoped policy allow evaluation to continue to the lower-priority Tenant policy? If policy precedence is changed so that: Test Policy = Priority 0 Tenant Policy = Priority 1 would the User policy potentially suppress the Tenant setting? Is there a supported way in Microsoft 365 Apps Cloud Policy Service to provide exceptions for specific users while keeping the Tenant policy as the organizational default? Has anyone successfully implemented an exclusion or override scenario for the "Shorten appointments and meetings" setting? Any guidance or documentation references would be greatly appreciated. Thank you.Purview DLP Blocks Sharing Files with Specific Domains or Users
A new DLP rule is available to control sharing of SharePoint and OneDrive files with selected domains and email addresses. The new rule supports an allow list (permit sharing) and can also specify a deny list (block sharing). The user interface takes a little getting used to, but when everything is configured and SharePoint has had a chance to respond to the block, the rule works and any attempt by a blocked user to use a sharing link is refused. https://office365itpros.com/2026/07/22/block-sharing-dlp-sharepoint/Complete Microsoft 365 Security Checklist: Protect Your Business from Modern Cyber Threats
Microsoft 365 has become the backbone of modern businesses. From emails and file sharing to collaboration and cloud storage, organizations rely on it every day. However, as Microsoft 365 adoption grows, cybercriminals increasingly target it through phishing attacks, credential theft, ransomware, business email compromise (BEC), and data leaks. https://dellenny.com/complete-microsoft-365-security-checklist-protect-your-business-from-modern-cyber-threats-2026-guideDLP Prevents Microsoft 365 Copilot from Processing External Email
A new (preview) DLP capability allows Microsoft 365 tenants to block Microsoft 365 Copilot from processing the content of external email. When set, any message coming from a domain that’s not in a tenant’s accepted domain list is blocked for Copilot for grounding, referencing, or summarization. It’s an effective way of blocking threat like prompt injections transmitted in email too, but some people might not like blocking all their external email. https://office365itpros.com/2026/07/29/dlp-external-email-copilot/Extreamly frustrated that I cannot get help for a serious problem
What the devil do I have to do to get help with a serious problem with the cloud for our non-profit business account for our small charity. I have 'lost' sight of a large number of documents from the cloud since we had to start paying for our subscription. After many chats with ai and emails and the problem being escalated I have now been told to go back to where I started at Non-profit support and put a support ticket in. Doesnt matter what machine I use, what browser I use, what network I use, I cannot get past the submit form page and keep getting an error message - this has been going on for weeks now. Ive tried ringing and the call keeps dropping while on hold - no one, no-one will call me about the problem and no one seems interested in dealing with the problem and its not just affecting me on our system either. Please will someone tell me how to get to a human for support without using an AI help system,Excel Print to .PDF Not Formatting as it Used To
We use Excel for our PO forms. We have been using it for 20+ years. We have the Acrobat add-in in Excel, we then select as many sheets as we have pages to convert. Once in Acrobat, we bring in the background PO form and we have a digital PO. Suddenly one of our computers had misalignment problems. The top part of the printed form looked great, but at about the 1/3 mark on the page it started to push down the words, pushing them out of the boxes that once worked perfectly. This started with 1 computer - now we have 4 out of the 5 computers doing this. This happened before the Windows 11 upgrades. The 1 computer that still works is on Windows 11, so we can't trace it back to that. I have tested old Excel files that once worked - they no longer work on these 4 computers. I have tried everything I know - resetting default fonts back to Calibri instead of Aptos - nothing seems to work. This is a huge problem for us since it is the key to our work flow as a purchasing company. We can't reformat the form because the 1 computer still works and for now - we need that computer otherwise, we would not be able to release any PO's. I have been all over the internet trying to find a resolution - I even posted a question probably a year ago about this and never received an answer that worked. We have had an IT specialist take a look at this. He believes it's Excel's problem because the MS .pdf printer shows the same problem. We really need a resolution - this happened for what appears to us to be no logical reason. Thanks.
Is there any solution to getting question names yet for a form submission in Power Automate?
It's been about 10 years now. Surely there is a solution to dynamically retrieve question names without needing a janky britttle workaround that may or may not work, not just IDs (get form response etc), without having to rely on a hard coded list of questions with answers inserted in against them.Hacked please help
My Microsoft account was hacked today. The attacker changed my sign-in alias to a random Outlook address, removed my phone number, added their own Authenticator app, and changed the recovery email. My original email now says the Microsoft account doesn’t exist. I have the Microsoft security emails proving the changes. I also have other forms of proof. If there is any moderator or anyone who can help me recover my account I had some important stuff on there I would like to get back. It wasn't this email but another one I made this so I can ask for help. When I tried to recover the email they changed it as provided in the screenshots down below. I tried to call support and fill out recovery stuff but since they changed the email for the account there is not much I can do.
Nesting a COUNTIF With IF To Evaluate A Formula
I have a sheet called Employee Training Matrix that I use to lookup data in a tab called Documents to see if there has been a date entered into a range of cells. Depending on how many dates are entered, the sheet will calculate the percentage where a person has been trained for a particular job. For example, the safety training requires three documents, so the formula I use for this lookup is "=COUNTA(Documents!C3:C5)/3". The issue is that some people do not require training in some areas, so I want to have the sheet to return a blank cell that I will format with a conditional format rule. Is there a way to do an IF and COUNTIF formula that will return a blank cell on one sheet when the second sheet has no date and run my COUNTA formula if there is? Or is there another way to address this? Thank you.
Microsoft Forms Ownership Transfer Redirects to DesignPagev2.aspx Instead of Loading Delegate Page
I am attempting to transfer ownership of Microsoft Forms belonging to a former employee, but the transfer process is not working as expected. The user account still exists in Microsoft Entra ID. The account is disabled in Entra ID. Sign-in is disabled in Microsoft 365 Admin Center. The account is not hard deleted. I am a Global Administrator. I have a valid Microsoft 365 E5 license that includes Microsoft Forms. When accessing the documented Forms transfer URLs using both the user's UPN and Object ID: forms.office.com/Pages/delegatepage.aspx?originalowner=<UPN> forms.office.com/Pages/delegatepage.aspx?originalowner=<ObjectID> the request immediately returns an HTTP 301/302 redirect to: forms.cloud.microsoft/Pages/DesignPagev2.aspx instead of displaying the Forms ownership transfer interface. Could you please confirm: What is the currently supported method for transferring Microsoft Forms owned by a disabled user account? Is the legacydelegatepage.aspxownership transfer mechanism still supported, or has it been retired/replaced? Is the automatic redirect toDesignPagev2.aspxexpected behavior in our tenant? Are there any tenant-level settings, licensing requirements, administrator roles, or backend restrictions preventing the transfer interface from loading? Can Microsoft verify whether the disabled user's forms are still available and eligible for ownership transfer?Lambda that uses INDEX with array arguments behaves inconsistently when saved in the Name Manager
Hello, I have encountered what appears to be inconsistent behavior when a particular type of lambda is saved in the Name Manager. The issue seems to occurs when the LAMBDA uses INDEX with either the row_num or column_num argument supplied as an array. The following is a minimal reproducible example: The formula "=LAMBDA(arr,INDEX(arr,1,{1,2,4}))({1,2,3,4})" correctly evaluates to {1,2,4}. Now, save the lambda as TEST (or any other name) in the name manager. The formula "=TEST({1,2,3,4})" also spills the expected array {1,2,4}. However, when the result is passed to another function, the behavior changes. For example, "=SUM(TEST({1,2,3,4}))" and "=COLUMNS(TEST({1,2,3,4}))" both evaluate to 1. In contrast, using the lambda inline instead of the defined name produces the expected results: "=SUM(LAMBDA(arr,INDEX(arr,1,{1,2,4}))({1,2,3,4}))" returns 7, and "=COLUMNS(LAMBDA(arr,INDEX(arr,1,{1,2,4}))({1,2,3,4}))" returns 3. Unfortunately, I am unable to attach a workbook to this post. Additionally, the issue is not reproducible on every machine I have tested, although it is consistently reproducible in Excel for the Web. I am currently using Excel version 2607 on the Current Channel. Does this appear to be expected behavior, or is it a bug? In the meantime, what would be the best way to mitigate this issue? I have found two potential workarounds. The first is to prepend the result of the named lambda with a unary + (e.g "=SUM(+TEST({1,2,3,4}))"), which appears to force excel to treat the result as an array. However, when using a shared lambda library (as is the case for most of my team), users generally do not know the implementation details of each lambda, so it is difficult to determine when this workaround is necessary. The second approach is to avoid passing an array to the row_num or column_num argument of Index by using MAP. For example, the TEST lambda defined above can be rewritten as =LAMBDA(arr,MAP({1,2,4},LAMBDA(idx,INDEX(arr,1,idx)))), which causes it to behave as expected. However, I am concerned about potential performance implications. Intuitively I would expect that a single INDEX call with an array argument would be more efficient than multiple INDEX calls wrapped in MAP, but I do not know whether this is the case. Has anyone else encountered this behavior before?Displaying Time in hours
I have a spread sheet where I record my work hours. Eg: 0700 (A2) - 1530 (A3) which equals 8 1/2 hours, then I take 30 minutes off for a lunch break, which leaves me with 8 hours. My formula is A3-A2-30 which brings up the result as 800.00. I have tried all different methods and formulas but I can't get the hours to show as 8.00. I then use the 8.00 hours in another formula to work out my pay for the day. Please help.
Python in Excel 365 returns #CONNECT! in desktop and web
When I try to enter a simple Python expression (like "PY 1+1" ) in Excel 365 Desktop version or Web-version, I get "#Connect!" mistake in Excel Cell. When I try to run Formulas->Python->Initialization, I get error text: "Error: We weren't able to retrieve this value. We recommend restarting the external code service environment." Simple restarting Python Environment with the help of "Reset" or "Reset Runtime" do not solve the problem. I use Windows 11, Office 365 (family). PS. I would be happy if somebody could help to solve. As for now, standard Microrsoft Suport recommended to ask for a solution in TechCommunity.Microsoft.Com
Recent Blogs
- Help employees find the right people faster with Assistant relationship dataJul 29, 2026
- 4 MIN READWelcome to the July 2026 edition of What's New in Excel!Jul 28, 2026
