Recent Discussions
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.
Microsoft Excel is waiting for another application to complete an OLE action
Hi there, Whenever I copy paste special in excel, my excel file freezes and after a waiting for a few seconds to few minutes, depending on the amount of data being copy pasted, I get this error 'Microsoft Excel is waiting for another application to complete an OLE action' I tried a few things like this but none help and the problem persists. 1st troubleshooting 1. Open the Excel sheet and go the File menu. In the File menu, click on Options. 2. An Excel Options dialog box will appear. Go to the Advanced tab and scroll down to the General area. Over there check Ignore other applications that use Dynamic Data Exchange (DDE). 3. Restart Excel. 2nd troubleshooting Tried opening Excel in safe mode 3rd troubleshooting Removed all the Add ins 4th troubleshooting Reinstalled MS Office. Can someone help.Block users from creating Public Microsoft Teams groups
Hi Community, Is already know that Teams creation in Microsoft Teams is related to O365 groups, and if you would like to block users from creating teams, you need to block them from creating O365 groups, right? Ok, right. But what if we only want to block the possibility to create public teams, but still allow them to create private ones? Would that be possible? The answer is YES. And the solution is Microsoft Purview. You'll need to create a new Label/Label Policy under Information Protection. We'll configure the Label for the scope "Site, UnifiedGroup", with group settings as "Private" and applying the label automatically. Then we can configure/publish the Label Policy as mandatory for all the users, some of them or, as in my example, to a DL that contains all the users that I would like to block. Once published, depending on your tenant size, it can take up to 24 hours to propagate. In my test environment it was quite immediate. Now, the users added to the DL that I configured in the Label Policy can still create teams, but not Public ones ( and can't change the label ) as that option is greyed out. The answer is YES. And the solution is Microsoft Purview.Losing Hyperlinks in Office 365 and OneDrive
Hello, first-time poster here. I hope someone can help with a dilemma I'm experiencing. I have an Excel 2016 workbook which contains 2 worksheets. The first worksheet consists of icons I inserted. I wanted the icons so that I could rotate them to suit my needs. Within the icons, I created a text box and inserted a hyperlink in each one that referred to a specific cell in the 2nd worksheet. In regular Excel, the links work great. However, when trying to test/edit in Office 365 or OneDrive, I find that all of the hyperlinks have disappeared, as well as the ability to create any new ones. This has really stumped me. Does anyone have any suggestions? Many thanks! 🙂
INDEX MATCH with VLOOKUP
This is my first time posting here, as I hit a roadblock that I'm sure is simple enough. I am using the following formula, but the source data ('FY26 Income Statement Data'!$A$4:$A$2158) has several rows with the same criteria on 'Cash Flow'!$A7. I think I need to include a VLOOKUP formula but I don't know how to do this. Any help will be appreciated. =INDEX('FY26 Income Statement Data'!$A$4:$AB$2158,MATCH('Cash Flow'!$A7,'FY26 Income Statement Data'!$A$4:$A$2158,0),MATCH('Cash Flow'!C$1,'FY26 Income Statement Data'!$A$4:$AB$4,0))
Return a value based on different parameters
Not sure if my title is describing my issue correctly. I have one column where each cell contains the same drop down list from which I can choose one of six options, and depending on what option is chosen, I want the cell in another column to return certain value: Option Chosen Return Value Not Started 0% Started 25% In Progress 50% Nearly There 75% Complete 100% I found this example formula online, which is only repeated once but works perfectly for two parameters: =IF(ISNUMBER(SEARCH("Not Started",F3)),"0%",IF(ISNUMBER(SEARCH("Started",F3)),"25%")) However, when I start to extend/repeat the formula more than once for the remaining parameters I cannot get it to work. I've extended it as follows... =IF(ISNUMBER(SEARCH("Not Started",F3)),"0%",IF(ISNUMBER(SEARCH("Started",F3)),"25%",IF(ISNUMBER(SEARCH("In Progress",F3)),"50%",IF(ISNUMBER(SEARCH("Nearly There",F3)),"75%",IF(ISNUMBER(SEARCH("Complete",F3)),"100%")) ... and it returns the error 'the formula is missing an opening or closing parenthesis' Please can anyone help with this. Thank you in advance.
Sync Issues with Tracking Meetings from Outlook to Dynamics 365
Hello, my work uses the Dynamic 365 App for Outlook to track meetings as appointments in Dynamics 365, but it has failed several times for several users (on both Mac and Windows, in Old and New Outlook and on web browsers); some meetings will fail to track immediately while in some cases, meetings that were successfully tracked will stopped working and are no longer tracked in Dynamics. In the spoiler below is a sanitized version of the diagnostic log for meetings that used to be tracked that stopped working: In the log, we have the following error message: "lastsyncerror": "ExchangeSyncGeneralCrmItemSyncError;Microsoft.Crm.Asynchronous.EmailConnector.ErrorSource.Crm:130;T:188\r\nActivityId: [Removed]\r\n>Exception : Microsoft.Crm.Asynchronous.EmailConnector.ExchangeSyncException: Failed to sync item to CRM server : System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: There is no active transaction. This error is usually caused by custom plug-ins that ignore errors from service calls and continue processing. at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +0x27 at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +0x1ba at Microsoft.Xrm.Sdk.IOrganizationService.Execute(OrganizationRequest request) at Microsoft.Xrm.Sdk.WebServiceClient.WebProxyClient`1.ExecuteAction[TResult](Func`1 action) +0x15 at CrmSDKLib.OrganizationServiceWrapper.<>c__DisplayClass10_0.<Execute>b__0() in C:\\__w\\1\\s\\src\\lib\\CrmSDK\\OrganizationServiceWrapper.cs:line 13..." In Outlook, when I look at these meetings and check the app it gives the message: Recurring appointment occurrence cannot be tracked However, we have other series of recurring meetings that have been successfully tracked that does not run into the issue. Anyone has encountered this or similar issue? How do we resolve this so going forward the app can track all meetings without issue? Please let me know, thank you!Formulas Not Calculating in Workbook
Hello, I have a very large workbook with many formulas across different sheets. I currently have this workbook set to manual calculations only. And it is saved in a Sharepoint Directory with autosave enabled. When the source data for this workbook is updated. None of the formulas are updating when 1. The Calculate Now button is pressed. 2. The workbook is set back to automatic calculation. 3. When the work book is manually saved and closed. I have noticed another issue. When I go to File > Options. The Options dialogue never appears. I am wondering if anyone else have experienced this issue, and if so have been able to successfully troubleshoot the problem?Frame Text Direction Bug
Not sure when it started happening, but a former client recently contacted me regarding an anomaly with text direction in frames. They have a pleading document where the firm information (name and address) is included in frame located in the left margin of the document. The Text direction is set to run from bottom to top and consists of three lines of text. When the document is opened with Word: Microsoft® Word 2019 MSO (Version 2508 Build 16.0.19127.20302) 32-bit All three lines of text are scrunched up on the bottom line.
Auto-Decline Meetings scheduled in non-business hours
Hi, I am trying to automate a declining meeting which is scheduled in non-business hours. I am using MS Flow and trigger "When a new event is created (V3)" and Action as "Respond to an Event (V2)". in MS Flow. This works perfectly fine. But I am not able to figure out a way to define non-working hours. Any pointers would help.
Paste values-only Excel
I copy data from websites and different software and paste it into Excel 2019. The values are pasted correctly—without the currency symbol or extra space before the numbers—even when using "Paste Values Only." It works as expected. However, in Excel 365, the same data is pasted with the currency symbol "$" followed by a space and then the number, even when I select "Paste Values Only." This causes the values to be stored as General or Text format. To fix this, I have to manually search and replace the symbol and the space. How can I make Excel 365 paste data like Excel 2019 does? Data source: Currency symbol and space before numbers in Excel 365:VBA Code "Next" button. Should be so simple...
I have the following codes in the click event for a "next" and "prev" buttons on my userform. The prev button works fine, the next button will not advance to the next record in my table, and instead gives me the "Last record" message box (regardless of the active row). If I remove the If...Then loop it works fine. WHY is it looping to the "last record" msgbox when it is clearly not on the last record?? Any ideas greatly appreciated Dim LastFind As Range Dim CurrentRow As Long Private Sub CommandButton6_Click() If CurrentRow < LastRow Then CurrentRow = CurrentRow + 1 LoadRecord CurrentRow Else MsgBox "This is the last record." End If End Sub Private Sub CommandButton7_Click() If CurrentRow > 5 Then CurrentRow = CurrentRow - 1 LoadRecord CurrentRow Else MsgBox "This is the first record." End If End SubEverchanging spreadsheet
I am in the process of making a spreadsheet for parts on hold. I have cells below the list that I need to stay below any list above without inserting new cells. This first tab with forever change as parts will come and go on the sheet. I also a have separate tabs that show different buyers and I want the information auto transferred to the correct tab by buyer number but keep the main tab whole.
How to add a new field to existing XML Mapping
Hi, everyone! Good day! I've made an XML file which I imported to my doc using XML Mapping Pane -> (Add new part...) and I used it to map some texts. How could I add new fields to this XML Mapping? What I tried: I tried editing the XML file and then importing it again. As a result, I have two XML Mappings with the same name that act as completely separate mappings. I couldn't even find a way to delete the older one.
APP Android Excel 365
Hallo und guten Tag, wird möchten mehrere Android Tablets anschaffen um eine auf einem W11 Laptop (mit VBA und Macros) erstellte Excel 365 Anwendung zu nutzen. Hat jemand Erfahrung mit Excel 365 für Android. Insbesondere geht es mir um die herauszubekommen, inwieweit VBA und Macros auf dem Tablet ausführbar sind. Gruß PeterOptimizing Microsoft 365 Licenses Using Behavior Data (E3/E1/F3)
Hi everyone, We are currently working on a Microsoft 365 license optimization initiative and would appreciate insights from the community and Microsoft experts. Our approach focuses on two main areas: (1) Revoking licenses for inactive users, and (2) Reviewing active users to ensure their assigned license (E3, E1, or F3) aligns with actual usage and collaboration needs. From a data perspective, we are leveraging Microsoft 365 usage signals such as Teams activity, Outlook email interactions, meetings, and SharePoint/OneDrive collaboration. While usage reports provide raw metrics, we are looking for guidance on how these signals should be interpreted and combined in a meaningful and fair way. Specifically, we would like to understand: (1) Which usage metrics best represent user collaboration behavior? (2) Are there any recommended thresholds or patterns that help distinguish light, standard, and heavy collaboration users to map E3, E1, or F3? Any best practices, references, or real-world experiences would be greatly appreciated. I'm sorry if this is the wrong forums to ask for. Thanks in advance for sharing your insights.
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
- Plan smarter with Microsoft 365 Copilot to make every day count in February.Feb 03, 2026
- Improvements in Microsoft 365 help you inclusively communicate and collaborate with math.Feb 02, 2026
