Recent Discussions
Variable "Connecting to Datasource" Load times
Hello, I am running into a strange issue that I am not sure how to solve. I am using Power Query to link to external Excel data files/Sheets and then I process the data within Power Query and also have some Macros that run after the data is refreshed. I am seeing a drastic difference in the amount of time it takes separate users to open/refresh this file (the users have the same internet connection, use the same link to the file on a Shared Drive on our servers, same Excel settings, and have the same hardware). Some users can load and run all Macros in < 15 seconds, while the others take > 10 minutes. I have exhausted all possible causes/reasons that I can think of and am looking for some guidance. Any and all suggestions are appreciated! Thanks, Skywalker_
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.
The return of the performance leak - this time with subreports
Anyone remember the v2405 bug that caused loading and closing forms to become slower over time? We found something similar in the current release (tested with semi-annual 2508 (19127.20484)), just with sub reports instead of forms. Here are the repro instructions: Repro instructions Table 1. Create a "numbers" table with a PK field "nr" (Long Integer). 2. Fill it with the numbers from 1 to 100: Dim i For i = 1 To 100 CurrentDb.Execute "INSERT INTO numbers (nr) VALUES (" & i & ")" Next i Sub report 3. Create a new empty report in design view, using the "numbers" table as the record source. 4. In the detail section, add two text boxes "Text1" and "Text2" next to each other, both with the "nr" field as their control source. 5. Reduce the size of the detail section to one "row", containing just the two text boxes. Remove the page header/footer. 6. Add an Format event handler to the detail section with the following content: Me.Text2.Visible = False 7. Save the report as "sub". Main report 8. Create another report "main", which contains nothing but the "sub" report as a subreport in its detail section. Set the record source of "main" to "SELECT * FROM numbers WHERE nr <= 10" Reproduce problem 9. Create the following method in a module: Sub report_loop() Dim i As Long Dim start_time As Single Dim report_name As String Dim path As String report_name = "main" For i = 1 To 40 path = Environ("Temp") & "\testreport.pdf" start_time = Timer DoCmd.OpenReport report_name, acViewPreview DoCmd.OutputTo acOutputReport, report_name, acFormatPDF, path DoCmd.Close acReport, report_name Debug.Print Timer - start_time Next End Sub 10. Run report_loop. Observe that each report export gets slower and slower. Analysis Compare the first and last number in the direct window: on my machine it's 0.4s for the first report and 2.3s for the last. Note that if you run report_loop again, it will start slow! In other words, each report export causes MS Access to "leak performance" that is only regained after restarting Access. We were able to reproduce this issue with Microsoft 365 semi-annual channel, Version 2508 (19127.20484). I'll do more tests tomorrow and try different older versions to find out when this bug was introduced. Workarounds If you move the visibility code from the Format event to the Print event, the problem still occurs, but slower (0.4s -> 0.72s instead of 0.4s -> 2.3s). The workaround that worked for us was to use =IIf(...) in the control source instead of modifying the visibility. Obviously, that only works for text boxes, not for lines or other controls.Help with data and visuals
I hope i can explain this right, i have data that shows 3 things: person, start date and end date: now i need excel to take this information and represent it as the following in the month tracker: It would look for the charts and figure out the timeline and add them to a row with the timeframe: example is Booy 15-0ct-25 to 23-oct-25 the char would go to the next one and add his information, I hope someone can help me. I just need it to populate the month tracker, ThanksWord 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?Summary sheet, copy entire row if a cell criteria is met
https://arengio-my.sharepoint.com/:x:/g/personal/melanie_stokes_areng_io/IQC2OhPfZnKEQL6qfPj11gqfAQSh8Em3Zp95fkYbLBTZc3g?e=oNU1pEHi Can you please help me, I have a schedule for jobcards, each tab is a book that is given to someone, if that specific jobcard is invoices, then in column T where it says "Incomplete", I want that entire row to be copied to the "Outstanding Jobcards"tab. As a new book is handed out, a new tab is create and the tab is named according to the book sequence. This is updated daily as jobcards are being invoiced.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!Too thick/fat gridlines when printing from excel
When I print a spreadsheet where I have selected/marked for gridlines, the gridlines become much thicker than they should be. They have the same thickness as the cells I have given borders. On the screen everything looks correct. The problem is only on the printout. I get the same problem no matter which printer I choose (has nothing to do with the printer driver). I have the latest operating system and drivers.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! ------------------------------------------------------------------------------------------
Microsoft Edge Webview icon
I'm I in the right community? My Widgets Icon on my toolbar doesn't open even with the Widgets turned on in the settings. Could you help me? I am the administrator. I have the Edition Windows 11 Home Version, 23H2, with a Windows Feature Experience Pack. I have Windows 11 software and has been updated recently. Everything under Task Manager, details, mswebview.exe is running, however, the window doesn't appear on the home screen. Could this be an easy fix? TIA JosephHow 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... GiGiSaved CSV opens with dates even when saved as text
Hi, New to the page, have a problem with a CSV file that has hyphenated numbers which turns into dates when opened after being saved as text. How do I make sure that the changes made in the columns stay as text so it doesn't revert back to date or custom format? I know this topic is talked about in this forum and I can change it to text when I open it but the issue is I have to upload it into accounting software and think that it is defaulting when I save the file. Have tried importing the data into a CSV file and that doesn't seem to work and also got some code from an AI platform to put into the Visual Basic program to try and stop it but didn't seem to work. Any help would be much appreciated. Brian 4-1000 Income 4-1025 Income Apr-00 Income
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!
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
- There are now two faster, more intuitive ways to bring text-based data directly into Excel.Jan 15, 2026
- 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
