Recent Discussions
Automatically adding the date/time to a cell when another cell is updated
I am trying to create a spreadsheet where when a specific cell is updated in anyway, the date/time stamp automatically updates in the cell right beneath the cell that was updated. I only need to have a one to one relationship with multiple cells. IOW, I have 5 cells in a row going across. When any one of the 5 cells is updated, I want an updated date/time stamp to appear in the cell directly below the cell that was updated. Is there a way to do this?
Top n vs. Others in Excel
Hi all, I'm seeking some help because I'm kind of new to the more intermediate stuff in Excel. I have an Excel table with the following columns: Subcategory in column A, Brand in column B, Region in column C, Year in column D and Values Month in column E. I want to create a PivotTable and a Pivot line chart from this PivotTable that ranks the Top 5 Brands vs. Other Competitors by each region. For added context: There are 5 subcategories, 3 regions and 25 brands. Currently, I've tried grouping the remaining 20 brands as "Other Competitors" vs. the Top 5 brands within a selected region and possibly all regions (when no selection is made). I'm seeking a solution similar to this... Please mind the colours. I will sort those out later. But, the problem that I'm faced with is that upon selection of a region, the PivotTable won't update to the Top 5 brands of a selected region because they've already been grouped. How can I make this more dynamic so that I'm able to show The Top 5 brands vs. Others? Please help. EDIT: My operating system is Windows 10 (64-bit) and I use Excel 365 (Desktop version). For reference, I've attached a link to a sample file. https://1drv.ms/x/c/b2d878e32a062614/IQC1wcnwLICcQasOfnGcwKn0ASjpXp9xQ6rjnOP10Jal5cc?e=HaXEWd Thank you all once again.
I haven't seen anyone talking about this online store
There is this office and windows key store called esd codes and they sell office keys. They seem legit since they're affiliated with Microsoft and they have mostly positive reviews but I the description of every office key and I mean every has a note stating "if office (literally every single one) version is not available, you will receive the Professional Plus version at the same price" which they are trying to make it look like an upgrade but from what I searched the professional plus versions are bought in bulk by big companies and organizations and after they stop being updated they are being sold for cheap probably by employees. I have found multiple for less than 2 or even 1 buck and I feel they are scamming people.
Bookings - No more notes or extra fields available
Hi there and happy new year to all. Starting from mid-december, we are facing an issue with our company Microsoft Bookings: basically the custom fields (like address, notes and so on). The book page will just ask for Name & Surname, E-mail Address and Phone Number. On our Administration back-end, the Customer Notes fileds is greyed out (you cannot enable it), and all the custom fields disappeared, you have just the standard ones. We have this issue in all our different booking pages, and all the services are affected. Any hint about this? Thanks!A Method to track current and upcoming changes to M365 Products
Good evening (from Ireland at least), I've spent most of today traipsing down a variety of dead-ends and soon-to-be-discontinued features looking to create a useful location where I can find/send all new updates to products that I can peruse and ultimately highlight ones that may be of particular importance in my organisation. I've had a long chat with Copilot today and while I've made significant progress in some areas (had upwards of 30 great questions according to Copilot! ;P), when it comes to the final product, there's always some missing connector, or some RSS feed that is no longer supported. What I'm looking for here is any input on how you manage to stay ahead of changes and I'll share everything I'm doing and have learned as well, in the hope that the discussion is somewhat mutually beneficial. What I do: Message Centre: Manually check the Message Center (under Service Health in M365 Admin Center). You can sort by product here and by relevance which is quite handy. Link: https://admin.cloud.microsoft/?#/MessageCenter (Access to the M365 Admin Center on your tenant is required for this). Today I found out you can also send emails to yourself (and Teams channels) here so awaiting the next message to see if this has worked. Unfortunately, there doesn't seem to be a way of migrating past messages over so I'll have to go through these myself first. Road Maps: These have been the bane of my day. Currently, I actively check the road maps of the products I manage but going forward, I'd like to be able to track major changes to products used in my organisation so I can give users a heads up. I initially tried Power Automate to send updates to myself, however, it's not a feature widely used in our org yet and isn't well supported, so I wasn't too surprised when my efforts were blocked by existing policy. Not long after, I found RSS feeds, which seemed to be the answer to my problems. I created RSS Feeds for each of the Road Maps that I found useful, assured by Copilot that these would work. The assurance wasn't fell founded however as, true to form, once I showed Copilot by errors, they remembered that they were there all along! :') I'm yet to find a useful solution here beyond my current efforts so any assistance would be greatly appreciated. Community Blogs The final recommendation was these Community Blog posts which, to be fair, I've had immense success with to date. However, there is a slight issue with filtering. While I did finally get the RSS Feed to work on something (the Tech Comm M365 RSS Feed), it did then proceed to send me a mass of emails on every topic under the Sun & Moon. I've decided to return to the drawing board tomorrow with this, but I'm content in knowing that RSS isn't just a myth at least. I think what I'd like here is just to receive notifications when approved Blogs are posted (i.e., Monthly OneDrive Updates and the equivalent for other products). OneDrive Office Hours: This is a fansastic resource I do use every month as it gives you the opportunity to get in contact with the people who know the most about the product and the issues you're facing. I've spent weeks in a ticket before, only to raise it in one of these meetings and get a solution that took half an hour to set up. You'll get a yes or a no, but at least you'll have an answer. Copilot Chat: I don't have the full Copilot license because I haven't had a need for it yet. Everything I've wanted to do, I've been able to do in Copilot Chat. We haven't yet looked too much into Agents, and as a Public body, aren't going to rush into it until we know it's viable and can be supported. In the interim, I'm happy to test the waters with Copilot Chat asking it for Monthly Summaries on a variety of products, time frames, etc. It isn't perfect but it's faster than I am. It can find the sources for me and I can take it from there. As an organisation, we'll be pushing out all users on the most recent version (-1) on the Monthly Enterprise Channel. This means that they'll be supported whilst also being shielded from any brand new features. Our team will be on the most recent version and will be able to note any upcoming changes ahead of time. These are what I'm using so far but would be very grateful for any further input. Thanks in advance, Chris MartinSharePoint Site Administrators Can Now Control Restricted Content Discovery
Restricted Content Discovery (RCD) is a feature that blocks access by Microsoft 365 Copilot and agents to the files stored in a SharePoint Online site. Instead of relying on tenant administrators, site administrators can now enable or disable RCD. It’s a natural evolution of what is an essential feature to keep sensitive and confidential information being leaked inadvertently by AI. https://office365itpros.com/2026/01/13/rcd-site-level/Web-Addins stopped working for Office apps version 16.100 for Mac
Dear experts, Since version 16.100, the web add-in functionality has stopped working with the Office apps for Mac (PowerPoint, Word and Excel). In may case, Templafy web add-in is not being loaded. According to Templafy's support page: https://support.templafy.com/hc/en-us/articles/29028257609501-Templafy-Web-Add-ins-no-longer-accessible-on-Mac-after-Microsoft-Office-update-16-99 this seems to be a bigger issue. Clearing web add-in cache or deleting the WEF folder will not resolve the issue. I have also tried with a full clean uninstallation of Office365 apps and re-installation, same issue. Note that New Outlook for Mac is not affected, just PowerPoint, Excel and Word.
Excel crashes whenever file tab is clicked
I have been having a lot of issues with Excel on a vm that we use, and I cannot try and fix these issues due to not being able to click on the file tab. Whenever the file tab is clicked, excel freezes and if anything clicked again goes to not responding. I do not get anything from windows diagnostics. I have also reinstalled Office 365 several times and excel always has this issue. the VM is a 2019 data Center and excel is 32 bit. running in safe mode does nothing. Book.xltx or Sheet.xltx is not in the XLSTART folder, if it was, I would have to wait for plant downtime to restart the vm. Deleted the excel key in HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel, restarted excel and issue still persists.
How to separate non-indented number points from indented number points?
I'll explain. I have a document that's about fifty pages in length, with about 500 numbered points in total. The list randomly is dispersed going down, with some numbered points having no indentation while some have it (text down and to the right, down to the right and so on). It looks like this: Example 1 (Actual Layout): This Is An Example How The Document Is Listed Trying to sift through it all and sort the list manually is proving to be too time consuming. Trying to sort the lists alphabetically left all the indented text out of order with no way to figure out what numbered point it belonged to what. It looked something like this: Example 2 (Alphabetized Layout): An Document Example How Is Is Listed Of The This Is there any way to have it so word can separate Example 1's points, 1, 4, 5, 6, and 7 and points 2 and 3 away from each other, creating two separate lists with all the indented numbered points all corresponding to the correct main indented point? Like this: Example Three (Desired Layout): This Is The Document Is Listed Is An Example How Thanks. Sorry for the length.
PLEASE HELP ME. Excel Time Formatting Not Working?
PLEASE HELP ME!!! I created an excel workbook for tracking fitness workouts, I record the data such as weight lifted, number of reps, and rest times between sets. I formatted the cells so they express your rest times in terms of minutes and seconds (I used the custom "H:MM" format of time option). But whenever I record the amount of time you spend during cardio exercise, the formatting gets COMPLETELY SCREWED UP because when I type 28:44 (28 minutes and 44 seconds) of cardio duration, it instantly turns into 4:44 (4 minutes and 44 seconds). But if I type 20:00 (20 minutes) of cardio duration, it stays as 20:00 (20 minutes) and it never turns into something else. Why do some of the numbers like 28:44 transform into a complete different number when I enter them? I uploaded 3 screenshots below to better express what I mean. '
Intune Kiosk setup steps
I'm using intune to create a kiosk mode machine but im finding I have to perform a few pre config tasks first before applying the Kiosk Profile. For example. I have a kiosk profile template created that uses a kiosk template adding multiple apps. I also want to add some shortcuts to websites on the desktop along with the tiles for the applications. To do this I used a PowerShell script using Scripts and Remediation. I'm finding I have to do it in following stages: Install the apps before applying the Kiosk Profile Apply the kiosk profile Run PowerShell script under the kiosk profile to add the shortcuts Anyone know a way to run this as an all-in-one configuration?Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team365 Tenant To Tenant Migration
I have a tenant who is not set up to be GCC compliant. We have created another tenant that is now GCC compliant and need to move the tenants from the original tenant to the newly created GCC compliant tenancy. I am not sure how we can go about doing this with the destination and origination having the same domain name. I have created the users with the onmicrosoft accounts, instead of the .org users, but we still have the issue of migration. How do we move these users? What is the expected down time for their domain if we use a dummy domain? I am very concerned this is going to result in a massive loss of data.
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- Ask Copilot for tips to help you organize your workspace, your home, or your digital files.Jan 12, 2026
- 3 MIN READHere’s a look at how OneDrive evolved in 2025!Jan 09, 2026
