Recent Discussions
OneNote vs. OneNote for Windows 10
I received an email this morning reminding me of the impending end of support for the OneNote for Windows 10 app. As I do periodically when I am reminded about this, I launched the OneNote on Windows (OneNote M365) app and lamented how much less user friendly it is than its doomed cousin. The lack of a "Recent Notes" view is my biggest gripe, but the awkward "pop-over" search comes a close second. The tabs and search result are on an ugly grey background and everything is just slightly too small to read comfortably. Am I the only one?
Insights from Copilot have stopped working for us
We're all licensed (verified) with M365 Copilot, and for about the last week, one of our workhorse intake forms has stopped working with regards to the "Insights from Copilot" feature. When we attempt to refresh the insights, it presents the message, "Your form has XX responses. Copilot is analyzing the data to provide insights.", then spins for about 30 seconds, and then presents the error, "The insights haven't been generated successfully. Please try again." We're syncing responses to an Excel workbook, and that seems fine, but after about a week these "insights" just started failing in this fashion. We've done basic troubleshooting like trying InPrivate browsing, cache clearing, and since we are only at about 100 responses for this particular small form we're not hitting any limits. Regardless, it's wedged stuck in this state. I reported it via the M365 Admin portal and received the usual "No issues found" reply. 🙄 Anyone else seeing this problem? Does anyone actually use this feature? 😜
How to write a script or any PQ or in Excel to download the zip files from a Webpage
Dear Experts, Greetings! https://www.etsi.org/deliver/etsi_ts/138300_138399/138306/ Could you please help me on how to download the pdf.zip files from above for all the versions? Using a single command in Excel or PQ-option. Thanks in Advance, Br, Anupam
Excel toolbar format
Hello everyone, I personalized my toolbar with the shortcuts I use the most but the format of the icons varies quite a lot as shown on the picture above. Some icons are small and others are big. Is there any way to choose which ones are small and which ones are big? Or maybe make them all the same (small or big). Version is Microsoft Professional 2021 Thank you for your timeNon-Consecutive Cell Referencing
Hi, folks. I'm attempting to create a spreadsheet that contains links from consecutive cells to consecutive cells in another worksheet that are separated by 5 intervening cells. I'll call the original consecutive spreadsheet "Orig" (for original). So, I know that if I put "='Orig'!A3" in cell B3 and then copy that down, it will update the relative formula consecutively, i.e. B3='Orig'!A3, B4='Orig'!A4, B5='Orig'!A5, B6='Orig'!A6.... that much I get. What I need to do is find a way to do the same thing, but to increase the resulting link.....so that if I copied the formula down column B I would get: B3='Orig'!A3, B8=Orig'!A4, B13='Orig'!A6', etc so that the new worksheet is moving down 5 cells relative to the Orig sheet consecutive order. I've read where someone used a formula using the INDIRECT function but that's beyond my beginner level. Many thanks, and merry Xmas to all!
Downloads for Office Home and Student 2019 for mac air m4
Hi All, I am upgrading my laptop from Windows to Mac and I have licence of MS Office 2019 Home and Student edition. However I am not finding the download for it in offical pages. I understand the support and fixes for 2019 is alreay over. However I still would like to use it. How can I downlaod the installables for mac for office 2019?
Sumifs with Custom Excel Data type from power Query and using dot notation
I am just experimenting with Custom Excel Data Types and dot notation. I was trying to come up with a equivalent to sumifs without any luck. In my example I use fake data and I am trying to summairze charges by team color and department Here is a drop box link to my spreadsheet Here is the expected outcome Yellow Red Green Purple Orange Red Feet 1,384,281 1,067,303 884,288 1,112,979 1,005,634 1,167,165 Hands 1,267,428 1,262,445 827,956 963,616 1,041,856 902,571 Hip 946,395 948,135 955,020 799,842 1,014,142 829,546 Knee 991,524 1,072,020 953,689 1,139,318 1,218,487 1,001,327 Spine 933,123 1,373,616 910,488 795,726 860,861 1,019,545Microsoft Tenant-to-Tenant Migration Orchestrator
Microsoft has launched a tenant-to-tenant migration orchestrator solution in public preview to migrate mailboxes, OneDrive accounts, and Teams chat between tenants. ISVs have been active in the T2T space for a long time. They probably won’t welcome the new Microsoft offering, but at least the migration orchestrator legitimizes the concept of tenant-to-tenant migration. https://office365itpros.com/2025/12/19/tenant-to-tenant-orchestrator/
LitigationHold Delayholdapplied and Managed Folder Assistant
Hello All, I have a set of mailboxes with LitigationHoldEnabled = True, and I need to remove Litigation Hold from them. My understanding is that after I remove Litigation Hold from an Exchange Online mailbox, the next time the Managed Folder Assistant (MFA) processes the mailbox, it will detect the hold removal and then set DelayHoldApplied = True. This begins the 30-day delay hold period. My question is: Will any retention policies delete data in the time window between removing Litigation Hold and the moment MFA processes the mailbox and sets DelayHoldApplied = True My understanding is "Even though DelayHoldApplied is not yet visible (or True) before MFA processes it, Exchange Online automatically protects the mailbox from deletions immediately after hold removal, before MFA applies Delay Hold" I want to ensure that no data is deleted during this transitional period. Kindly advice with supporting article if possible. Regards Afsar
What is the best way to collaborate between two organizations with Teams?
Hello, I have a Microsoft 365 Business Standard account, and I am the administrator (currently, my Microsoft 365 organization only has one account, mine). I want to configure my Teams account to collaborate with members of another organization who also use Microsoft 365 Business. I have tried several solutions, without success. My goal is to be able to chat online, schedule and organize virtual meetings, and share documents online with members of the other organization via Teams. What is the best way to set up simple and intuitive collaboration between two organizations using Microsoft 365 Business? Thank you in advance for your help.Finding time duration between a start date & time with end date & time
Hi all! I'm looking for any formula or power query to calculate a total time duration within a day, given the start date, start time, end date, end time. Most of the dates will equal the same but there are some with the end date being the next day. I'd like to be able to exclude any overlaps as well. Currently, I have a large embedded IF formula: =IF(AND($G4=$O4,$H4<$H5,$P4>=$H5,$P4<$P5,$H4<$H3),$P4-$H4,IF(AND($G4=$O4,$G4>$G3,$H4<$H3,$P4<$P3,$H4<$P3,$P4<$P5),$P4-$H4,IF(AND($G4=$O4,$H4>$H3,$H4>=$P3,$P4>$P3),$P4-$H4,IF(AND($G4=$O4,$H4=$P4),0,IF(AND($G4=$O4,$H4<$P3,$P4<=$P3),0,IF(AND($G4<$O4,$H4<$P3,$P4>$H4),($P4+1)-$P3,IF(AND($G4=$O4,$O4<$G5,$O4<$O5,$H4<$P3,$P4>$P3),$P4-$P3,IF(AND($G4=$O4,$G4>$G3,$H4>$H3,$P4>$P3,$H4>$P3),$P4-$H4,IF(AND($G4=$O4,$G4<$O5,$P4>$P3,$P4>$H5,$H4>$H3,$H4<$H5),0,IF(AND($G4=$O4,$O4=$G5,$H4<$P3,$P4>$H5,$P4>$P3,$P4>$P5,$P2>$P3),$P4-$P2,IF(AND($G4=$O4,$H4<$P3,$P4>$P3,$P4>$P5),$P4-$P3,IF(AND($G4=$O4,$H4<$P3,$P4>$P3,$H4<$H5,$P4<$P5),$P4-$P3,IF(AND($G4=$O4,$H4<$H5,$H4<$P3,$P4>$P3,$P4>$P5),$P4-$P3,IF(AND($G4=$O4,$O4=$G5,$H4<$P3,$P4>$H5,$P4>$P3),$P4-$P2,IF(AND(ISBLANK($O4),ISBLANK($P4)),0,IF(AND($G4<$O4,$H4<$P3,$P4<$H4),($P4+1)-$P3)))))))))))))))) This seems to work for the most part but there are a few that I just can't get. I also pulled up my query and started to enter in the time durations manually and it couldnt come up with anything automatic for me. There must be an easier way for me to do this other than trying to create an IF formula for each answer that turns up incorrect. I have a screen shot below.My Percentage of total sales is not 100 - Why?
I have 20 categories of Sales Revenue in Column A, the total revenue for each category is in column B, the % of a category, as it relates to the total categories is in column C but the Total Percentage is over 100% when I total all the percentages, what am I missing? Amount % of Sales Backup & Recover-Desktop Suppor 70,808.50 2.2% Barracuda Back Up - Cloud to Cloud 11,220.00 0.35% Barracuda ESS - Security Edition $51,508.57 1.62% Barracuda Sentinel 20,093.52 0.63% Carrier Management / NOC Support Services $239,618.99 7.54% Cust Support Srvs/Provisioning/vCIO Svcs $98,514.00 3.10% Field Services Support-Single $1,447,941.00 45.56% FTE Tech 159,227.50 5.01% Hardware Lease Revenue 11,114.22 0.35% Help Desk Services 1,604,649.85 50.49% IH-New User_Laptop Setup $230,523.19 7.25% IH-Remote Work Support Services 60,172.85 1.89% MRR - Data Services/Ticket Overage $40,057.00 1.26% Network & Security Hardware $985,825.90 31.02% Network Monitoring Service-Devices 153,696.60 4.84% NRR - Carrier Management / NOC Services 11,245.00 0.35% NRR - ESS Email Security Services 28,865.00 0.91% NRR - Help Desk 46,500.00 1.46% NRR - Migration Implementation 98,595.00 3.10% NRR - Monitoring Services 15,000.00 0.47% Remote Server Monitoring 102,455.03 3.22% Remote Work/Sharepoint Migration $84,026.55 2.64% Shipping & Delivery Fee 49,970.63 1.57% Software/Licenses 491,422.97 15.46% TOTAL $3,178,015.20 192.35%If calculation returns a negative number, then it needs to be a 0; 2nd part is to show Max number
1. For row 45, I have calculation for 30% of row 42 ex. =F42*.30. If the result is a negative number, then I would like it show a 0 instead of the negative number. 2. Next, for row 48, the result of =F9-F45 can be no greater than F9. So if it is greater than F9, then F9 is the highest number that it should show, in this case $281, but should still show values 0 up to the amount of F9. Thank youHaving Trouble With Macros
Hi! I have been having trouble with my macros. I followed all the steps on enabling them however, when I try to use macro functions on my excel sheets (like changing font colors, adding border, etc) I am unable to do so and my computer adds these arrow keys instead. I am honestly unsure of what to do since I keep exiting and re-entering excel and the same issue persists. If anyone can help that would be great!
Excel formula help... again!
I have different tabs for each month. I need the total of the last day of month to start in the opening balance on the next tab in the beginning of the month. but some months obviously has 30 days and some 31 and then there's Feb too doing whatever it wants ;-) the total here in AH has to be the last day of the month - here it's the 30th and 379 the opening balance for the next tab (yellow block) has to be whatever the previous month's closing total was. I don't know how to create a formula to choose the last day's total and pull it to the new sheet in the opening balance. Thanks so muchEm Dash short cut not working in Word
I am using Windows 11 Pro on my Lenovo P14 laptop, and Windows 11 on my HP Pavillion x360. I often write in Word and insert Em dashes. CTRL+ALT+"-" (shortcut). Both machines have this setting automatically in Word's built-in shortcuts, however the Lenovo machine ignores the shortcut sequence and inserts nothing (the HP works fine). I have reinstalled the OS and Office Pro 16 MS Word on Lenovo, and nothing helps. Any suggestions?Multiple word documents are open simultaneously causing performance issues.
Does anyone know what the optimal size of Word documents should be if you have multiple word documents open simultaneously? I frequently access two Word documents at are about 800KB each. When I have both open, I notice a significant performance degradation when I do searches, add/modify/delete contact, toggle between the documents. This really impacts my productivity. I am wondering I should reduce the size of these files or move them to a different drive or memory stick to improve performance. I don't want to break these documents up yet given that instead of having two Word documents open, I might have four Word documents open simultaneously and still have the performance issues. I have performed online repairs of Microsoft 365 and checked my addins but nothing seems to help.
Recent Blogs
- Powered by Microsoft 365 Copilot, Explainer offers instant summaries and explanations of text.Dec 19, 2025
- This update to Microsoft OneNote on Windows gives you more flexibility over proofing languages in your notebook pages.Dec 16, 2025
