3,740 questions with Excel-related tags

Sort by: Updated
Updated Created Answers
2 answers

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,805 questions
asked 2025-03-07T11:50:40.66+00:00
AW 0 Reputation points
answered 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,805 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 15,875 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,805 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 15,875 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 15,875 Reputation points Microsoft External Staff
0 answers

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,805 questions
asked 2025-03-13T07:42:57.4266667+00:00
Louis Diène Diatta 0 Reputation points
edited the question 2025-03-13T07:45:59.6733333+00:00
Louis Diène Diatta 0 Reputation points
0 answers

excel vba activateworkbook.save changes date format

I'm running a macro that creates a blank workbook using Workbook.Add and saves it in a specified location as a CSV (FileFormat:=xlCSV). It then copies data from another workbook into this sheet with formatting (Paste:=xlPasteValuesAndNumberFormats). Then…

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,805 questions
asked 2025-03-13T07:42:16.75+00:00
02773401 0 Reputation points
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,805 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 15,875 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,805 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
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,805 questions
asked 2025-03-12T16:08:50.59+00:00
Samuel Wolfe 0 Reputation points
answered 2025-03-13T07:31:58.1+00:00
riny 430 Reputation points
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,805 questions
asked 2025-03-12T21:39:36.81+00:00
Richard Leland 0 Reputation points
commented 2025-03-13T03:17:34.61+00:00
Richard Leland 0 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,805 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
1 answer

How to Display Full Data Results Instead of Preview in Excel Copilot's Advanced Analysis?

I am using advanced analysis in copilot through excel in order to use python to create a model that analyses my data. When I get my results printed in a new sheet, it only shows a preview, is there any way to avoid the results being shown in a preview…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,313 questions
Microsoft Copilot
Microsoft Copilot
Microsoft terminology for a universal copilot interface.
671 questions
asked 2025-01-30T14:37:55.8533333+00:00
Lucy Gardner 30 Reputation points
commented 2025-03-12T15:15:34.4266667+00:00
Lucy Gardner 30 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,805 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,805 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 15,875 Reputation points Microsoft External Staff
2 answers

Forecast sheet function in new excel, is possible to add different categories, like countries?

HiI want to know if is possible to add categories for projections, like countries or customers

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,805 questions
asked 2025-03-07T16:45:55.8066667+00:00
Riveri, Natalia 0 Reputation points
commented 2025-03-12T09:18:02.67+00:00
Jiajing Hua-MFST 15,875 Reputation points Microsoft External Staff
1 answer

I am trying to find a match of addresses in two tabs on same workbook. I have 174 addresses in one tab and 2000 in the other tab. I am trying to find if there are any matches between the two. How do I do this?

I am trying to compare and match of addresses in two tabs on same workbook. I have 174 addresses in one tab and 2000 in the other tab. I am trying to find if there are any matches between the two. How do I do this? So the example is Tab 1 - I have 2000…

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,805 questions
asked 2025-03-06T20:17:47.9066667+00:00
Chris Locarno 0 Reputation points
commented 2025-03-12T09:17:18.1566667+00:00
Jiajing Hua-MFST 15,875 Reputation points Microsoft External Staff
3 answers One of the answers was accepted by the question author.

Fill empty cells with the previous value

Hi group! In the attached example I would need to know if there is any way to fill the empty cells of the cod office field with the value of the last cell with value so that the result would be. I need this because I have to do it for…

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,805 questions
asked 2020-07-30T09:22:19.83+00:00
jm saf 166 Reputation points
commented 2025-03-12T08:47:09.14+00:00
Monette Marcelo 0 Reputation points
3 answers

Remove Excel COM Add-In permanently

Hi guys, There is an Excel COM Add-In that self-installs every time a user logs in to the system. In other words if it is removed manually it reappears next time a user logs in. Is it possible to remove it permanently?

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,805 questions
asked 2020-11-20T02:05:21.057+00:00
Cloud_Geek_82 896 Reputation points
answered 2025-03-11T13:06:13.3333333+00:00
Mikko Saarinen 0 Reputation points
4 answers

How can I get screentips or equivalent on shapes in excel 365

Help please In 2023 I wrote a genealogy spreadsheet with macro buttons on the sheets. I added an icon for each button with a screentip describing the button's function. The screentips worked 2 years ago but some update on 365 has disabled them despite…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,313 questions
asked 2025-02-13T09:44:59.8766667+00:00
Ken M Hanley 5 Reputation points
answered 2025-03-11T12:08:40.2833333+00:00
Rich Rider 0 Reputation points
3 answers

Excel Documents from SharePoint Online/Teams not opening from Browser.

When opening excel documents from SharePoint Online or Teams, the screen shows blank cells and displays "Loading" in the bottom-right corner. This issue SEEMS intermittent but mostly having the issue. Is there a known issue? How can I get…

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,805 questions
asked 2025-03-06T15:29:32.07+00:00
Sapp, Nicholas 0 Reputation points
answered 2025-03-11T09:59:17.2833333+00:00
Jiajing Hua-MFST 15,875 Reputation points Microsoft External Staff