Recent Discussions
Formula help
I have the following formula that partially works. It processes this formula and returns the 1st match based on the formula criteria. =IFERROR( LET( KeyTypes,FILTER('Key Log'!$F$4:$F$309,(TRIM('Key Log'!$A$4:$A$309)=TRIM($D$6))*(TRIM('Key Log'!$C$4:$C$309)=TRIM($K$15))), KeyNums,FILTER('Key Log'!$K$4:$K$309,(TRIM('Key Log'!$A$4:$A$309)=TRIM($D$6))*(TRIM('Key Log'!$C$4:$C$309)=TRIM($K$15))), IF(INDEX(KeyTypes,ROW(A1))="Hard Key","V"&INDEX(KeyNums,ROW(A1)),INDEX(KeyNums,ROW(A1))) ),"") This formula resides in cells A8:A18 which is designed to return a key number, whether the key be a swipe key or a hard key. Cells B8:B18 are for descriptions of the key identified in cells A8:A18. This formula is supposed to find the 1st match on the key log and then find any other matches and place them in cells A8:A18. There is another formula for defining the description based on criteria. I need this formula to search out all transactions on the key log that match the ID number on the Key Issue Form in cell D6 with the cells in column A on the ID number and to also match the room number from K15 on the Key Issue Form with the room number in column C on the key log. There is something missing from this formula that is not allowing the other transactions to be found and listed on the Key Issue Form. Can anyone help me complete this formula? This is the formula for B8:B18 =IF(A8="","", LET( FilteredRows,FILTER(SEQUENCE(ROWS('Key Log'!$A$4:$A$309)),('Key Log'!$A$4:$A$309=$D$6)*('Key Log'!$C$4:$C$309=$K$15)), RowNum,INDEX(FilteredRows,ROW(A1)), Room,INDEX('Key Log'!$C$4:$C$309,RowNum), Status,INDEX('Key Log'!$E$4:$E$309,RowNum), Type,INDEX('Key Log'!$F$4:$F$309,RowNum), DateVal,INDEX('Key Log'!$D$4:$D$309,RowNum), IsAB,OR(RIGHT(Room,1)="A",RIGHT(Room,1)="B"), DoorDesc,IF(IsAB,"Combined Main & Room Door","Main Door"), KeyDesc,IF(Type="Swipe Key","Swipe Key","Hard Key"), DoorDesc & " " Can someone help me figure this out? Carl
tenant completely unreachable after update PLAID number on partner portal
Hi, i'm a reseller in Italy. I have a partnership with a local distributor to resell Office 365 product from many years. On the license side (my panel at vendor) i see my license available yet, like other customers. In these days we have changed the PLAID as requested to enable again our partnership. I've opened the ticket as suggested and after that we have lost completeley the access with any admin of our domain (@noorduffici.com and onmicrosoft.com) I can't login even in the partner portal of microsoft that reply with ( the mail doesn't exists) I've tried to call any number of support but anytime I go on with a virtual caller without a solution . Someone could hel about this issue ? The domain is not corrupted because i've access and i change the MX record to work temporaly with mail NOT microsoft.
Afficher une image de bonne qualité quand elle s'affiche en grand
Bonjour, J'aimerais insérer une image en grand dans mon formulaire, mais lors du passage de l'image dans le formulaire la qualité est dégradée (pixellisée). Comment améliorer la qualité de l'image ? Merci d'avance et bonne journée à vous !Checking Where Tenant Users Go as Guests
After all the fuss about Teams users inviting people to chat via email, tenant administrators realize that knowing where users are active as guest accounts is not as easy as it might seem. Part of the problem is that data about user activity is mostly controlled by host rather than home tenants. However, it’s possible to extract some information from audit sign-in logs to figure out where tenant users go as guests. https://office365itpros.com/2025/12/09/external-guest-activity/Access SQL Syntax Highlighting, Autocomplete, and Formatting
I just had Access (the newest version with Office 365) lose all syntax highlighting, autocomplete, and the formatting that had been allowed previously. It worked last night, and this morning it was all gone. The issue is on my Windows 10 desktop. It still highlights syntax and formats for readability on my Win 11 laptop. The only thing I can find between the two versions that is different is there is a checkbox for the Monaco query editor in Access on my laptop, but not my desktop. I would like to reiterate that it was fine last night on the desktop. I opened the same database this morning, and it was gone. I checked other databases, they all lack the highlighting and formatting on my desktop, but it is still there on my laptop. I attempted to update, repair, and reinstall office, and nothing changed. I am trying to determine what might have caused this, and if there is anything to do about it. The highlighting, autocomplete, and formatting are not a complete necessity, but they made working with the queries a lot easier for me, since I am a not particularly experienced with SQL.
Dependent calculations in tables
Hi all, I'm using a formula to calculate amounts into a master column in budget sheets depending on the currency. I'm pulling currency rates with the stock function into a separate sheet with named cells for each rate that I'm using. My budget table has a "Total" column where I put in the amount, a "Cur" column where I select the currency, and then the master column where it's converted into the currency that I'm working with for each budget. The formula I'm currently using is this: =IFS([@Cur]="EUR";[@TOTAL];[@Cur]="NOK";nokeur*[@TOTAL];[@Cur]="SEK";sekeur*[@TOTAL];[@Cur]="GBP";gbpeur*[@TOTAL];[@Cur]="";) nokeur, sekeur, gbpeur are named cells containing the currency rates. The last argument is only to not get a REF error on empty rows. (Semicolons instead of commas due to my language settings) This has gone through a bunch of revisions over the years and I'm constantly trying to shorten the formula as much as possible. This is the shortest I've managed to get it though. I wanted to check if anyone has any advise on how to make it more elegant. the formula does exactly what I want so it's not a problem per se, it's more out of interest. Also a related topic: sometimes when others are using my sheets, they will mistakenly put values in the Master column, overwriting the formula. This is hard to spot, and ideally I'd like to lock those cells/that column so you can't replace what's there. Locking the workbook can of course achieve this but it also prevents the user from adding additional lines in the table. Is there any smart way to get around this? I've also tried with conditional formatting to clearly highlight the cells if they don't contain a formula but I haven't managed to make it work properly.
How do I correct heading numbering?
UPDATE: I couldn't remove this post, after I discovered the issue. Thanks! I need to update heading numbering within an old document. Custom headings were made (as pictured) but I need the heading levels 2 and 3 to include the parent heading number of each. When I attempt to update the level 2 heading for Section 2, it wants to continue with Section 1 (see pictured example). In the number format, I do not know how to tell Word to include the parent numbers? I included "1." thinking it was intelligent enough to know that was just a format designation of the parent heading, but I guess that isn't how. I realize I may be making some glaring mistakes, but just trying to get it right. So this is a learning moment. The caveat here is that I'm not creating the heading from scratch but rather, trying to update the existing document headings. I did follow some online suggestions but none of them addressed including the parent value in this scenario. Section 2 <Heading Level 1 text format> <-- Here I need the word "Section" to proceed the level 1 heading number 2.1 <Heading Level 2> <-- Here I need the level 2 heading to include the parent section level number 2.1.1 <Heading Level 3> <-- Here I need the level 3 heading to include level 1 and 2 numbers.Need help with conditional fomatting formula based in text on cells
Hi everyone, I have a list of owners' names in column C. C2 contains 1+1 CAR CORPORATION C3 contains 8-J ENTERPRISES, LLC C4 contains LOYD RENTALS LLC C5 contains SMITH PAUL & PAULA C6 contains DOE JHON & JANE C7 contains MENENDEZ JAMES C8 contains BROWN INVESTMENTS, INC. And so on I'd like to highlight the whole row for the cells that have CORPORATION, LLC, INC, ENTERPRISES in their names. Hope this makes sense and someone can help me. Thank you.
Outlook MacOS - Email-section display issue
Since the latest Outlook update for MacOS - Version 16.105 (25120324) - there is a display error in the email-section. There is a large empty space between the "Search"-Header and the "Email"- Header This issue only occurs in the email section. All other areas (Calendar, Contacts, etc.) are looking normal:
How to add a new field to existing XML Mapping
Hi, everyone! Good day! I've made an XML file which I imported to my doc using XML Mapping Pane -> (Add new part...) and I used it to map some texts. How could I add new fields to this XML Mapping? What I tried: I tried editing the XML file and then importing it again. As a result, I have two XML Mappings with the same name that act as completely separate mappings. I couldn't even find a way to delete the older one.Excel cell calculation
Hi all, first timer here. In Mac Excel I’m wanting to calculate a selling price minus a cost price times the amount of items. So cell D4 is $3, minus cell C4 which is $1, multiplied by 18 items B4. In E4 I have done the formula of =D4-C4*B4 but I get -$15 which is incorrect, should be $36 Where am I going wrong? Thanks all
Excel Formula Help: Reflecting Dynamic Monthly Credit Card Payments by Date
The Goal: To display the correct monthly payment amount (from the Debt Schedule tab) on the Main Worksheet tab, placing each payment under the correct date column (J4:AV4) based on the due date for each credit card. The Problem: The Debt Schedule tab lists multiple credit cards and a month-by-month payoff schedule. As each card is paid off (listed lowest balance to highest), its scheduled payment rolls over and is added to the next card’s payment. However, the formula I’m currently using on the Main Worksheet tab does not capture these changing payment amounts over time. I need a formula or approach that dynamically reflects the evolving monthly payment amounts as cards are paid off. Google Drive Link: https://docs.google.com/spreadsheets/d/1jPYLWfuOxEtxF3Mvfo5PFUTsE3_x_5iH/edit?usp=share_link&ouid=102575009763592887799&rtpof=true&sd=trueUsing Upper and or Proper Function - not working properly
I am trying to use the UPPER function on my Excel sheet. I was able to format my first column, but when I try the next column, it won't convert. I have tried several times, and it will not convert the function. I have included two screenshots to show the progression. I formatted the column to text, and have tried to troubleshoot any tips I have come across. I have tried both on my desktop and uploaded to my 365 and both have the same result. What am I missing?
macOS - duplicate OneDrive file storage
The files in my macOS (Sequoia 15.6.1, M2 MacBook Air, Microsoft 365 Family) OneDrive folder at /Users/XXX/Library/CloudStorage/OneDrive-Personal/ use 111 GB of hard drive space. The exact same files appear in /Users/XXX/Library/Group Containers/UBF8T346G9.OneDriveStandaloneSuite/OneDrive.noindex/OneDrive/, consuming another 111 GB of storage space. Is this really the case, and if so, WHY? Could one set of files just be APFS clones, and if so, how to verify this? The Finder as well as apps GrandPerspective and OmniDiskSweeper seem to suggest that both groups of identical files are consuming real hard drive space. Thoughts?
MS Form embedded in web page does not show up on the mobile browser
I have created a Microsoft Form and integrated it into my website. When I visit the website using a desktop computer, the initial page of the form is shown correctly. However, when I access the webpage on a mobile device, the form's green page is displayed, and I am prompted to complete the form. Is there is a way to make the first page of the form automatically appear on the mobile webpage.How to make excel add or remove rows to fit data and prevent spill error?
Hello! My question is: When using the =FILTER formula to copy cell data from one sheet to another, how can I make excel add or remove rows as needed to prevent a spill error? I am using the =FILTER formula to copy cell data from one sheet to another if a checkbox is checked. My formula uses the cells containing the checkbox (column A) as the reference for columns B, C, D, etc. to the right. I did this by selecting the cell that has the formula on the destination sheet, highlighting this cell and those to the right I wanted to transfer, and then control + r. My formula is: =FILTER('Source Sheet'!B5:B13,'Source Sheet'!$A5:$A13=TRUE) (If there is a way to copy an entire row from the source sheet instead of having to control+r to apply the original formula across select cells please also let me know, thank you!). However, I want the sheet to be able to automatically add rows to fit the data if the selected number of rows is greater than what I have left available on the sheet. Currently, if I leave 3 rows for data to fill and I select three checkboxes, this will fill the space with no problem. However, if I select 4+, I get a spill error (as there are not enough empty rows to put the data). Is there any easy way to have excel add rows as needed? Similarly, is there a way for excel to remove rows as needed? I am going to use this sheet to detail all medications being taken by family members (with medication name, concentration, dose, time to take each in their own column as column B, column C, column D, column E). The names will be listed in column A with ~3 rows below each name which will fill when the checkbox on the source sheet is clicked. I want to ideally fit this on one page when printing without major "fit to page" problems that come up during printing. The layout of the sheet will ideally look like this: The goal for the 'destination sheet' is to pull only the selected data I want to use from my master list on the 'source' sheet.' I want to avoid having a big empty space under each family member where they don't take many medications, and to also not have to manually add rows for family members that take a greater number of medications. Please let me know and thank you!Outlook failure
Since yesterday, December 6th, for some unknown reason I can no longer access Outlook from either the desktop or Start Bar I can only open it through Edge or some other similar sites. I have gone through the repair mode - still nothing. Any ideas as to why and how to get back to normal. Rgds, Dave R.Does MC1189663 Impact Standard Power Automate Approvals?
Hi everyone After reviewing the change described in MC1189663 (retirement of external access tokens for actionable messages), I'm unsure wheter this also affect the out-of-the-box Standard Approval action in Power Automate. My question is specifically about the default "Start and wait for an approval" / "Standard Approval" action with no special configuration. Does this change impact approval emails or actionable messages generated by the Standard Approval action for internal usage (mails to internal accounts), or will those continue to work without modification? Thanks in advance for any clarification.Microsoft Increases Office 365 and Microsoft 365 License Prices
Customers will see their bills increase from July 1, 2026, when Microsoft 365 pricing increases go into effect, adding up to $3/month for licenses. This is the first increase since March 2022, and it moves the baseline Office 365 E3 license to $26/month and Microsoft 365 E5 to $60/month. Microsoft justifies the increases based on the functionality and apps it delivers. Time for a licensing review... https://office365itpros.com/2025/12/08/microsoft-365-pricing-increase/
Recent Blogs
- We’re excited to announce that Agent Mode in Excel is now generally available on Excel for Web, rolling out to users with a commercial Microsoft 365 Copilot license or a Microsoft 365 Premium subscri...Dec 09, 2025
- Microsoft Copilot can draft a polished self-evaluation based on your work materials, or help you address a sensitive issue with a co-worker or boss.Dec 08, 2025
