Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
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
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,312 questions
Microsoft Copilot
Microsoft Copilot
Microsoft terminology for a universal copilot interface.
665 questions
asked 2025-01-30T14:37:55.8533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 71%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELG%3C/text%3E%3C/svg%3E)
Lucy Gardner
25
Reputation points
answered 2025-03-12T15:07:38.9033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 83%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yildirim K
0
Reputation points
0 answers
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.
asked 2025-03-12T10:45:27.8466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 24%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIA%3C/text%3E%3C/svg%3E)
Isaac Ataide Somaconjamba
0
Reputation points
asked 2025-03-12T10:45:27.8466667+00:00
Isaac Ataide Somaconjamba
0
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 1%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
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
asked 2025-03-08T11:43:28.21+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 39%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Tommie Burger
0
Reputation points
commented 2025-03-12T09:19:10.4966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
15,870
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
asked 2025-03-07T16:45:55.8066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 98%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
Riveri, Natalia
0
Reputation points
commented 2025-03-12T09:18:02.67+00:00
Jiajing Hua-MFST
15,870
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…
asked 2025-03-06T20:17:47.9066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 31%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
Chris Locarno
0
Reputation points
commented 2025-03-12T09:17:18.1566667+00:00
Jiajing Hua-MFST
15,870
Reputation points Microsoft External Staff
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…
asked 2025-03-07T11:50:40.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 92%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
AW
0
Reputation points
commented 2025-03-12T09:16:02.4366667+00:00
Jiajing Hua-MFST
15,870
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…
asked 2020-07-30T09:22:19.83+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 71%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
jm saf
166
Reputation points
commented 2025-03-12T08:47:09.14+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Monette Marcelo
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
asked 2025-03-11T14:22:43.5033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 42%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIM%3C/text%3E%3C/svg%3E)
ian matthews
0
Reputation points
answered 2025-03-12T01:37:48.7766667+00:00
Jiajing Hua-MFST
15,870
Reputation points Microsoft External Staff
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?
asked 2020-11-20T02:05:21.057+00:00
Cloud_Geek_82
896
Reputation points
answered 2025-03-11T13:06:13.3333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 61%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
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,312 questions
asked 2025-02-13T09:44:59.8766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 24%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Ken M Hanley
5
Reputation points
answered 2025-03-11T12:08:40.2833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 55.00000000000001%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
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…
asked 2025-03-06T15:29:32.07+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 85%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Sapp, Nicholas
0
Reputation points
answered 2025-03-11T09:59:17.2833333+00:00
Jiajing Hua-MFST
15,870
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…
asked 2025-03-10T18:18:31.2766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 74%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Samuel Wolfe
0
Reputation points
edited a comment 2025-03-11T09:43:44.58+00:00
riny
430
Reputation points
1 answer
How to fix changing printing area in Microsoft Excel?
Hello everybody, i currently face the issue that my setting of the printing area changes after some time without changes on the document or the printer settings. I created a excel document as template where i did set up a range for a Din A4 page so the…
asked 2025-03-06T07:49:16.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Guido Seibel
0
Reputation points
commented 2025-03-11T08:56:33.15+00:00
Jiajing Hua-MFST
15,870
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
asked 2025-03-07T09:24:25.0933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 88%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nepa Renato
0
Reputation points
answered 2025-03-11T07:55:20.8766667+00:00
Nepa Renato
0
Reputation points
2 answers
Microsoft Excel Formulas: My formula is showing a different result than expected from a calculator
I'm making an excel spreadsheet calculating voltage values of a single phase rectifier system. However, the formula is outputting different values than expected. The above formula outputs However, the actual calculated value is 94V The intended formula…
asked 2025-03-11T05:24:05.13+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Danial Rizal
0
Reputation points
answered 2025-03-11T07:20:55.9866667+00:00
Emi Zhang-MSFT
28,666
Reputation points Microsoft External Staff
1 answer
One of the answers was accepted by the question author.
tfcofficeshim.connect.16 error
I get a "tfcofficeshim.connect.16" error when connecting to Azure Devops, I'm running Microsoft® Excel® 2019 MSO (Version 2502 Build 16.0.18526.20144) 32-bit Professional Plus. "Team" menu is often disabled, I need to enable it…
asked 2025-03-06T14:59:22.4866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 19%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELZ%3C/text%3E%3C/svg%3E)
Lorenzo Zambelli
65
Reputation points
accepted 2025-03-11T07:07:58.74+00:00
Lorenzo Zambelli
65
Reputation points
1 answer
Sometimes the autosum feature of my excel document does not work, any suggestions?
In some of my spreadsheets, my autosum feature will not work. All I get is a $0 even though I check that the cells I want are included. Has anyone else had this issue?
asked 2025-03-06T18:46:07.3433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 17%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kennedy Smith
0
Reputation points
commented 2025-03-11T07:00:10.8933333+00:00
Emi Zhang-MSFT
28,666
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,…
asked 2025-03-10T08:12:20.1366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 88%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
demosfen
0
Reputation points
answered 2025-03-11T02:42:13.7466667+00:00
Jiajing Hua-MFST
15,870
Reputation points Microsoft External Staff
0 answers
Office Scripts : Chart Data Labels "Values From Cells
I am trying to create an Automate Script in Excel that will generate and format chart. I am getting close, but I can't figure out how to set Data Label values. I want the same functionality as the Format Data Label/Label Options/Vale From Cells as…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
1,049 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,312 questions
asked 2024-09-30T20:07:14.6433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 80%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tim Smith
0
Reputation points
commented 2025-03-10T17:54:42.54+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 68%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Al Shahriar
0
Reputation points