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…
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…
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!

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 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…
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…
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,…
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

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…
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…

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…
Error while sharing excel file OneDrive
The following error while sharing an Excel through…

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,…

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…
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…
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…
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,…
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…
How to sort data in Exel table.
I can not rearrange the data in Exel table where alphabetic order is needed.
