Recent Discussions
Excel returns incorrect answer to simple multiplication.
I'm saving a few favourite math examples, and ran into a problem - the last of the calculations came back with an incorrect answer. I'm using a simple =cell1*cell2 formula. It should end with 21. Please help I'm using android app. All cells formatted as numbers.
Trying to create a form field that uses images (but not a simple one!)...
I have a Word form that uses a https://www.fema.gov/emergency-managers/practitioners/lifelines-toolkit/lifelines-icons used in the public safety community. For each icon, there are four different border colours, indicating a certain level of urgency, using the TLP model - green, yellow, red, grey. What I would like to do is create a dropdown (elsewhere on the form) where someone chooses an option in that field, and depending on the choice, the icon with the corresponding colour displays. Example: Any assistance is appreciated!Link 2 sheets, then sort column A on sheet 2 alphabetically and match correct data
I have two sheets on the same spreadsheet, and I want to pull in the data from 4 different columns to the second sheet and have it automatically update when there are changes or additions to the first sheet. I have a couple issues making this happen - the main one is that the data in my first sheet is custom sorted by color, but I want the new sheet to take the data from column B on sheet 1 and sort it alphabetically, and take the other columns and match them correspondingly to the correct values they match to from column B on the first sheet. Secondly, for blank cells, I want it to leave them blank instead of inputting zero, or any dates. I don't know if this is all even possible, or if I should just remove my custom filters from sheet 1 by cell color and just link it that way. I've spent hours trying to find formulas that work. Please see attached images for reference on what I've tried, and for more clarification as to exactly what I'm requesting. Sorry for the copious redacting, I wanted to be safe rather than sorry with identifiable info regarding this. Any help would be greatly appreciated.
Link doesn't work
We have recently started experiencing an issue when opening links within Excel on Azure Virtual Desktop. Our AVD environment is currently running the Version 2601, but the behaviour is very inconsistent, only a couple of users are affected, and the issue appears completely random. Interestingly, it works fine for most users both inside AVD and outside AVD. Affected users are receiving the following error message (screenshot below). So far, I have tried the following without success: Clearing the Excel cache Deleting the Excel container from the registry: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel Is anyone else experiencing the same issue, or aware of a fix/workaround? Any help would be greatly appreciated.
Excel AND Formula displaying FALSE when it should be TRUE
I'm doing the CENGAGE Excel Assignment 2. I'm supposed to use the AND Formula like this: AND([Project Type]="Drama",[Approved?]="No" in the newly created "Delay?" column. But all the results are FALSE even when both conditions are met. Can someone explain to me why the logic is not adding up?
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)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
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
- 2 MIN READWelcome to the February 2026 update. This month we are excited to announce expanded availability for Agent Mode in Excel, as well that you can now query modern Excel workbooks (like .xlsx, .xlsb, .xl...Feb 24, 2026
- We are continuing to streamline the ways people engage with Copilot in Excel, and we've heard your feedback that working across multiple Copilot entry points can feel fragmented. To address this, Cop...Feb 24, 2026
