21,107 questions

Sort by: Updated
2 answers

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
asked 2026-11-18T16:29:43.81+00:00
Excel@excel 45 Reputation points
commented 2026-11-20T01:56:47.27+00:00
Excel@excel 45 Reputation points
1 answer

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
asked 2026-11-19T12:51:41.5333333+00:00
Schraff S 0 Reputation points
commented 2026-11-19T22:50:56.3333333+00:00
Ashish Mathur 102.6K Reputation points Volunteer Moderator
4 answers

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
asked 2026-10-14T16:11:30.66+00:00
Narciso Gonzalez 10 Reputation points
commented 2026-11-19T21:37:25.73+00:00
Robert Hoogstraat 0 Reputation points
2 answers

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
asked 2026-11-19T20:03:39.1166667+00:00
Kris Rooneem 0 Reputation points
edited an answer 2026-11-19T21:27:34.75+00:00
Deogratias 190 Reputation points Independent Advisor
2 answers

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
asked 2026-11-18T18:30:22.0466667+00:00
Gold Sparrow Insurance 0 Reputation points
commented 2026-11-19T18:54:43.53+00:00
Hani-Ng 2,935 Reputation points Independent Advisor
2 answers

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
asked 2026-11-19T15:14:21.6033333+00:00
Angela Mesenberg 0 Reputation points
answered 2026-11-19T17:04:06.2+00:00
Ruby Nguyen 3,920 Reputation points Independent Advisor
2 answers

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
asked 2026-11-18T07:32:02.4633333+00:00
Diaz Valencia, Leonardo 0 Reputation points
commented 2026-11-19T16:06:35.3133333+00:00
Diaz Valencia, Leonardo 0 Reputation points
2 answers

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
asked 2026-11-19T14:43:28.13+00:00
Osment Jacquelynn 0 Reputation points
answered 2026-11-19T15:24:13.8333333+00:00
Roebe Ta 2,180 Reputation points Independent Advisor
2 answers

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
asked 2026-11-18T13:45:40.7966667+00:00
Young Tara 20 Reputation points
edited a comment 2026-11-19T15:04:20.47+00:00
Aetherin 4,500 Reputation points Independent Advisor
2 answers

My Excel application is not opening.

My Excel is not working

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-11-19T12:12:35.78+00:00
Syed Wasif Uddin 0 Reputation points
answered 2026-11-19T12:31:16.8733333+00:00
Heimerdinger 1,805 Reputation points Independent Advisor
4 answers

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
asked 2026-11-17T16:16:19.17+00:00
Daniel Singh 0 Reputation points
commented 2026-11-19T09:39:07.8+00:00
Sabina Lagunilla 0 Reputation points
3 answers One of the answers was accepted by the question author.

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
asked 2026-07-25T03:00:21.3566667+00:00
Sirri Berat Cinkilic 105 Reputation points
answered 2026-11-19T08:33:52.12+00:00
Raselison Toky 0 Reputation points
1 answer

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
asked 2026-11-19T02:55:45.7633333+00:00
Vicky25 20 Reputation points
answered 2026-11-19T03:07:00.62+00:00
Ana Le 2,980 Reputation points Independent Advisor
1 answer

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
asked 2026-11-18T16:05:43.33+00:00
John Anderson 0 Reputation points
edited an answer 2026-11-18T22:15:03.3666667+00:00
Ivory 2,900 Reputation points Independent Advisor
2 answers

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
asked 2026-11-16T17:56:40.7133333+00:00
TERI RICE 40 Reputation points
commented 2026-11-18T18:23:23.98+00:00
Chris-D 2,710 Reputation points Independent Advisor
3 answers One of the answers was accepted by the question author.

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
asked 2026-09-16T14:00:06.71+00:00
Excel@excel 45 Reputation points
commented 2026-11-18T16:30:24.6733333+00:00
Excel@excel 45 Reputation points
2 answers One of the answers was accepted by the question author.

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
asked 2026-11-18T14:45:54.3233333+00:00
miciah paige 40 Reputation points
accepted 2026-11-18T15:17:02.93+00:00
miciah paige 40 Reputation points
1 answer

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
asked 2026-11-18T14:17:04.7066667+00:00
Brirkshied 0 Reputation points
answered 2026-11-18T14:38:35.54+00:00
BabybooHN 4,310 Reputation points Independent Advisor
2 answers

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
Microsoft 365 and Office | Excel | For business | Windows
asked 2024-07-02T11:15:45.3633333+00:00
Remster 0 Reputation points
answered 2026-11-18T14:17:28.15+00:00
Prisma Floor 0 Reputation points
2 answers

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
asked 2026-11-12T17:52:45.0066667+00:00
EORiggs 0 Reputation points
commented 2026-11-18T12:47:41.9866667+00:00
Aetherin 4,500 Reputation points Independent Advisor