Recent Discussions
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!
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 Sub
Outlook Search isue
HI All, We are having a search issue in Outlook Classic. User's unable to search from shared mailbox in outlook classic. issue started last week. is there any one know the fix for it? i have tried everything what normally suggested by Microsoft. i have created new machine for the user and issue is still there. thanks, Preyash PArekh
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 Feedback Portal account issue
I changed my Microsoft email a year ago, and it updated everywhere other than the Feedback Portal. As a result, I get an error when I try to login, or do anything on the page. Microsoft account support's suggestion was to login to the Feedback Portal which is insane given I'm having issues accessing it. How can I get this issue resolved? I've got three separate support tickets now and they keep asking me to wait 24 hours to get the issue resolved. Can someone from the Feedback Portal team please contact me to resolve this? This is what Microsoft Support have said: "understand your frustration, and yes—this is an account‑related issue because the Feedback Portal is still tied to your old alias, which causes login conflicts and forces you out. Your Microsoft account itself signs in correctly, but the Feedback Portal is pulling outdated identity data that you cannot update on your own. Since you cannot access the Portal to submit feedback, directing you back there is not a workable solution. What you need is for Support to escalate this to the internal Identity/Feedback Platform engineering team so they can manually correct the outdated alias mapping on the backend. In this situation, the Feedback Portal and Tech Community teams are the ones who manage and maintain that specific platform. Because the issue appears on the Feedback Portal side—even though your Microsoft account is working normally—only their dedicated team can make the necessary corrections on their end. That’s why we are guiding you to connect with them through the links provided: https://techcommunity.microsoft.com/ or https://feedbackportal.microsoft.com/feedback. They will be able to review the portal‑specific account data and assist you further. I understand why this is frustrating. Since you’re unable to stay signed in to the Feedback Portal, I completely see why posting there isn’t possible for you. However, I do need to be transparent: I’m not able to escalate this issue directly to the Feedback Portal team, as they don’t provide internal escalation channels for us and only accept requests through their own platform."
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.
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))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:Everchanging 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.
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
