Recent Discussions
PowerPoint NEW Image Editing Tools Explained — Remove Background, Upscale & Edit Images Instantly!
🚀 PowerPoint just received one of its most powerful updates ever! Microsoft has introduced a brand‑new built‑in image editing experience, allowing you to enhance visuals without leaving PowerPoint. In my latest YouTube video, I walk through all the new capabilities now rolling out in Microsoft 365, including: ✨ Remove background 🧽 Erase unwanted objects 🔄 Move elements inside an image 🔍 Upscale low‑resolution pictures ⚡ Auto‑enhance lighting & contrast 📝 Add or edit text directly on images All of this happens directly inside PowerPoint, making slide creation faster and more intuitive than ever. These features are now available on: 💻 Windows 🍎 Mac 🌐 PowerPoint for the Web If you work with presentations daily, this update is a real productivity boost. 📹 Watch the full breakdown and demo here ➡️ https://youtu.be/OZzfFi2qpAk Let me know what feature you find the most useful! 👇 #Microsoft365 #PowerPoint #Productivity #AI #Presentations #Microsoft365Insider #Creators
Problem: Excel opened the first file quickly, but the second and subsequent files very slowly
Problem: Excel opened the first file quickly, but the second and subsequent files opened very slowly when launched externally (double click from Explorer or using excel.exe "file.xlsx"). Environment: Windows 11 Pro 25H2 Office 2021 Pro Plus Clean Windows installation Clean Office installation Modern hardware (Intel 13th gen + NVIDIA RTX) Symptoms: First Excel file opened fast Second and subsequent files became progressively slower Opening files from inside Excel was always fast Drag & drop from Explorer into an existing Excel window was fast Word did NOT have the problem Reinstalling Office did not solve it Disabling Defender, Protected View, StartAllBack etc. did not solve it Cause: Registry DDE handler related to Excel shell open behavior. Registry key: HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec The (Default) value was empty. Fix: Set (Default) to: [open("%1")] Then reboot Windows. After that: multiple Explorer launches became instant again no more progressive slowdown Excel external opening worked normally again Important note: On other healthy machines the value may still appear empty, so the fix may actually force Windows/Excel to rebuild or refresh the COM/DDE association/cache rather than the value itself being universally required.How to Find Inactive (Stale) User Accounts
Inactive accounts can soak up a lot of paid-for but unused product licenses. With increases for Microsoft 365 licenses due to come into effect from 1 July 2026, it’s time to find and remove unused licenses from inactive user accounts. We discuss two approaches by using the Microsoft 365 Licensing Report or a PowerShell script that assesses inactivity based on sign-in dates and refresh token baselines. https://office365itpros.com/2026/06/09/find-inactive-accounts/
Excel 365: Unexpected Predictive Behaviour Causing Retroactive Cell Changes in Structured Dataset
Hi everyone, I’m posting this to share an unusual and potentially important issue I encountered in Excel 365 this morning. I’ve already submitted a detailed report to Microsoft via the Feedback Hub, but I felt it would be useful to document it here for visibility and to see whether anyone else has experienced something similar. While entering data into a structured table (a parts‑catalogue workbook), Excel began exhibiting behaviour that did not match Flash Fill, AutoFill, or the standard predictive typing feature. Specifically: Grey predictive text appeared beyond the cursor and extended into cells below the active cell Excel began rewriting previously validated cells in the same column Each time I pressed Enter, Excel updated earlier rows based on its latest inferred pattern Attempts to correct earlier rows caused further cascading changes Undo did not revert all changes The behaviour resembled an AI‑style inference engine trying to “learn” my pattern, becoming progressively more confused This was not the normal predictive typing behaviour (which only shows grey text inside the active cell and does not affect other cells). The behaviour stopped only after I clicked the Flash Fill button twice, which suggests an internal state reset. I’m not seeing the issue now, and other workbooks behaved normally, so this appears to have been a transient internal mode rather than a persistent setting. I’m sharing this here because: it caused silent data corruption in a structured dataset it may indicate an experimental feature or feature‑flag activation others working with structured data may want to be aware I’d be interested to know if anyone else has seen similar behaviour If helpful, I can provide the reproduction steps, screenshots, and the engineering‑style report I submitted to Microsoft. Thanks, John
Error on regression analysis
Hello everyone, I want to perform a regression analysis on my survey data, but I keep getting this error message: “Regression - The RGP() function returns an error value. Check the input ranges.” I’ve since figured out that it’s due to a specific row, but I couldn’t find any incorrect numbers, letters, or anything else in it that would trigger this message. Does anyone know what might be causing this and how I can fix the problem? Thanks in advance!Put a specific word in a cell based on the word in another cell
Hey everyone, I need help automating the categorisation of my bank statement in excel. I do not have microsoft 365. I want excel to look for specific words from my transactions eg Woolworths or McDonalds and then based on that, put another word into the categories cell. For Woolworths I want it to populate groceries, for McDonalds I want it to populate Eating Out. Etc. I would really appreciate the help and in the most basic way possible. I only use basic formulas, so array formulas are quite foreign to me. I have tried googling and nothing seems to work quite right. Happy to move columns around, but would prefer to keep Date, Amount & Description next to each other as that is the order from my bank statement download. I also don't need the Merchant / Category section in notes, but previous attempts led me to adding them. Thanks
Help with Formular to keep constants
Hi I have 2 rows for percentage values as per this table. C3 will be the value of (C2 + B3) / 2. However I need to check for an empty value so my calculation is =IF($B$3="",0, IF($C$2="",0,($C$2+$B$3)/2)) - I hope that is right, A B C D E F G 1 Name Name Name Name Name 2 50.25% 70.78% 60.14% 24.86% 53.64% 3 Name 60.12% 55.18% 65.45 4 Name 45.58% 47.91% I then need to copy(drag) the cells across and down and provide the correct values, so it uses the same top value and left value. For example D3 will be =IF($B$3="",0, IF($D$2="",0,($D$2+$B$3)/2)). C4 will be =IF($B$4="",0, IF($C$2="",0,($C$2+$B$4)/2)) and so which will alter as I drag down or left and it keeps using the correct column value and row value based on what column/row it is in. What I am doing now does not retain the right column or row value. I hope I make sense. Thanks.
Summarising a number of sheets to a front sheet.
I have a simple spreadsheet with Sheets for individual investment details. The TABS contain the name of the investments eg BP I am trying to put together the front sheet summarising certain data from the individual sheets, one row per sheet. Data such as Investment Name and Value. How can I do this please?LAMBDA : function generating #NAME error
Hie, I juste discovered Lambda function, and i have a problem. I created a lambda function that compute a cubiqual polynomial with the code : Poly3:=LAMBDA(_a, _b, _c, _d, _x, ((_a*_x+_b)*_x+_c)*_x+_d) Excel accepte de function, but when putting the function in a cell, it generate a #NAME error. I Debug the Cell, and it seems that de fith argument is refused, with #NAME error ! but the data pasted to the function is a basic computed value ! I don't see anithing rong in my function. Does anyone have an idear, or explaine me what rong in this code ?
MATCH formula anomaly?
Can anyone explain this? If I simply type 490.44 and then calculate 490.44 as 490.44/40*40 (or even directly B3/40*40) excel recognizes both as equal through a simple A=B calculation yet not with a MATCH calculation. What is more odd is any other number I use does not cause this error...Regression in v2605: Subform with overlapping controls breaks timer in unrelated form
I found another issue (sorry) which might be caused by the zoom-related changes in 2605. The following repro example works fine in 2604 (Monthly Enterprise Channel) but breaks in 2605 (Current Channel). Again, this issue is unrelated to zooming itself. Prepare database The repro requires three forms and a few controls. Since those are tedious to get right manually, I wrote some VBA code to do that for us. Execute BuildRepro() in the Immediate Window to create the forms and controls. Option Compare Database Option Explicit Public Sub BuildRepro() CreateFormASubform CreateFormA CreateFormB End Sub Private Sub CreateFormASubform() Dim frm As Form Dim ctl As Control Set frm = CreateForm() Set ctl = CreateControl(frm.Name, acTextBox, acDetail, , , 345, 1140, 1746, 260) ctl.TabStop = False Const textBoxTop = 260 Set ctl = CreateControl(frm.Name, acTextBox, acDetail, , , 56, textBoxTop, 270, 270) ctl.TabStop = False Set ctl = CreateControl(frm.Name, acImage, acDetail, , , 56, 0, 270, 270) Set ctl = CreateControl(frm.Name, acCommandButton, acDetail, , , 60, 795, 5895, 260) SaveAndClose frm, "FormA_Subform" End Sub Private Sub CreateFormA() Dim frm As Form Dim ctl As Control Set frm = CreateForm() Set ctl = CreateControl(frm.Name, acSubform, acDetail, , , 100, 100, 3000, 3000) ctl.SourceObject = "FormA_Subform" SaveAndClose frm, "FormA" End Sub Private Sub CreateFormB() Dim frm As Form Dim ctl As Control Set frm = CreateForm() frm.TimerInterval = 1 Set ctl = CreateControl(frm.Name, acLabel, acDetail, , , 100, 100, 5000, 1000) ctl.Name = "my_label" ctl.Caption = "Waiting for Timer..." frm.HasModule = True frm.Module.InsertText _ "Private Sub Form_Timer()" & vbCrLf & _ " Me.TimerInterval = 0" & vbCrLf & _ " Me.my_label.Caption = ""Done""" & vbCrLf & _ "End Sub" frm.OnTimer = "[Event Procedure]" SaveAndClose frm, "FormB" End Sub Private Sub SaveAndClose(ByVal frm As Form, ByVal newname As String) Dim oldname As String oldname = frm.Name DoCmd.Save acForm, oldname DoCmd.Close acForm, oldname DoCmd.Rename newname, acForm, oldname End Sub Run repro 1. Open FormA. 2. Open FormB (while FormA is still open). Expected result: FormB opens completely, the timer runs and the label reads "Done". Actual result: FormB opens "halfway" (it's visible, but it's tab is still missing, see screenshot below) and the label still shows "Waiting for Timer...". As soon as you right-click anywhere, the form finishes opening and the timer runs, changing the label to "Done". Notes: I tried to make the repro as simple as possible. If you remove one of the controls from FormA_Subform (or enable TabStops), the problem disappears. It might have something to do with overlapping controls: If you change textBoxTop from 260 to 280, so that it no longer overlaps with the image, the problem also disappears. We need the overlapping controls because in our real code the subform is continuous and displays data at different indentation levels (like a treeview).Microsoft Extends Sensitivity Label Block for Connected Services
The BlockContentAnalysisServices sensitivity label setting blocks access to Microsoft connected services for the content of labeled Office documents. The intention is that users assign sensitivity labels with the block setting to protect an organization’s most sensitive files. Regretfully, Microsoft’s documentation and explanation offered in the message center post don’t convey a clear story about its value. https://office365itpros.com/2026/06/08/blockcontentanalysisservices-label/Availability in MS Bookings not correct
In our bookings portal, we set-up a service with 2 staff assigned. The first staff memeber is available, the second one is on holiday (time off) We have made this set-up in the back-end. If there is a booking on that day already sheduledfor staff number one for let's say 10h, It will still show this time on the front. It looks like it doesn't count the time off from the second staff
Excel 2016 Workbook Printing Double Sided problem
I got a new Windows 10 computer. Previously, I have used Excel 2016 with no issues. What I need to do is print a workbook in Excel (multiple worksheets) double sided. For example, sheets 1-3 are on one tab, while sheet 4 is on another. When I print, I would generally click, "print entire workbook" which then takes my document from 3 pages to 4. Pages one and two print double sided no problem, but no matter what I do, pages 3 & 4 will not print duplex. Other than printing to pdf (which saves it, then I have to open that document and print from there which is a PAIN), can I print those 4 pages onto 2, or am I stuck? I have searched the internet to no avail. Thanks!
Recent Blogs
- Pin, Snooze, Sweep, and more features can help you organize your inbox and work more efficiently.Jun 05, 2026
- Bug Name Issue Fixed Edge Browser Control didn't render PDFs on some machines When the Edge Browser Control was used to display a PDF, on some machines the PDF would not render...Jun 03, 2026
