3,745 questions with Excel-related tags

Sort by: Updated
Updated Created Answers
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,810 questions
asked 2025-03-14T10:41:44.3866667+00:00
demosfen 0 Reputation points
answered 2025-03-14T18:28:28.0033333+00:00
Barry Schwarz 3,651 Reputation points
2 answers

Which is best document intelligent service to read inconsistent table data from excel

Which is best document intelligent service to read inconsistent table data from excel

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,810 questions
asked 2025-03-14T14:42:02.1233333+00:00
Gawade, Vasant 0 Reputation points
answered 2025-03-14T17:14:41.47+00:00
Mohan Reddy K 0 Reputation points
2 answers

Please Help me - How can I fix the 'Culture is not Supported' error when importing an Excel file to a database in SQL Server Management Studio

I have tried countless times to import an Excel file via the SSMS application interface and keep getting the below error. Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE [dbo].[CovidDeaths$] ( iso_code] NV . "…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
asked 2023-07-14T09:26:27.05+00:00
Nnamani Chisom Promise 35 Reputation points
commented 2025-03-14T13:13:37.65+00:00
Daniel Odoh 0 Reputation points
3 answers

Office 365 Apps suddenly crash and close

Dears, My Office 365 always crashes. I've already removed it and installed the latest version but the problem still persists.. Please assist.

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,768 questions
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
12,077 questions
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
Outlook
Outlook
A family of Microsoft email and calendar products.
4,503 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2023-07-17T09:54:46.05+00:00
Ibrahim Haidari 0 Reputation points
edited a comment 2025-03-14T12:54:17.14+00:00
Clive Holt 5 Reputation points
13 answers

Error Another account from your organization is already signed in on this device. Try again with a different account.

Hello, I keep getting the error - "Error Another account from your organization is already signed in on this device. Try again with a different account." I've been trying to use all of the tips, tricks, and fixes available online, but nothing…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
960 questions
OneNote
OneNote
A family of Microsoft products that enable users to capture, organize, and reuse notes electronically.
231 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,895 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2023-02-17T17:42:05.4166667+00:00
Sarah Nelson 85 Reputation points
edited a comment 2025-03-14T08:48:05.67+00:00
BB 0 Reputation points
0 answers

I have an idea

Idea: I suggest allocating some cloud storage for Excel and Word to automatically save changes for at least one day. This would be helpful because users often forget what changes they made, but it can be important to review and track recent edits.

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,810 questions
asked 2025-03-14T08:35:03.0066667+00:00
Hadis Akbari Beni 0 Reputation points
1 answer

For fonts only, how to add DARK red (or any shade) to the ribbon/menu bar. It's annoying to have search for a shade.

How to add DARK red (or any shade) to the ribbon/menu bar. It's annoying to have search for a shade.

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,810 questions
asked 2025-03-13T21:27:08.0866667+00:00
John Connell 0 Reputation points
answered 2025-03-14T07:49:01.9766667+00:00
Emi Zhang-MSFT 28,746 Reputation points Microsoft External Staff
1 answer

excel 2016 vl fail 24H2

We have just updated to Win 11 24H2 and use Office 2016 Standard volume licensing . We are experiencing problems with opening Excel spreadsheets from hyperlinks, etc.

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,810 questions
asked 2025-03-13T20:25:06.39+00:00
Elvis Valencia 0 Reputation points
answered 2025-03-14T07:29:31.6266667+00:00
Emi Zhang-MSFT 28,746 Reputation points Microsoft External Staff
3 answers

Azure Analysis Services and Excel - Maximum Page Size of the Storage Object

I am unable to query an Azure Analysis Services model from Excel. I receive the following error: Memory error: A record (99909 bytes) was encountered that exceeds the maximum page size of the storage object (65528 bytes). Is there a setting I can use…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
476 questions
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,810 questions
asked 2021-01-20T22:56:13.623+00:00
Gary Lock 16 Reputation points
answered 2025-03-14T03:20:15.14+00:00
Denis Dyomin - Hoyer 0 Reputation points
7 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,647 questions
asked 2024-01-03T10:26:38.1066667+00:00
sumit 70 Reputation points
commented 2025-03-14T02:59:31.2033333+00:00
Jovi Isorena 20 Reputation points
1 answer

Problem with shared documents outside our organization- it says too many requests

Hello, we have been sharing some excellent files for non office users- view only. Since Monday the users are unable to open them- it says too many requests, ID korelace: 64218aa1-404d-c000-2395-f1701b683599. We have tried copying the files and saving…

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,810 questions
asked 2025-03-13T14:43:29.4433333+00:00
Tamara Chmelinová 0 Reputation points
answered 2025-03-14T02:59:20.7633333+00:00
Emi Zhang-MSFT 28,746 Reputation points Microsoft External Staff
1 answer

Comment annuler la modification du type de données de colonne dans Power Query?

Comment annuler une action dans Power Query? Ctrl Z ne semble pas fonctionner pour cela.

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,810 questions
asked 2025-03-13T07:42:57.4266667+00:00
Louis Diène Diatta 0 Reputation points
edited an answer 2025-03-14T01:38:23.78+00:00
Emi Zhang-MSFT 28,746 Reputation points Microsoft External Staff
2 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,810 questions
asked 2025-03-12T16:08:50.59+00:00
Samuel Wolfe 0 Reputation points
commented 2025-03-13T17:42:54.7+00:00
Samuel Wolfe 0 Reputation points
1 answer

Power Query returns null in some (but not all) columns when the name of the file is changed, why?

I have some files that I have combined in power query. These are 9 files that will need to be downloaded at least once a day so I could do without having to rename them. I then merge these with a couple of other files. The 9 files sit in a folder so I…

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,810 questions
asked 2025-03-07T11:50:40.66+00:00
AW 0 Reputation points
commented 2025-03-13T11:24:18.8933333+00:00
AW 0 Reputation points
1 answer

Using formula in Excel - having entered the formula how do I get to display the answer so it updates when I change the data

Setting up formula in a workbook. Formula is correct and I want to display the result but without impacting on the formula - which I want to update automatically whenever I change the data

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,810 questions
asked 2025-03-11T14:22:43.5033333+00:00
ian matthews 0 Reputation points
commented 2025-03-13T09:08:34.2033333+00:00
Jiajing Hua-MFST 16,120 Reputation points Microsoft External Staff
1 answer

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,810 questions
asked 2025-03-10T08:12:20.1366667+00:00
demosfen 0 Reputation points
commented 2025-03-13T09:07:29.7366667+00:00
Jiajing Hua-MFST 16,120 Reputation points Microsoft External Staff
1 answer

Autosave Onedrive and Sharepoint Online files option missing completely

Hello, I can't seem to be able to enable the Autosave button. It doesn't show up at all in the Quick Access Toolbar in Excel. But it also doesn't show up as an option to check in Excel->File->Options->Save. I am logged on my OneDrive Account…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,768 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2025-01-20T14:41:13.7533333+00:00
Ioana M 0 Reputation points
commented 2025-03-13T09:05:40.7233333+00:00
Jiajing Hua-MFST 16,120 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,810 questions
asked 2025-03-10T18:18:31.2766667+00:00
Samuel Wolfe 0 Reputation points
commented 2025-03-13T07:41:14.3266667+00:00
Jiajing Hua-MFST 16,120 Reputation points Microsoft External Staff
1 answer

how to fix error message, sorry, we couldn't find C:\windows\System32\file name.xlsm. is it possible it was removed, renamed or deleted

i have an excel saved on the C:\windows\System32\ but when i try to open it brings the error message, is it possible it was removed, renamed or deleted. i also attached the error. i need support on how to fix this issue. thanks for all the support.

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,810 questions
asked 2025-03-12T10:45:27.8466667+00:00
Isaac Ataide Somaconjamba 0 Reputation points
answered 2025-03-13T07:38:10.6933333+00:00
Emi Zhang-MSFT 28,746 Reputation points Microsoft External Staff
1 answer One of the answers was accepted by the question author.

Excel Help Please

In Excel, how do I change a number from 0.370 to just 370?

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,810 questions
asked 2025-03-12T21:39:36.81+00:00
Richard Leland 20 Reputation points
commented 2025-03-13T03:17:34.61+00:00
Richard Leland 20 Reputation points