Recent Discussions
Word Document - Projector screen and Monitor Screen
Hi, I am not sure if I can get any best recommendation here. We have a document (usually converted into PDF) that the management used during meetings. The presenter will show it on the big screen via projector in front of a big audience as well as on his wide in a small audience. In the past, the document is using paper size A4. I am not familiar with such projector and screen settings but according to the presenter, the screen (both projecter screen and on his wide screen), the visual does not fill up all the screen space. The new presenter does not like it this way. He wants us to find a solution to get the document "Stretch" or "Fill" up the entire screen (whether projector screen or any wide screen he uses). A stupid idea is to use a custom paper size 16 inches by 9 inches in Word for it....but even that it does not ensure all projector screens and all monitor screens will fit. Therefore this is not a dynamic solution, plus it will messes up all the formatting (example columnal layout width and table width etc) copied from the old A4 file. Does anyone know a good solution for the above request?
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.Purview eDiscovery Simplifies Content Searches in February 2026
As part of the modernization of the Purview eDiscovery solution, Microsoft will simplify the content searches UX in February 2026 to remove features that are inappropriate for the way that content searches are intended to be used. The change is logical and reasonable because you should use a full eDiscovery case to access all the eDiscovery functionality. https://office365itpros.com/2026/01/15/content-searches-change/
Dynamic array formula call with spill range input parameter crashes Excel; legacy array call works
Hi, I have a workbook with a dynamic range formula call referencing a spill range that worked last week but is suddenly causing excel to crash this week when using a full worksheet re-calc on a specific machine. This workbook works on multiple other machines but something on that machine is causing this formula to break. 1) Excel version is 2211 (Build 15831.20208 Click-to-run). I have tried an excel repair already on that specific machine. 2) Shift+F9 on the offending worksheet hangs excel with the status bar showing: "calculating (spill resize pass 1)" stuck at 66%. Pressing escape allows me to regain control, but a subsequent Shift+F9 crashes the excel process entirely. 3) The legacy Ctrl+Shift+Enter method of using the formula with a defined output range allows Shift+F9 to work on that worksheet without any issue. 4) Calculating the rest of the page separately without the offending formula, then inputting the offending dynamic range formula also works. 5) Other machines on the identical version of Excel recalculate the sheet instantaneously. 5) I've tried to disable things such as endpoint security services to no avail. Is there anyone who has encountered this behavior before and/or can tell me how to diagnose better the issue?Display Last Value in Column when certain criteria match
Hello all, I am trying to find a way of displaying the last value in a column when certain criteria match... Criteria that need to match would be Design, Colour and Size, so the quantity column would populate with the latest stock quantity: Thanks all! Michael
Help with Excel Sorting
Hello! I am looking for help with sorting data on a sheet with form responses to different excel sheets. I want to filter by column G to different sheets ("Near Miss", "Adverse Event", "Sentinel Event". The data automatically goes to sheet1 via form responses, but I am trying to streamline the data into specific types of events. I'm using office 365. TIA!Loss carry forward for limited years
Hello Excel Community, Excel Version: O365 (Enterprise) I’m running into a mental block trying to model loss carryforward with limited years using a spill formula. Below is a simplified example of what I’m trying to build a formula for. Rules: • A loss from any year can be carried forward for N years, after which it expires and can no longer be used. • In any year with a positive tax liability, if there is any remaining loss from the past N years, you deduct using a FIFO approach (oldest losses used first). • Any unclaimed balance from year N+1 expires, even if it hasn’t been fully used. I’ve found plenty of examples showing loss carryforward without expiration, but I’m struggling to build something that handles both FIFO and expiration in a dynamic array formula. I feel like this must be a solved problem and I’m just missing something obvious. Any help would be greatly appreciated! ------------------------------------------------------------------------------------------How do you respond to...
Hello my Excellers, I wish you all a happy new year full of great things. I have a question and I am not sure if this is a purely an Excel question or something else but maybe I start here and see how it goes: As you all may have noticed the AI craze is blooming like crazy. If you want to sell lettuce slap AI on its label and step back. I use Bing to search for VBA examples. For example I typed "excel vba code to find cells with formulas" and I get AI to find or "compose" a decent example that with minimal editing will work perfectly. But then at the end of the code and its explanation I sometimes find these kind of questions: "If you want to list the addresses of formula cells instead of highlighting them, I can give you a version that outputs them in the Immediate Window or a new sheet. Do you want me to provide that listing version as well?" How do you say YES I want that code that would list the addresses in a sheet? I see buttons like "Undo" rounded Left Arrow, or "Redo" rounded Right arrow, and a "Copy, "Export", and then "Tweak Content", "Rewrite" button, A "Testing Tools" dropdown with options like "Generate test data" and "Integrate test cases", and another dropdown called "More Actions" with options like "Perform code review", "Explain the code", "Add error handling", and "Make code compliable" and the last dropdown "Work Report" with its own options. But I do not see anything that would allow me to say YES I want that code that would list the addresses in a sheet? Thanks for any insight... GiGi
Microsoft Copilot
Is anyone else having issues today? I was using copilot today like I have been for months. Using the same prompts I have been using for months when I started getting this response "I'd really like to help, but it seems this topic is off-limits for me. sorry about that!" I was trying to discuss with the AI what the issue was and tried showing the prompt when all of a sudden it said I was suspended for an hour. I tried to talk with support but they were no help.
Microsft Forms Permissions
Hello, We created a form for people to RSVP for an event. We shared the link with our invitees. Some individuals when they follow the link will see other peoples answers displayed in the question fields instead of the prompts we created. Furthermore, one individual opened Forms on their computer and saw that they had editing permissions to our form. How could this have happened and is there a way to remove people from what appears to be an editing permission? Thanks!Teams External Collaboration Administrator Role Arrives
Microsoft is introducing a new Entra ID role. The Teams External Collaboration administrator role allows users to manage external collaboration settings. Quite how often Microsoft 365 tenants need to manage these settings is unknown, but it’s a useful prompt to review the current set of roles used and users who are members of those roles. Time for an annual clean-up. https://office365itpros.com/2026/01/14/new-entra-id-role/
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?
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
- Managing app security and compliance in Microsoft Teams just got easier! With recent updates in Teams Admin Center (TAC), IT admins can now quickly identify trusted apps and enforce organizational st...Jan 14, 2026
- Ask Copilot for tips to help you organize your workspace, your home, or your digital files.Jan 12, 2026
