Recent Discussions
Format Data Labels - Value from Cells
I have a spreadsheet (below) that I wish to show in two different ways: The actual numbers in each of the cells Domestic, Overseas, EU, and Non-EU as shown. The percentage values as shown in the %age domestic, %age overseas, etc.. Using the Format Data Labels and selecting Value From Cells, I can do this for any 2 of the 4 columns. However, when I try to select Value From Cells from the third and/or fourth column, nothing appears in the bar chart - it's completely blank (apart from the background colour.) I have uploaded the failing sheet, which can be downloaded by https://c3a-cyprus.org/test-work.xlsx. I'd appreciate any thoughts TIA Nigel
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: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 advanceChart from dynamic array challenge
Hi (Excel 365 v2601 b19628.20132 Current Channel / Windows 11 25H2) Initial post edited (& cross posted here on Jan 29, 2026) after further investigations In B6 below an array that dynamically resizes according to the 'START Year' & 'TOPN Cat' variables. The Chart is setup as follow: Select an empty cell > Insert 2-D Line chart Right-click > Select Data… > Chart data range > Select the Serie names & Values (C6:G12) Click Edit under Horizontal (Category) Axis Labels > Select the range with the Years (B7:B12) Check of the Chart data range: Changing 'START Year' works no problem: the Chart data range & Horizonal Axis Label range are properly updated Changing 'TOPN Cat' (the array resizes horizontally) screws up the chart: The Chart data range is properly updated but the Series & Axis Label ranges don't update accordingly Q: Am I doing something wrong, facing a limitation or is this something else? Tried to attach the sample file 3 times... it's available at: Dynamic_Chart_Challenge.xlsx Thanks & any question let me know Lz.
Spreadsheets in Word (Mac)
I use Word (standard version) to produce invoices, just basic word documents with an embedded excel spreadsheet. When I do this on my Windows PCs, I can edit the spreadsheets from inside Word and choose which cells to show in the document. When I do this on my Mac, editing the spreadsheet takes me to the full version of Excel, and I have no way of changing the visible area when back in Word. This is a real pain, as I'll often need to add rows to a table in an existing document, but these rows won't be visible and I can't find a way to show them! Can anyone give me any advice on this? Thanks!Microsoft Unified Tenant Configuration Management
Unified Tenant Configuration Management (UTCM) is a new tenant configuration management solution that can monitor changes to over 300 resource types found within Microsoft 365 tenants. Currently accessible via Microsoft Graph beta APIs to all tenants, UTCM offers an alternative to Microsoft DSC and third-party configuration management products. No details are available yet about an admin UX, licensing, or availability. https://office365itpros.com/2026/02/03/utcm-beta/Python in Excel
I have Microsoft 360 and trying to get access to the python plugin. Not able to see it when I open excel. However, was able to see something like BOARDFLARE.EXEC..which seems to suggest that I have access to python. I also contacted a Microsoft rep.. who did verify that I should have in my purchased version python..however, I do not see it. Newbie with Python and Excel. Also, I did try to get the python plugin at the Microsoft store but it seemed that it did not load.
Whiteboard storage location?
Hi, According to this update MC1024395 the storage location for a Whiteboard created in a Teams channel should be the corresponding SharePoint site instead of the initiator's OneDrive. I have checked two tenants but the storage location is still OneDrive, even in new Teams channels. Is this update rolled out? I have checked the news center but I could not find anything usefull. Is there something I can do as an M365 admin? Kind regards, Juan
My Azure login is stuck at MFA and cannot proceed
In August, I was still able to log in to Azure, and by logging in through GitHub I could bypass 2FA. But now, no matter how I try, logging in via GitHub always requires 2FA. I can’t access my Azure account anymore—nothing works. The system prompts me to use Microsoft Authenticator to confirm a two-digit code in real time. My Microsoft Authenticator on my iPhone is logged into the same Microsoft account, but I’m not receiving any verification requests for Azure login. No matter how much I refresh, nothing shows up. I’ve already updated the Microsoft Authenticator app to the latest version from the App Store. However, my personal Microsoft account works fine and can log in without any issues.
Formula result not showing in cell
Attached is my code and the formula result showing 50%. But in the cell where the formula is located, it displays a 0%. I have tried formatting the cell to be a number, percentage, and everything else, yet it still does not put the formula result in properly. Am I missing something?Excel XIRR fails in Desktop & Online — ATP not binding, cloud profile corruption
I need help from the Excel engineering team. My Microsoft 365 account appears to have a corrupted Analysis ToolPak (ATP) function binding for XIRR at the cloud profile level. Symptoms: - =XIRR({-100,110},{1,2}) returns a long fallback constant instead of 0.1 - GET.CELL reports XIRR as invalid - Excel Online produces the same incorrect fallback value - Desktop Excel produces the same incorrect fallback value - A brand-new Windows user profile produces the same result - A full uninstall/reinstall does not fix it - ATP is enabled and ANALYS32.XLL is present - No Name Manager overrides, no LAMBDA overrides, no VBA, no add-ins - Dates are valid Excel serial numbers - All local Office registry keys, Feature Store, and activation tokens were wiped and rebuilt - Excel is fully activated and licensed - The issue persists across all environments Because Excel Online returns the same fallback constant, this is clearly not a local machine issue. It appears to be a cloud-side Excel profile corruption, specifically the ATP function registry for my Microsoft 365 account. Request: Please escalate this to the Excel service engineering team to reset/rebuild my Excel Online profile and ATP function map for my account. Thank you. Bob
SUMIF (or other function) if the cell value in either of 2 columns is >0
I want to sum the cells in column C if the row value in column A is >0 OR if the row value in column B is >0 (not AND). With SUMIF, I tried setting the search range to both columns A and B, but the result was very odd; I haven't yet figured out how SUMIF arrived at is sum. SUMIFS only works as AND, nor OR, to my knowledge. Thank you for your help.How to unlink cells in Format Control
I am developing a survey in excel (because the questions are complicated and long and do not format well in e.g. MS Forms) and using option buttons to choose responses. Each question has 6 potential responses. In developer I have inserted a group box, into which I placed 6 option buttons. After formatting the buttons so that they snap to the excel grid I then linked them to a cell to make calculating responses easier. On-line advice then suggested that I could copy and paste these to each new question. However, by doing this, I am only able to choose 1 option as they are ALL linked to the same cell. How do I unlink each group box of 6 option buttons so that I can link each group individually to a different cell for each question? Or - do I have to create a group box and option boxes from scratch for each question set? I have removed the questions for simplicity of view (note that there are 6 in Q1 and Q2 not visible) and highlighted the linked cell from Q1. As you can see - for Q5 this has given an answer of 26 (the 26th option button) rather than 2 (the 2nd button in Q5)How to restore a single file deleted 6 months ago - using M365 Backup?
My friend's company uses Sharepoint Online, but relevant folders are synced to their OneDrive so they manage everything in File Explorer. I have Microsoft 365 Backup enabled on their Sharepoint site. This company has all the parent folders in "Site Contents". These folders include Sales, HR, Clients, etc. I need to restore a single file out of Sales but it appears I need to restore the entire site first, sync the Sales folder from the site ending in /R0 to my OneDrive, then copy/paste from my File Explorer. Yes, I am a NOOB in Sharepoint. What's the right way to grab this file? And if it's ditching M365 Backup, then that's what I'll do, but I still need to get this file.
Excel formel
I am going to, have the same date pasted in about 50 places for labels. Request: I did Create a cell, AL2 - wrote, 27 Oct Then I want to create a formula in the 20 different places, that picks up 27 Oct from AL2, from the same Excel sheet. I have tried =!AL2, =$AL2... etc. but nothing works 🙁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.
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
