A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
How to retract lines based on lowest RVu for each code.
Rules and scenarios A member can be paid only a maximum of 4 units per date of service, regardless of the combination of codes listed in Column F. Each code is on different claim lines. If more than 4 units are paid per date of service per member, the…
Microsoft 365 and Office | Excel | For business | Windows
Tracking weighted project completion without errors
I'm using Excel to track multiple projects, but not every task contributes equally to project completion. Each task has: A project name A status such as Not Started, In Progress, Completed, or Blocked An estimated number of hours used as the task…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Patch Regression: KB5002934 (October 2026) breaks copy/paste fix originally provided by KB5002665 in Excel 2016 MSI
Issue Description: The silent copy/paste failure in Excel 2016 (MSI) has returned immediately after installing the cumulative update KB5002934 (released October 13, 2026). Technical Analysis: Environment: Excel 2016 MSI (Traditional Volume License…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Unable to enable macros on excel file
I have a security risk message that says, "Microsoft has blocked macros from running because the source of this file is untrusted. And when attempting to follow the directions provided by Microsoft for this situation…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
EXCEL SHEET ON RECOVERY DATA
HELLO. MY EXCEL SHEET I CANT OPEN ITS SHOWS EMPTY BUT IT WAS FULL DATA ON THAT SHEET, I DONT KNOW WHERE IS MY DATE GONE IN THE EXCEL SHEET PLEASE HELP ME ASAP.
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
How to create a command cell for specific cells in a column
Is it possible to create a command cell where i can change the values for only some specific cells in a column?
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Version 2910 (Nov 10, 26) and Version 2911 can't run internal developed excel tool due the "running out or resources....."
Come on, Microsoft, really? A recent Microsoft 365 Office update was installed, and suddenly critical Excel-based tools that have been running reliably for years are no longer functional because Excel reports that it has run out of resources. We have…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
AutoSave disabled for larger Excel files in SPO. What actually causes it?
Hi all, We have several Excel workbooks stored in SharePoint Online, and AutoSave works normally for most of them. But with some of the larger files, AutoSave just isn’t available, even when opening them directly in the excel desktop app. Microsoft…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Missing region in a choropleth map in Excel
Hello, I would like to display a map of France showing its regions. I have converted the data into "geographical data." Each region appears to be "recognized" by Bing; however, when I display the map, the Bourgogne-Franche-Comté…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
My Excel application is not opening.
My Excel is not working
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Excel PDF Export Produces Blank Page When Conditional Formatting Icon Sets Are Present
I'm experiencing an unusual issue with Excel's PDF export functionality that appears to be specifically related to conditional formatting icon sets. Background: I have an Excel-based dashboard that uses formulas and conditional formatting to display…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
How can I find the best many-to-many invoice and payment matches without the result depending on row order?
Hi, I’m exploring a more complex invoice-reconciliation scenario in Excel as a learning exercise, and I’m trying to understand the correct approach. I have two tables. Invoices Invoice ID Customer ID Currency Invoice Date Due…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Excel is closed, and it does not show whether to save the text
excel point closes, does not show whether to save text, when this appears, you can edit the table and cannot edit, you can only close the table and then ALT+S save the table first and then reopen it to be normal, this problem appears a little more…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Copilot keeps undocking
How can i keep the copilot button from being undocked every time i open word or excel? it is very annoying to have to dock it every time. I don't use copilot, i use Claude and ChatGPT and copilot is just in the way.
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
xlsx converting large numbers to scientific when saving as a csv file
I have ID numbers that are 18 digits long. I am formating the column to Text, but when I save the file from an xlsx to a csv file, it changes the column to scientific, drops the last 5-10 digits and replaces them with zeros. How do I stop this? This…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
How to extract data from a column-complex formula perhaps?
Rule: A member can be paid a maximum of 4 units per date of service, regardless of the combination of codes listed in Column E(code). If more than 4 units are paid, the excess units are not payable and must be identified for retraction. Based on this…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
calculate invoice
Hi everyone, I'm creating an invoice tracker in Excel and would appreciate some advice. For example, invoice INV-1001 was issued on 10/01/2026 and was due on 10/15/2026, while INV-1002 was issued on 10/05/2026 and was due on 10/19/2026. Both are…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Frequency calculations - four versions with partly different results.
For the calculation of the age structure, I have placed different calculation methods (FREQUENCY(), IFS, PivotTables) next to each other, see Appendix. I noticed that the results are sometimes different. How can that be? Which version would be the…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Why does DATEDIF give different results in Excel and SharePoint?
The following formula gives different results in an Excel worksheet and a SharePoint list: =DateDif([Date_1],[Date_2],"md") There are ten cases where Excel gives a higher number than Sharepoint, and two cases where SharePoint gives a higher…
Microsoft 365 and Office | SharePoint | For business | Windows
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Excel Sorting Issue - Error on sort for complex numbers saved as text
I have a table with a listing of Standard Occupation Code (SOC) values. These numbers contain two digits followed by a hyphen, followed by 4 digits. Example: 99-9099. My issue is that a single cell value (11-1021) will not sort properly. All other values…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data