Recent Discussions
Excel not working properly since updating to Windows 11
Hi, Since I have updated my PC to windows 11 Excel has not been working properly. Every 5 min the sheets seem to be unresponsive when I click on a tab or anywhere on the excel page. To make it work again I have to constantly reduce the window and reopen it. This is very frustrating as it happens very often. I have tried to start excel in safe mode or disable add-ins but the bug continues. Thank you82KViews5likes114CommentsExcel: Count cells with specific value + colour
Hi there, I would like to be able to count the number of cells that contain a specific value and are shaded a specific colour. This is for a rota spreadsheet that will be tallying the total number of shifts which have been agreed. The cells that contain "Yes" as a value from a drop down list and are shaded green, should be counted as part of the quarterly total. I'm assuming that a VBA custom function would be needed for this. I've tried a few but cannot figure out a way to get this to work with both a specific value and colour. I would be very grateful for anyone that is able crack this challenge. In the example screenshots, it is the cells shaded in green that would need to be counted and the totals appear in column GJ. Best regards, Daniel194Views0likes7CommentsHelp Needed: Add Interactive Dashboard to Landowner Engagement Tracker (Same Sheet)
Hi all, I’ve built a basic Excel tracker to monitor engagement with landowners for a large infrastructure project. The purpose of the tracker is to: Show progress tracking of each case of for the project director to monitor progress help the Project Director Identify which cases may require statutory powers to secure access (if voluntary agreement isn’t possible) This helps our leadership team make informed decisions quickly. What I’ve got: A sheet called "LANDS RIGHT TRACKER" Columns include: Reference Number Agreement Status Case Status Risk Level (High/Medium/Low) Willingness to enter agreement Reason for refusal Flag for whether statutory powers may be needed 🛡️ All data is fictitious — names and details are placeholders, so no privacy concerns. What I need help with: my level of excel knowledge is very basic and I was hoping for some assistance to: Add an interactive dashboard and key metrics directly on the same sheet (not a separate worksheet). The below is just my suggestions as you are the expert your guidance expertise is much welcomed, happy for you to put it straight on to the tracker as I have left a section on the tracker for you to insert your items Ideally using a Pivot Table and Slicers to filter by: Case Status Risk Level Agreement Status Willingness to enter agreement https://docs.google.com/spreadsheets/d/1c2IJ-YLsTN-DZE9ltw0JR-nGVuuGzTKE/edit?usp=drivesdk&ouid=104511246399228274463&rtpof=true&sd=true24Views0likes1CommentQuery failure in Windows 11
Hi I just had a new computer at work, and changed from windows 10 to windows 11. I have a query, which compare 2 tables, and add rows in table2 that dont exits in table1. This has been working for years, but now it, only sometimes, double all the rows. INSERT INTO MPS Columns from Table2 (Access linked to sharepoint) SELECT MPS2. Columns from table1 FROM MPS2 WHERE not exists (Select 1 from MPS WHERE MPS.[MPSid] = MPS2.[MPSid]); It compares a unik field MPSid It doubles the rows sometimes, and the MPSid is the same, in the doubled rows Has something changed, or is there a workaround? Best Regards Tony61Views0likes3CommentsMS Forms branching option is not visible to individual answers in multiselect question
HELLO, I am working on a form. Question type is choice where user can select "Multiple Answers" and based on selected answer, subsequent question should be visible. To achieve this, i want to add branching to main question but i do not see the option to do so. How to achieve this ? NO branching option :29Views0likes1CommentModernizing Sensitivity Label Grouping for App Display
Microsoft announced the modernization of grouping for sensitivity labels to a new “dynamic architecture.” It doesn’t take much to be more dynamic than the previous parent-child arrangement. Even if the announcement is a tad overhyped, it’s still goodness because administrators can now move labels between label groups in a way that wasn’t possible before. The new way of displaying labels should be everywhere in December 2025. https://office365itpros.com/2025/10/29/sensitivity-labels-groups/14Views1like0CommentsFormula in Excel Spreadsheet not work
Hi Sir, Picture 1 shows the desired condition, where the row of the spreadsheet turns orange when the SPT (N) is more than 50. However, it will not work where the SPT (N) at row 47 become 0. All rows below row 48 become orange colour as picture 2. https://mega.nz/folder/g5dizZqR#7Pk7eyU0hXZTL6sj3qVJ-g. We attach the file in follows link for your further action. Thanks.37Views0likes1Comment- 1View0likes0Comments
Unified Company Calendar for Mixed Microsoft 365 and Non-365 Users – 2025
Seeking a Shared Calendar Solution for Mixed Microsoft 365 and Non-365 Users I’m working on a solution to create a shared company calendar that everyone in our organization can view, while keeping editing permissions limited to a few selected individuals. The challenge: Some of our team members do not use Microsoft 365, and I’d like them to still be able to subscribe to or view the calendar and receive updates. Ideally, this should work without requiring full Microsoft accounts. I initially considered using an ICS-based calendar, but it seems Microsoft 365 Group calendars don’t support sharing via ICS links. I also explored creating a Group calendar as suggested in other threads, but ran into issues making it accessible to external users or those without 365 accounts. For context, I’m a Global Admin, so I have full access to configure settings in the Microsoft 365 Admin Center and Exchange if needed. We’re a small business, and our main goal is to have a centralized calendar for vacation schedules and company-wide events. It should be simple to access and maintain, with a focus on collaboration and accessibility across the board. What I’m looking for: A calendar that’s viewable by all, including non-M365 users Editable only by a few delegated team members Compatible with Microsoft 365, but not dependent on it for basic access Any tools, workarounds, or best practices that have worked for others in similar hybrid environments2Views0likes0CommentsLoop development has seemingly stopped
Our team adopted Loop since many of us prefer the personal knowledge management system style of Notion or Obsidian to other classic note-taking and sharing software. However, many core features are still not present that have been Day 1 features of these other tools, and a quick check of the Loop Roadmap leads me to believe that most features will be security/governance focused. That's disappointing if true, because right now Loop is clearly inspired by those tools, but incredibly far behind in a way that makes it hard to justify their continued use. For example: Cannot embed documents inside Loop-- in Notion you can just drag and drop a PDF to upload, and the /embed command lets you put an interactive document inside the page Cannot select multiple pages to re-arrange structure No Copilot to perform page cleanup-- Notion lets you use AI to fix formatting, and it works very well. No command palette-- this is a must for operating in a knowledge management system No Mac app No mind map a la Obsidian I could continue to produce these examples, but I am hoping to find out that once some core governance features are completed, Microsoft will be focusing some development efforts on improving this platform-- we hope it is not abandonware a few years into it's launch.75Views3likes1CommentMicrosoft Loop integration with Jira
Microsoft announced Loop integration with Jira. https://twitter.com/MicrosoftLoop/status/1691087283477229568 I have tested and it seems it will only work with Jira Cloud. Is there any possibility it will work with Jira Server also? Thanks!12KViews0likes5CommentsExcel/VBA Worksheet_Change function running old version
I wrote a Worksheet_Change function initially. It worked. If I entered an incorrect value I got an error message, let's say the msgbox said "Error: A". Then I changed the error message to read "Error B". No matter what I have tried to do, rename the sheet, Debug>Compile VBA Project, etc, nothing can remove the old error message from appearing. I have tried every suggestion Copilot has made without success. I rebooted my machine. I am using Microsoft Office for Home and Student 2021 running on Windows 11 Pro. Does anyone know what might be the matter? Microsoft chat was totally useless and I am pretty sure Copilot is masquerading as a human in chat support because the wording and suggestions mirrored exactly what I encountered with Copilot, so that was a giant waste of my time. If there's anyone who can help, I would welcome hearing from you with suggestions.25Views0likes1CommentData Import issue???
I am working on a drift formula for items being pushed by wind and waves on the water. I imported a text file of weather data, formatted all the data to numbers, and built an "if" formula to convert the wind direction into drift direction. Wind from 360 degrees (north) would cause an item to drift 180 degrees (south). The problem is the formula sees everything as false. Is this a formatting issue with the imported text? =IF(B28<180,B28+180,B28-180)28Views0likes1CommentAgent Mode continuously loading
Hi all, I installed Excel Labs today and have tried to use https://www.microsoft.com/en-us/microsoft-365/blog/2025/09/29/vibe-working-introducing-agent-mode-and-office-agent-in-microsoft-365-copilot/ for Excel in the web. However, no matter which prompt I use, it just loads continuously, even when left for hours. Has anyone got this working? Or know how to resolve this? I appreciate it's a Preview feature, so happy to wait if it's a temporary glitch, but thought it'd be worth checking.128Views1like7CommentsHow to sync two worksheets
Hi, I am looking for a way to save myself repeating the same task 100x by syncing several worksheets to the source worksheet, so that if I delete or add column's and rows the same happens on the other worksheets. I know how to have cell values synced, I just need to know how to have row/column additions/deletions also synced it would save me a lot of time. thank you in advance27KViews0likes5Comments
Events
Recent Blogs
- 3 MIN READThis month, we explore why metadata unlocks smarter responses from Copilot and agents, and how Knowledge Agent in SharePoint can streamline the process of adding metadata to files.Oct 29, 202574Views0likes0Comments
- Microsoft 365 Copilot is now built into People and Files, with Copilot in Calendar coming soon.Oct 28, 2025883Views0likes1Comment