Recent Discussions
Logic Explanation
=IF( AND( [@[Group(without DM Converted/Created Contact)]] = "Marketing Lead", OR( A10739 = "John Doe", A10739 = "Jane Smith", A10739 = "Michael Johnson", A10739 = "Emily Davis" ) ), IF( AND( XLOOKUP( [@[Converted Contact: Contact Id Safe]], 'DM with AddOn Created COntacts'!E:E, 'DM with AddOn Created COntacts'!F:F, "Sales Lead" ) = "Sales Lead", [@[First Form Fill Detail]] = "", [@[Last Form Fill Detail]] = "" ), "Sales Lead", "Marketing Lead" ), [@[Group(without DM Converted/Created Contact)]] ) Hi Excel Experts. I came across this formula from one of our resigned team members. can somebody explain how the logic works? I am just a simple photoshop user and was assigned to check this.
Formula to retrieve data from several sheets and return values from given criteria.
I am trying to get data from each of our areas of the school staff timetables EY MY LY and summaries what days each staff member works where to another sheet, as staff move around. I would appreciate some help please. This is how far I got: =IFERROR(VLOOKUP(A10,EY!$C$3:$G$33, 2, FALSE), IFERROR(VLOOKUP(A10,MY!$C$3:$G$33, 2, FALSE), "Not Found")) This just returns; I tried to add in the same formula for LY but it is saying too many arguments, this is why Michelle is Not Found. Will I also be able to return the area they are in on each of the days ? Any assistance would be very much appreciated.
Managing Two MSFT Licenses
Hi, I had an old hotmail.com email address but it doesn't exist anymore per MSFT. I purchased an annual Excel annual license several months ago but I can't find an email about it on my Gmail inbox. I just signed up for MSFT 365. How can I find the Excel license subscription so that it doesn't auto-renew?
Excel Power Query: editing unloaded query refreshes dependent queries
Hi all There has been a change between version 2601 and 2602 on the Current channel which means that when editing a query in Power Query it will trigger a refresh for all dependent queries. This makes Power Query unusable for any complex queries or large data extraction. Take the below example M code. SourceQuery is not loaded to the workbook or data model. LoadedQuery references SourceQuery and is loaded to the workbook. Query: SourceQuery let Source = #table({"Col1"},{{"x"}}) in Source Query: LoadedQuery let Source = SourceQuery in Source In version 2601 and previous versions, you could edit SourceQuery, 'close and load' Power Query and save your workbook almost instantly because no data was refreshed. In 2602 and later versions editing SourceQuery forces a refresh of LoadedQuery which can be very time consuming but more frustrating for all my complex/larger workbooks it triggers lots of refreshes which never finish and result in my having to end task on Excel (note: refreshing these queries takes less than 10 seconds). Doing an end task on all the mashup containers does not allow me to regain control of the Excel workbook. This means all changes to the workbook are lost. I have had to resort to using a VSCode extension to edit my Power Query without crashing Excel. The builds I have tested are 2601 19628.20166 and 2602 19725.20190. Are there any plans to rollback this change? Other than rolling back my Outlook version or using VSCode are there any methods to edit my queries without crashing Excel? It would also be helpful to understand why such a large change in functionality was not captured in the release notes. Per the release notes there were no changes to Excel in 2602, not even 'various fixes to functionality and performance'. Many thanks, Andrew
How to create a shared company calendar for time off and holidays?
I'M LOST I have spent DAYS trying to figure out some way to provide a shared company calendar with Holidays, PTO Schedules, On-Call Schedules, etc. We just want one place to see what's going on this week, who's available, and do we have a day off this week. BASIC information. After spending more than 3 days on this, I feel more lost than I did when I started. I could create a SharePoint Calendar. This calendar doesn't sync with Outlook for Mac or Apple Calendars and, most importantly, reoccurring events don't show up on a SharePoint Events web part. I could manually create reoccurring events but I rather not. Regardless, the functionality is incredibly limited. I could create a new M365 user. This would let me see these calendar in Apple Calendars and give myself or another admin access to update events. But this calendar can't be integrated in SharePoint or Teams so it's basically invisible. I could create a Channel Calendar in Teams but that's certainly not appropriate. I could create a new Group with a Calendar. Although, we already have a org-Wide Team and it doesn't actually do anything - can't email mailto:orgteam@company.com and it doesn't come with an Outlook calendar. I don't think I should have to add someone to a group for them to see a calendar I want public to the entire company. This might be the best compromise but that's besides the point. The POINT is, WHY in the world isn't this a built-in feature that's turned on the moment a company creates a M365 tenant? WHY do I need to spend days figuring out that all the archaic tutorials from 2017 don't even work in 2021? WHY can't MICROSOFT make calendars easy? I mean, I'd settle for difficult - it's better than impossible. And, not for nothing, I look like a complete idiot (I very well may be!) when my boss asks me to do something that should take 2 minutes and I have absolutely nothing to show 3 days later. Q: What is your business doing to let you know you have Memorial day off? How are you able to see if someone has the week off for vacation? Are you using a M365 product or something else?Stop Excel auto formating
How do I stop Excel from automatically formatting cells? I have three columns. The first column is formatted currency with fill. The second is text. The third is general. When tying a number in the general column Excel automatically formats the cell to currency with a fill matching the first column. How can I stop Excel from automatically changing the formatting of the cells in the third column?
Excel selects wrong cell
Hello, I am here to report on what seems to be a common issue... After working for a few minutes in excel, when I go to click on a cell, the wrong cell actually gets selected, and it is usually several cells above or below the cell my mouse is hovering over. I sometimes have success in saving, closing and reopening the book, but not always. Excel Office 365 version, updated on schedule, as always.Including Costs in a Microsoft 365 Licensing Report
This article describes how to include user license costs in a Microsoft 365 tenant licensing report created with the Microsoft Graph PowerShell SDK. The report includes annual costs for all licenses assigned to each user plus an overall licensing summary for the tenant. It even reports how effective the tenant is at assigning licenses! https://practical365.com/report-user-license-costs/SharePoint Online Gets Authoritative Sites
SharePoint Online authoritative sites are trusted sites for Microsoft 365 Copilot to give priority to when using material for chats and search results. Tenants that don’t use Microsoft 365 Copilot appear to gain nothing from the new ability to mark sites as authoritative because it’s all about “Improved relevance and trust in AI-driven responses grounded in authoritative content.” It does seem like a good idea, though. https://office365itpros.com/2026/05/19/authoritative-sites-spo/Search-UnifiedAuditLog Updated to Make Large Searches Easier to Manage
The advent of the MoreRecordsAvailable property gives the Search-UnifiedAuditLog cmdlet more precise control over fetching large numbers of audit records (up to 50,000 records). It’s a welcome change to report something positive about the Microsoft Purview Audit solution because most of the time we complain about its stability, slowness, and bugs. Things are looking up. https://office365itpros.com/2026/05/18/morerecordsavailable-propertyExcel can't open file from hyperlink after upgrade windows11
Hello, I met a strang issue. After upgrade system from w10 to w11, my excel can't open linkage file which was working normal before. Tested file and folder which located on local and SMB was not working, after click the hyper-lnik nothing happen and no pop-up just turn to mouse to loading icon then nothing happen how can I check which part cause this issue? Also tested on word have same issue. Further, url was working normal.
OneNote breaks if I move it onto an external display
Hi guys I use OneNote extensively for work as my virtual notepad. At most of my working locations, I use my laptop - Dell Latitude 7440 - connected to either a Dell Docking station + 2 monitors, or a pair of samsung monitors which have an inbuilt hub, connect via USB-C and are daisychained together. I've never had any issues with OneNote in the past, but recently have found that if I try and move my OneNote window onto either external monitor, it seems to break OneNote - the whole window becomes just the index list which is normally a column on the left (where it shows all your notebooks and pages) and it won't actually display any of the content from the notebooks/pages. If I try minimizing that column, it has a complete breakdown as if its unable to properly load the actual page content. The only way to fix this is to drag the window back to my laptop screen and then close it and reopen. Has anyone else experienced this? It's really frustrating and affecting my productivity as I often need it side-by-side with other screens.Slicer
Hi Expertises, Need your help again. I have pivot table as below. I need to capture the Product A sales amount under the following scenarios. Filter. Select any one country in slicer NO Filter. Select all country My problem is when I add formula in text box like =B2, under scenario 1, the answer is correct no matter I select which country in slicer. However, for scenario 2, when i did not use filter, the total of Product A Sales amount should refer to B6 instead of B2. So, i got incorrect answer. May i ask your advice in this case? Thanks a lot Regards Lawrence Country Product A Sales Product B Sales AU 100 40 JP 80 60 HK 60 80 KR 40 100 Total 280 280
Online Excel Version - Print Row Repeat/Print Titles
How do you set up the print row repeat or print titles option in the online version of Excel. I don't see these options available under Page Layout. Is there another location that this option is located or is this not available in the online version?
Copy content of a locked file
I have a team of transcribers; I send them images, they send me back a locked WORD documents. I CAN unlock it, but prefer not to. But I need to COPY the content and past it into my own document. "Locking" should allow copying; it should only prevent changes. BUT - sometimes Ctrl-A Ctrl-C in theirs and Ctrl-V in mine does work. And sometimes it does not ! Q1: What am I doing wrong, and what am I doing right ? Q2: If I have to unlock it, how do I re-lock it ? Or does it stay locked if I don#t save it ?
Publisher
I understand that Publisher will be removed from 365 in 2026 with the aim to incorporate it's features in Word. I love Publisher and before I had 365 I had a paid version. I use it for newsletters, crafts, knitting patterns, and photo albums. The things I most value are being able to crop and resize images, move text boxes around for best fit, adding effects like shading and wordart, and importing images. I'm not sure that these features could be available in Word so I'm looking for opinions on alternatives. My 365 version of Publisher has become very "buggy" recently with many "not responding" messages, and I don't want to try uninstalling if I can't get it back. It doesn't show as an option in the current list of apps included with 365. Can I buy a paid version of Publisher? Would this be supported going forward? Is there an alternative to Publisher that gives me the features I need and is compatible with my existing .pub documents? I'm not looking for a professional package, it's only for occasional home and hobby use, so a subscription model would be unaffordable and unnecessary. Alternatively, would Microsoft be able to assure me (and others like me) that they can incorporate Publisher features into Word or another app?How to split Excel file into multiple files?
I’m facing an issue with a very large Excel workbook and need some help. The file contains thousands of rows of data, and now it has become extremely slow to open, edit, and share through email. Sometimes Excel even freezes while working on it. Because of this, I want to split the Excel file into multiple smaller files, but I’m not sure how to do it properly without losing formatting or data. I tried manually copying rows into separate files, but it is taking too much time and there are chances of missing important records. I also searched online for solutions, but most methods seem complicated or only work for small datasets. This Excel file is very important for my office work, and I need a reliable way to divide it into multiple files based on rows or column values. If anyone knows an easy method, VBA solution, or any trustworthy tool that can split Excel files automatically, please share the steps. Any help would be greatly appreciated!
Recent Blogs
- Access now lets you zoom in and out when you’re working with forms, tables, and queries in Form View or Datasheet View. Zoom in for a closer look at your data or zoom out to see more on screen at onc...May 19, 2026
- Learn about improvements that make reviewing and fixing spelling and grammar issues faster, clearer, and more efficient.May 19, 2026
