Recent Discussions
The Copilot Agent Mode icon in Excel, which I was using until a few days ago, is no longer visible.
I am a user of Microsoft 365 Premium on the Beta Channel. I was able to use it until a few days ago, but the Agent Mode that was visible until recently (as shown in the snapshot) is no longer visible. Why is this happening?
Microsoft Access and Outlook
Hi there, I have just updated my laptop (with a view for a faster laptop!) However, Access was working fine and now i can't send emails from access through outlook like before. I get a message to say a program is trying to send an email message on your behalf. I'm not sure how to get rid of this warning! Please help.... Thank you in advanceIndenting in numbered list has gone haywire
My office uses custom Word templates that are updated to a legal software site, populated with an intake form through the same site, and then downloaded to our individual computers to edit as needed. The templates mostly use legal numbering under the Normal style. On Tuesday February 3, everything was working fine when I put my laptop to sleep. The next morning, I opened a Word document that I had downloaded from the legal software site and edited a week or two previously, and the formatting and indentation of the numbered lists was suddenly completely wonky. I had not changed any settings from the end of one day to the beginning of the next to cause this issue. In addition, I am the only one in the office of five people to be experiencing the problem. I contacted tech support, and the support person walked me through fixing the styles settings, and when that did not work, they uninstalled and reinstalled the entire Office suite. That also did not solve the problem. I'm completely stumped here; why would this issue suddenly arise with no input from me and also only affect my version of Word? And why didn't reinstalling the application fix it?? Details of the formatting issue: Normally, the numbering should look like this FIRST 1.1 The text goes to the right margin of the page and then wraps so that the second line is indented by the same amount. 1.1.1 The first sub-paragraph begins at the indentation of the text in the first paragraph 1.1.1.1 The second sub-paragraph starts the same way, etc. Now it looks like this: FIRST 1.1 The text begins closer to the number and goes to the right margin, then the second line is not indented to begin at the same point as the first line. When I click on the leading number (e.g. 1.1), some of the text jumps over to the right slightly. When I try to use the markers on the ruler to adjust the indentation, the text doesn't move at all. In addition, I can open a document, not mess with the wonky formatting but change something else, for example remove a watermark, then save and close the document, and one of my colleagues can open the same document and not have the formatting be messed up. Please help!Quotation Marks - Losing my mind over Excel error
Hello everyone, As per title: trying to follow basic instructions (=C4," ",B4) and so on. Excel keeps returning an error message. I am aware of the difference between straight quotation marks and curly, dialogue ones, but still. As soon as I enter those, error keeps popping up. Please see below. My Excel is set in Italian, is that a location thing? Thank you.
Trying to fill a field in excel with 3 different wordfs based on another field result
I am trying to fill a field in excel with 3 different words based on another fiels results. Result field will have a percentage based on a calculation which is already set to show 3 differnt colors based on the reults. ie: 0-32% is red, 33-74% is Yelow and 75-10% is Green, ths field is G7 I want to have the result of G7 to fill G8 with the the following statement, and include the color fill above. If G7 is 0-32% then "Bad Deal", if G7 is 33-74% then "Fair Deal", if G7 is 75-100% then "Good Deal" Looking to the Deal words placed in the field based on the result of G7
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."
Formula help
Hi all, I have a spreadsheet with four sheets of data (different suppliers, then organised by catalogue/non-catalogue products), and I want the product name to pull through to a fifth summary sheet if the number of items required is >0. So; I want the highlighted info from sheets 1-4 to pull through to sheet 5 (product name and number required) if the number required is >0 Hopefully that makes sense - can anyone tell me how to do this?
MFA Enabled> conditional MFA policy setup > not prompting users to authenticate
I pulled a report in Entra that shows users with no MFA authentication methods setup, but we have a conditional mfa policy setup that should enforce MFA. I have worked with a user showing on the report. Their PC is joined in entra and managed Intune. I have revoked the user session reset his MFA still the user is able to sign in to his pc with his windows hello pin or his 0365 credentials without being prompted for MFA registration authentication setup...any helpWrapRows2Dλ / WrapCols2Dλ: Fast, efficient 2D wrapping without flattening
Background One of Excel's biggest weaknesses is in working with 2D arrays as objects that can be re-shaped. WRAPROWS/WRAPCOLS do not accept 2D arrays (#VALUE!) and are strictly for shaping 1D arrays. The usual workarounds involve flattening with TOROW/TOCOL then re-shaping with WRAPROWS/WRAPCOLS, REDUCE used an iterator to stack (do-able but slow), and even MAKEARRAY (do-able, but not instinctive and slow). The Goal Fast, efficient 2D wrapping without flattening. The Approach Pure deferred i/j indexing with modular math and sequencing. The function and sample workbook is provided below. I welcome any and all feedback: suggestions for improvement, your approach to 2D shaping, etc. // Fast, efficient 2D wrapping without flattening //----------------------------------------------------------------------------------- //---WrapCols2Dλ--- //----------------------------------------------------------------------------------- //Author: Patrick H. //Date: 1/28/2026 //Version: 1.0 // //Description: //Wrap a 2D array into column blocks of a specified width while preserving row height. //The wrapped blocks are stacked vertically in the output. //Jagged or uneven final blocks are padded with NA() by default, unless a fill value //is supplied via the optional pad_with parameter. // //----------------------------------------------------------------------------------- //Parameter Description //array - 2D array to be wrapped (1D arrays not supported) //new_width - Number of columns in each wrapped block // //Optional Description //pad_with - Fill value used to pad incomplete blocks. If omitted, NA() is used. // //Lambda called: Echoλ WrapCols2Dλ= LAMBDA( array, new_width, [pad_with], //Check inputs LET( //Shape h, ROWS(array), w, COLUMNS(array), blocks, CEILING(w/new_width,1), //Optional pad_with, IF(ISOMITTED(pad_with),NA(),pad_with), //Total rows when wrapped r, blocks * h, //Scenarios Is1D?, OR(h = 1,w = 1), IsScalar?, AND(h = 1, w = 1), InvalidDim?,new_width >= w, SpillRisk?, r > 1048576, //Logic gate IF(IsScalar?,#VALUE!, IF(Is1D?,#VALUE!, IF(InvalidDim?,"#WIDTH!", IF(SpillRisk?,#NUM!, //Proceed LET( //Indices - deferred modulo, LAMBDA(MOD(SEQUENCE(r),h)), i, LAMBDA(IF(modulo() = 0, h, modulo()) * SEQUENCE(,new_width,1,0)), j, LAMBDA(Echoλ(SEQUENCE(r / h,,1,new_width),h) + SEQUENCE(,new_width,0,1)), //Wrapped array result, IFERROR(INDEX(array,i(),j()),pad_with), result ))))))); //----------------------------------------------------------------------------------- //---WrapRows2Dλ--- //----------------------------------------------------------------------------------- //Author: Patrick H. //Date: 1/28/2026 //Version: 1.0 // //Description: //Wrap a 2D array into row blocks of a specified height while preserving column width. //The wrapped blocks are stacked horizontally in the output. //Jagged or uneven final blocks are padded with NA() by default, unless a fill value //is supplied via the optional pad_with parameter. // //----------------------------------------------------------------------------------- //Parameter Description //array - 2D array to be wrapped (1D arrays not supported) //new_height - Number of rows in each wrapped block // //Optional Description //pad_with - Fill value used to pad incomplete blocks. If omitted, NA() is used. // //Lambda called: Echoλ WrapRows2Dλ= LAMBDA( array, new_height, [pad_with], //Check inputs LET( //Shape h, ROWS(array), w, COLUMNS(array), blocks, CEILING(h/new_height,1), //Optional pad_with, IF(ISOMITTED(pad_with),NA(),pad_with), //Total columns when unwrapped c, blocks * w, //Scenarios Is1D?, OR(h = 1,w = 1), IsScalar?, AND(h = 1, w = 1), InvalidDim?,new_height >= h, SpillRisk?, c > 16384, //Logic gate IF(IsScalar?,#VALUE!, IF(Is1D?,#VALUE!, IF(InvalidDim?,"#HEIGHT!", IF(SpillRisk?,#NUM!, //Proceed LET( //Indices - deferred i, LAMBDA(TOROW(Echoλ(SEQUENCE(,blocks,1,new_height),w)) + SEQUENCE(new_height,,0,1)), modulo, LAMBDA(MOD(SEQUENCE(,w * blocks),w)), j, LAMBDA(IF(modulo()=0,w,modulo()) * SEQUENCE(new_height,,1,0)), //Wrapped array result, IFERROR(INDEX(array,i(),j()),pad_with), result ))))))); //----------------------------------------------------------------------------------- //Echoλ //----------------------------------------------------------------------------------- //Author: Patrick H. //Date: 11/7/2025 //Version: 1.0 //Description: //Repeat each element in a supplied 1D array by specifying the repeat counts. //Arrays and scalars are supported. //----------------------------------------------------------------------------------- //vector - 1D array or scalar to be echoed //repeat - 1D array of repeat counts (must be numeric and ≥1) Echoλ = LAMBDA( vector, repeat, //Check inputs IF(OR(ISTEXT(repeat),repeat<=0),#VALUE!, LET( //Flatten inputs vector, TOCOL(vector), repeat, TOCOL(repeat), //Dimensions and row indexing V↕, ROWS(vector), R↕,ROWS(repeat), r, IF(V↕<>R↕,EXPAND(repeat,V↕,,@TAKE(repeat,-1)), repeat), i, SEQUENCE(ROWS(r)), m, MAX(r), idx, LAMBDA(TOCOL(IF(SIGN(r-SEQUENCE(,m,0,))=1,i,NA()),2)), //Unwrap idx but defer delivery until function invocation deliver, LAMBDA(INDEX(vector,idx())), deliver ))()); Workbook attached and linked in case this forum gobbles it up! Patrick2788/Excel-Lambda: Excel Lambda modules Excel-Lambda/Wrap2D Demo.xlsx at main · Patrick2788/Excel-Lambda Excel Lambda modules. Contribute to Patrick2788/Excel-Lambda development by creating an account on GitHub. github.com
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.Publisher
I understand that Publisher will be removed from 365 in 2026 with the aim to incorporate it's features in Word. I love Publisher and before I had 365 I had a paid version. I use it for newsletters, crafts, knitting patterns, and photo albums. The things I most value are being able to crop and resize images, move text boxes around for best fit, adding effects like shading and wordart, and importing images. I'm not sure that these features could be available in Word so I'm looking for opinions on alternatives. My 365 version of Publisher has become very "buggy" recently with many "not responding" messages, and I don't want to try uninstalling if I can't get it back. It doesn't show as an option in the current list of apps included with 365. Can I buy a paid version of Publisher? Would this be supported going forward? Is there an alternative to Publisher that gives me the features I need and is compatible with my existing .pub documents? I'm not looking for a professional package, it's only for occasional home and hobby use, so a subscription model would be unaffordable and unnecessary. Alternatively, would Microsoft be able to assure me (and others like me) that they can incorporate Publisher features into Word or another app?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 PArekhHow do I auto-populate information from one tab to another in sheets?
I have an excel sheet with several tabs. The first tab is the Master tab used to track all tabs. I would like all new tabs to auto-populate information into columns on the master tab. For example, I have multiple fields in my form I would like information from these fields to auto-populate into the master spreadsheet. I would like all new forms/tabs to automatically update the master spreadsheet. I am currently entering everything manually.How do I turn off copilot if it's not in the options?
This provided screenshot is what I get with Word Options. There are no copilot settings in Word Options in my copy of Office, I cannot find any way of turning it off, and yet copilot has gotten so much worse by giving me three suggestions (at the top of the window, suggesting what kind of content I should make) every time I open a new document. Copilot just keeps getting more intrusive, and I want to shut it off. The more it's shoved in my face, the less I want to use it. I don't know why you're making it so intrusive, I've never heard of anyone actually LIKING this stuff. Why would someone want suggestions as to what kind of document to make? It's far worse than Clippy could even dream of. I haven't tried uninstalling and reinstalling Office yet, but I don't want to have to go through and change a bunch of options again (that I always forget, there are so many options that I have to change to make it usable, like turning off the awful Backstage when saving) unless it's truly necessary to fix this problem. If it gets updated regularly (like the update that gives three Copilot suggestions every time I open a new document), I don't see why reinstalling it would fix the problem. But maybe reinstalling is the answer--if it IS the answer, I just want confirmation that it has actually worked for other people, and not just a generic answer that hasn't been confirmed.Stop Excel from Rounding Long Numbers on Paste
This has been asked many times, in many places, and I still don't have a functional solution. I'm looking for some sort of permanent setting that will prevent Excel from rounding pasted long numbers. I'm copying a long number from a website and pasting into Excel. Let's use this as the example: a video ID of 1193798918192507 . When pasting, Excel converts that number to: 1.1938E+15, or 1193798918192500. Now I have an entirely different ID. I need Excel to retain the actual ID of 1193798918192507 so that I can use a vlookup function. Here's what doesn't work: 1. Formatting the cell as number before or after the paste. 2. Formatting the cell as text before or after the paste. 3. Formatting the cell as custom "################" before or after the paste. 4. Formatting the cell as fraction before or after the paste. 5. Creating a spreadsheet somewhere else to input these numbers before importing to Excel. This isn't practical unless you already have a long list of numbers assembled. 6. Typing an apostrophe before each paste - I don't want to navigate my hand from keyboard to mouse a hundred times. A mouse click to copy, click to paste, is most efficient. 7. Pasting all the long numbers and using a formula to modify the number to text in another column. Concatenating an apostrophe, or using (=A1,""), or any other formula will only provide the number output AFTER Excel has already rounded. Not helpful, those last digits are identifiers and need to be what they are and cannot be replaced with zeroes. Is there some sort of permanent way that will stop Excel from rounding these numbers? If not, is there anywhere that we can submit requests to their engineering team? *Please do not provide a solution unless you've copied & pasted the above number and it actually shows up in Excel as the correct number ending in -507 (without using methods 1-7 detailed above). I'm not trying to be ungrateful for people taking time out of their day to assist, I'm just trying to find a solution that actually works for the thousands of us with this problem. Many thanks in advance for your help!
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
- No more skipped content or missed information - Take advantage of this new setting to naviagte through your content more intuitively.Feb 05, 2026
- Plan smarter with Microsoft 365 Copilot to make every day count in February.Feb 03, 2026
