1,812 questions with Excel Management tags

Sort by: Updated
Updated Created Answers
0 answers

Excel VBA IDE crashes when working with qualified fields

In Excel 2021 64-bit and Excel 365 64-bit, when stopped at a VBA IDE breakpoint outside a With...End WIth block, hovering over a qualified variable inside a With...End With block gets "Automation Error Exception Occurred”, and Excel crashes 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,812 questions
asked 2025-03-15T17:31:01.74+00:00
Chris Grossman 0 Reputation points
0 answers

MYEXCEL IS NOT WORKING HOW CAN I FIX THIS ISSUE

Empty Excel file is opened but file with data thast files are not opened . How can i fixed this issue . its 2016 ms office

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,812 questions
asked 2025-03-15T15:31:19.35+00:00
Subrahmanyam Maruboyina 0 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,812 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,812 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
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,812 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,812 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,812 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,812 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
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,812 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,812 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,812 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,812 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,812 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,812 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
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,812 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,812 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,812 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
1 answer

excel crashes / doesn't run w/WINDOWS 11 platform

Coworkers computer automatically updated to windows 11 and now Excel can't handle the most basic excel files much less files with formulas, links, etc. We have done the fixes listed that I can find. Is Microsoft going to fix this issue before windows…

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,812 questions
asked 2025-03-12T20:12:33.0066667+00:00
Julie Sasser 0 Reputation points
answered 2025-03-12T20:45:20.32+00:00
Michael Taylor 57,216 Reputation points
0 answers

Addin installation problem on Excel

Hello, on my computer with Windows 11 operating system is installed Excel 2013 and I would like to install the new updated version 1.10.14 of the MarketValues Addin which can be found at the link https://www.simpletoolsforinvestors.eu. Previously I have…

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,812 questions
asked 2025-03-12T10:39:24.77+00:00
Pao 0 Reputation points
1 answer

Name/Surname B18:B92 if match name/surname in E5:E15 points in D5:D15 copy to C18:C92

I must get a formula to use in C18:C92 for the following question: I have name/surname in B18:B92 and same name/surname in E5:E15. Points in D5:D15 and this points must be copy to C18:C92

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,812 questions
asked 2025-03-08T11:43:28.21+00:00
Tommie Burger 0 Reputation points
commented 2025-03-12T09:19:10.4966667+00:00
Jiajing Hua-MFST 16,120 Reputation points Microsoft External Staff