sort by column then by numbers in a row
HI all I have a table of results pictured here. Once the results are in, I sort the table by the Total Score Column. When we have a tie (as in line 3 & 4, I need to sort by who has the most highest score... so, who has the most 9 (equal here), then by most 8.5 (line 4 wins the tiebreaker, 4 over 2) Can I do this so it doesn't affect the order of the columns but just the rows involved.
Dynamic Column cell reference with autofill
Hi, I want to increase the column reference in a formula by 2 columns as it is copied across columns. So in Column A the formula is =SUM(D3:E3) When I fill this across Column B I want the formula to be =SUM(F3:G3) I have experimented with the INDEX and COLUMN functions but not been able to get the intended result.
Cannot install addins
I am a Microsoft 365 Personal user. When I try to add the Claude for Excel Addin (for the Desktop version of Excel), I get an error: "Error loading add-ins. One or more add-ins failed to load. See your add-ins.". However, this is not specific to the Claude addin, since every addin gives the same error. When I click on the My-Addins option and then "refresh", I get another error: "Access denied to catalog." Signing in and out of Office does not fix the issue. Clearing the Office 365 cache did not fix the problem. The issue extends to Powerpoint and Word as well. I cannot add any addins to the web versions of Office either. Interestingly, if I download an XML manifest file, I can use the "Manage my addins" option in the web versions of Office 365 to manually add the addins. But still no luck with the Desktop versions. Anyone have any thoughts on how to fix this? Do I need to manually reinstall Office 365? I also noticed that the "Get Add-ins" button in "Account" settings is disabled.
Copilot icon missing in Excel Ribbon
Hello. I have a problem where the Copilot icon is missing from my ribbon in Excel. It showed up before on one of my accounts but then it disappeared the same day. I was wondering if anyone could please help me fix this and get the Copilot icon back in the ribbon. Thank you.
Excel 365: dd-mmm-yyyy now gives Sept instead of Sep
Excel 365: dd-mmm-yyyy now gives Sept instead of Sep — that breaks the documented format standard. Who thought this was a good idea? They linked it to the Unicode locale standard. But it violates the formatting of "mmm". Work arounds for USA locale format as [$-409]dd-mmm-yyyy → 05-Sep-2025 UK locale [$-809]dd-mmm-yyyy → 05-Sep-2025 AU [$-C09]dd-mmm-yyyy → 05-Sep-2025 NZ [$-1409]dd-mmm-yyyy → 05-Sep-2025 Problem is this is not portable. PLease can someone reach out to the devs and get this reverted? Formulas trying to pick out Sep & year from the string now will break.
How to add a new month to the existing bar graph?
Question: How to add a new month to the existing bar chart? I have 3 rows. Oct 2025, April 2026, May 2026 The headings are: Month, Start Value, End Value, Change The bar chart has the 3 start values and then the 3 end values then the 3 change I added a 4th row and the formulas and they change values as they should. The June values are just dummy values. But I do not know how to add the 4th month to the existing bar chart that updates as well. I can create a new one but then I have to re-create the chart details.
Names in Excel Name Manager
I have a spreadsheet ( I will call it spreadsheet "A") driven by macros that creates a new worksheet each month. I am developing a second spreadsheet I will call it spreadsheet "B") that links to it for a monthly summary. I have given all the cells names that are to be linked. The issue I am dealing with is when a new monthly tab is created on "A", I want the links from "B" to be updated to the new month. The approach I am taking is to delete all of the names in "A" and recreate them for the new month. (The reason I want to delete the older names is because over time, the Names list would grow into a very large list of obsolete names). The problem I am encountering is that when a name is deleted, a dialog box appears that the user has to acknowledge that, Yes, I want to delete this name. I want to make this process transparent to the user. So, my question is: Can I delete a name without generating this dialog box?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?
