3,758 questions with Excel-related tags

Sort by: Updated
1 answer

Color coding a cell based on the contents of a different cell

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-18T23:40:59.6566667+00:00
Dee Cee 20 Reputation points
commented 2025-03-19T17:37:27.24+00:00
Dee Cee 20 Reputation points
0 answers

Cached credentials have expired - MAC

The workbook Im trying to work on says that the "cached credentials have expired" and it doesn't let me re sign in. I found ways to fix it on Windows but nothing on how to fix it for Mac. Im trying to collaborate with PC users from a Mac but…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-19T17:33:31.8966667+00:00
Juan José Solano 0 Reputation points
8 answers

How to fix error AADSTS500200: User account is a personal Microsoft account. Personal Microsoft accounts are not supported for this application

Sorry, but we’re having trouble signing you in. AADSTS500200: User account 'su***********@gmail.com' is a personal Microsoft account. Personal Microsoft accounts are not supported for this application unless explicitly invited to an organization. Try…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,917 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
23,704 questions
asked 2024-01-03T10:26:38.1066667+00:00
sumit 80 Reputation points
answered 2025-03-19T15:53:15.1133333+00:00
Adam Taylor 0 Reputation points
0 answers

Copied/cut cells, the dotted line around the cells not visible

Hello, I have M365, in excel I copy/cut cells, but I do not see the dotted border around the cells, that shows these cells are copied/cut. I restarted many times, I try to find any setup, but nothing helped. Do you know how to setup it? Thanks!

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-19T07:44:18.4966667+00:00
Balázs Szücs 0 Reputation points
commented 2025-03-19T11:12:35.12+00:00
Viorel 120.5K Reputation points
2 answers

MSFT wants me to buy 365 that I don't need

I need Excel to fill in numbers in my bank accounts for filing tax return and cannot do it since MSFT blocked my Excel that I bought as part of the Office. I'm 76 years old and I don't need all this fancy stuff in 365. How can I get my Office Excel and…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-05T22:25:20.51+00:00
Alex Orlov 0 Reputation points
commented 2025-03-19T09:06:42.1666667+00:00
Jiajing Hua-MFST 16,280 Reputation points Microsoft External Staff
1 answer

Excel Plus 2024 no me ejecuta las funciones

Buenos días, comparto el problema que tengo en Excel Plus 2024, al que me refiero en una anterior pregunta. Gracias, por ayudarme a solucionarlo. La función que aplico, en esta oportunidad, es SUMAR.SI.CONJUNTO, pero como esta depende de una base de…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-01T15:51:15.63+00:00
Martha Elena Pérez Murcia 0 Reputation points
commented 2025-03-19T09:03:18.49+00:00
Jiajing Hua-MFST 16,280 Reputation points Microsoft External Staff
2 answers

How to Display Time Duration on a Horizontal Bar Graph

Hello, I am a researcher attempting to display surgical times on a horizontal bar graph, with the times labeled on the x-axis in order to compare to eras of time (one from January to June and the other from July to December). I have taken a series of…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-10T18:18:31.2766667+00:00
Samuel Wolfe 0 Reputation points
commented 2025-03-19T05:56:33.67+00:00
Jiajing Hua-MFST 16,280 Reputation points Microsoft External Staff
3 answers

How to Get Horizontal Bar Graph to Realign with Data

Hello, I am trying to display data on a horizontal bar graph showing surgery duration and times, I have each time labeled as "start 2" and "finish 2" for the starting and finishing times, expressed in number format (1 being 24 hours,…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-12T16:08:50.59+00:00
Samuel Wolfe 0 Reputation points
commented 2025-03-19T05:52:16.0633333+00:00
Jiajing Hua-MFST 16,280 Reputation points Microsoft External Staff
2 answers

UNEXPECTED ERROR BUT NO PROBLEMS USING EXCEL

WHEN OPENING ANY EXCEL FILE THIS POPUP APPEARS. I CAN OPEN AND MODIFY THE FILES WITHOUT PROBLEMS, ONLY THE ERROR MESSAGE THAT CLICK ON OK AND IT IS CLOSED. WHAT IS THE PROBLEM?ERRORE.png

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-07T09:24:25.0933333+00:00
Nepa Renato 0 Reputation points
commented 2025-03-19T05:45:53.1033333+00:00
Emi Zhang-MSFT 28,971 Reputation points Microsoft External Staff
1 answer

How does Excel calculate the Alpha, Beta, Gamma parameters in the AAA-ETS algorithm?

FORECAST.ETS and other .ETS functions uses an AAA version of the Exponential Smoothing (ETS) algorithm. I have not found mentioning what specific parameters are used in these functions and the result in them differs from the results in the same functions…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-18T10:51:42.9533333+00:00
demosfen 20 Reputation points
answered 2025-03-19T05:31:33.5566667+00:00
Jiajing Hua-MFST 16,280 Reputation points Microsoft External Staff
2 answers

formula in google sheet won't work in excel

I am having trouble using a formula once used in Google sheets now in excel. I am trying to populate info from one sheet to another sheet in the file =if(B21="","",filter(indirect("Tx Acceptance…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-18T16:44:36.3533333+00:00
CatDaven604 0 Reputation points
answered 2025-03-19T02:34:18.36+00:00
Emi Zhang-MSFT 28,971 Reputation points Microsoft External Staff
1 answer

How to Retrieve Local and Web Paths of an Excel Workbook from OneDrive using JavaScript API

A OneDrive folder has been synchronized on a local machine, allowing workbooks to be opened directly from this folder. The local and web paths can be obtained using the Info => Copy path and Info => Copy local path options, as highlighted in the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,322 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
1,053 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,316 questions
asked 2025-02-18T16:52:25.0666667+00:00
Kashif Bashir Bhatti 36 Reputation points
answered 2025-03-18T08:52:54.53+00:00
Adrian Wu 0 Reputation points Microsoft Employee
1 answer

Error while sharing excel file OneDrive

The following error while sharing an Excel through…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-18T05:44:52.5233333+00:00
Ajay 0 Reputation points
answered 2025-03-18T07:35:42.5133333+00:00
Emi Zhang-MSFT 28,971 Reputation points Microsoft External Staff
1 answer

How to "stratify" data on a horizontal clustered bar graph

Hello, I am trying to display data on a horizontal bar graph showing surgery duration and times, I have each time labeled as "start 2" and "finish 2" for the starting and finishing times, expressed in number format (1 being 24 hours,…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-17T18:22:35.3766667+00:00
Samuel Wolfe 0 Reputation points
answered 2025-03-18T03:06:18.9866667+00:00
Emi Zhang-MSFT 28,971 Reputation points Microsoft External Staff
1 answer

Server Excel “file in use" by another user

Hi, I see that there are a lot of other posts on this issue. I have tracked my issue to the following. I need to start at the beginning. We purchased several new Windows PC's for the office. Our administrator turned on and configured each of the…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-17T18:26:33.52+00:00
Mike Condon 0 Reputation points
answered 2025-03-18T02:51:34.7833333+00:00
Jiajing Hua-MFST 16,280 Reputation points Microsoft External Staff
3 answers

Problem opening spreadsheets in Excel 2016 since Win 11 24H2 upgrade

We have just updated to Win 11 24H2 and use stand alone Office 2016 Standard. We are experiencing problems with opening Excel spreadsheets from hyperlinks and File Explorer where a ~$ temp file pre-exists against the file we are trying to open. Excel…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
11,128 questions
asked 2024-11-22T11:11:37.2566667+00:00
Alan Lee 15 Reputation points
commented 2025-03-17T16:46:20.5933333+00:00
José Fires 0 Reputation points
2 answers One of the answers was accepted by the question author.

I am having a trouble with the Autosave with one specific Microsoft excel Spreadsheet on my windows 11 computer

I am having a trouble with the Autosave with one specific Microsoft excel Spreadsheet on my windows 11 computer. I have never changed the way the shared spreadsheet is used, however a few days ago, the autosave ceased to function. I do not believe the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,322 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,230 questions
asked 2025-02-15T15:32:58.3533333+00:00
Christopher Fox 25 Reputation points
commented 2025-03-17T13:23:53.2666667+00:00
Gabriel Ramirez 0 Reputation points
1 answer One of the answers was accepted by the question author.

BESSELI, BESSELJ functions return inaccurate result

BESSELI, BESSELJ functions return inaccurate result in compare to the results of other editors and libraries. For example results in excel: =BESSELJ(1.9, 2) - 0.329925828669785 =BESSELI(1.5, 1) - 0.98166642847516605 But results in libreoffice,…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-10T08:12:20.1366667+00:00
demosfen 20 Reputation points
accepted 2025-03-17T08:29:33.13+00:00
demosfen 20 Reputation points
1 answer

How does the rounding of the number with a floating point work in the Excel?

I encountered some unexpected behavior in Excel—writing numbers to a file and their representation in the editor differs from what I expected. For example, the result of the multiplication =0.6 * 3 will be 1.8 in the cell, but 1.7999999999999998 in the…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-14T10:41:44.3866667+00:00
demosfen 20 Reputation points
commented 2025-03-17T07:55:38.7733333+00:00
Jiajing Hua-MFST 16,280 Reputation points Microsoft External Staff
0 answers

How to sort data in Exel table.

I can not rearrange the data in Exel table where alphabetic order is needed.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,823 questions
asked 2025-03-17T03:12:10.6233333+00:00
satok1126 0 Reputation points
commented 2025-03-17T07:00:20.66+00:00
Emi Zhang-MSFT 28,971 Reputation points Microsoft External Staff