1,649 questions with Excel Management tags

Sort by: Updated
Updated Created Answers
1 answer

Windows installer 7b6e8.msi - Excel 2003

Hi I am using Excel 2003 for long time now. Since last 6 months, when I try to open this program, every week (approximatively), I got on my screen the following: "Do you want to allow this app to update software on your device:…

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,649 questions
asked 2021-03-08T08:59:13.213+00:00
Michel Madar 1 Reputation point
commented 2021-03-17T08:51:58.513+00:00
Emi Zhang-MSFT 22,086 Reputation points Microsoft Vendor
1 answer

Excel Formula that will keep 0 decimals

Is there an Excel formula that will allow me to keep decimal places? For example, my cell U2 has a value of 4.00. However when I incorporate that into a CONCAT statement, it truncates the .00 and I don't want it to do so because I need to pass those…

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,649 questions
asked 2021-03-02T22:59:35.773+00:00
Bobby P 221 Reputation points
commented 2021-03-17T08:50:41.41+00:00
Emi Zhang-MSFT 22,086 Reputation points Microsoft Vendor
1 answer

Power pivot freeze when refreshing

I'm using Excel 2019, when refresh power pivot with external excel sheet data source being occupied by other user in local network, Excel gets freeze everytime. I used to use Access with linked excel files, when the excel file is being opend by other…

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,649 questions
asked 2021-03-01T19:39:22.113+00:00
clf 1 Reputation point
commented 2021-03-17T08:50:29.497+00:00
Emi Zhang-MSFT 22,086 Reputation points Microsoft Vendor
1 answer

crash windows after launching excel (or launching macro)?

My pc will go to blue screen after launching excell or using macro in it. This happens after the last windows update

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,649 questions
asked 2021-03-12T08:10:18.057+00:00
Simone Gnoato - Tecnoacciai 1 Reputation point
commented 2021-03-17T07:20:03.733+00:00
Simone Gnoato - Tecnoacciai 1 Reputation point
2 answers

My powerquery can not read PDF anymore

My excel power query used to have the ability to load PDF file as data source, but recently I found there is no such option in it, and the function Pdf.Talbes can not be recognized in the editor.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,279 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,649 questions
asked 2021-03-11T10:05:43.407+00:00
立瀛 王 1 Reputation point
commented 2021-03-17T01:36:48.953+00:00
Emily Hua-MSFT 27,546 Reputation points
2 answers One of the answers was accepted by the question author.

I would like to now if it is possible to copy cell values in Excel from one cell to another cell based on the properties of a text string. For example only Red text or Bold type text.

I want to automate the process in Excel of copying text strings from one cell to another cell based on the text properties. A cell can contain long text strings with parts of the text as bold or with a red color. Is it possible to select text based on…

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,649 questions
asked 2021-03-08T10:05:22.533+00:00
Rini Schuiling 21 Reputation points
accepted 2021-03-15T15:42:20.747+00:00
Rini Schuiling 21 Reputation points
1 answer One of the answers was accepted by the question author.

Calculated Column Not Updating

I created a calculated column based on a [Start Date] column and Today's date, it works alright, but it stops automatically updating the contents of the cell as time passes, only after I edit the a row does it make the update. The formula is as below:…

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,649 questions
asked 2021-03-09T08:35:46.893+00:00
Frank Moleni 21 Reputation points
commented 2021-03-14T03:48:21.85+00:00
Lz._ 8,991 Reputation points
2 answers

get Microsoft Office programs on new computer

I have a Microsoft subscription already, and want to get the Microsoft Office programs on my new computer. Can you send me info or can I find an instruction about how to download and install these latest Microsoft Office programs via my existing…

Windows 10 Setup
Windows 10 Setup
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
1,909 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,649 questions
asked 2021-02-18T02:04:33.073+00:00
Kent McKay 1 Reputation point
commented 2021-03-11T08:42:25.687+00:00
Karlie Weng 14,721 Reputation points Microsoft Vendor
0 answers

Error 372, Print Spooler Operation Failed

Independent Advisor - Charlie Klausen - Recommended deleting TMP files to solve print crashes in MS Office. The road map to success is: c:\windows\system32\spool\PRINTERS\ (delete TMP files).

OneDrive Management
OneDrive Management
OneDrive: A Microsoft file hosting and synchronization service.Management: The act or process of organizing, handling, directing or controlling something.
1,139 questions
Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
897 questions
PowerPoint Management
PowerPoint Management
PowerPoint: A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.Management: The act or process of organizing, handling, directing or controlling something.
222 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,649 questions
asked 2021-03-11T00:13:15.237+00:00
Rodger Le Noue 1 Reputation point
commented 2021-03-11T07:25:05.46+00:00
Erin Ding-MSFT 4,456 Reputation points
2 answers One of the answers was accepted by the question author.

3d maps Excel region does not show

My Problem is that in the Excel 3D maps, the region map does not seem to work. When I choose the either barrs or heat map, my data is shown on the map, but when I choose the region display, the map remains empty ![75464-image.png][1] [1]:…

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,649 questions
asked 2021-03-08T13:14:19.81+00:00
WIESSING Arthur 21 Reputation points
accepted 2021-03-11T06:15:04.697+00:00
WIESSING Arthur 21 Reputation points
1 answer

Hi, how can i get rid of it ? it shows everytime and excel then crashes.

does it shows to anyone else ?

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,649 questions
asked 2021-03-02T21:06:27.787+00:00
Sestak Michal 1 Reputation point
commented 2021-03-11T02:03:30.16+00:00
Emily Hua-MSFT 27,546 Reputation points
1 answer

XLOOKUP not finding true matches

Is it possible for the xlookup formula to not find true matches when there actually are? We have a file with ~300k lines, when we type in our xlookup formula and double click the bottom right corner of the cell the formula is in, it appears to…

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,649 questions
asked 2021-03-04T17:21:54.2+00:00
Webb,R 1 Reputation point
commented 2021-03-11T01:55:55.617+00:00
Emily Hua-MSFT 27,546 Reputation points
8 answers One of the answers was accepted by the question author.

Excel not opening properly after Intune rollout

Hi, I have been experiencing an issue recently where I open Excel and I can see the process start in Task Manager (with about 30-40% CPU usage) however the application doesn't open. I have been able to get around it by performing a Quick Repair which…

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,649 questions
asked 2020-12-08T13:00:33.903+00:00
Kyle Moody 111 Reputation points
answered 2021-03-10T19:14:20.163+00:00
Kismat Cheema 11 Reputation points
4 answers One of the answers was accepted by the question author.

Copy date in columns

![75553-image.png][1] How do I take the data in the I column and copy it below as a seperate line item. I want Davidson to look like Community School, with the school name on each line and a SN oneach line. [1]:…

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,649 questions
asked 2021-03-08T20:28:17.137+00:00
Joseph McCartney 21 Reputation points
commented 2021-03-10T05:16:27.977+00:00
Lz._ 8,991 Reputation points
1 answer

excel messy code

everytime I tried to open an excel fire uploaded from my company's ERP system, it comes up with messy code and I can't fix it. what should I do?

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,649 questions
asked 2021-03-05T07:11:43.977+00:00
陈墨 1 Reputation point
answered 2021-03-09T10:34:23.66+00:00
Emily Hua-MSFT 27,546 Reputation points
3 answers One of the answers was accepted by the question author.

How to create Defined Name with table name in Name Manager

Hi, how can I create a table name, which is indicated by a table name icon (in red rectangle) on picture below? I tried everything, but it still only create a defined name (not in red rectangle). Please, help me.

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,649 questions
asked 2021-03-05T14:21:53.093+00:00
SC 146 Reputation points
commented 2021-03-09T01:19:46.563+00:00
Erin Ding-MSFT 4,456 Reputation points
2 answers One of the answers was accepted by the question author.

Excel 2010 web query

I'm attempting to use the Excel web query to download info from a Google Sheet. The internal browser downloads the sheet, but instead of allowing me to select data and insert in current page, the Open/Save dialog appears. If I select Save, it saves in a…

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,649 questions
asked 2021-03-07T04:18:05.677+00:00
Al Vazquez 21 Reputation points
accepted 2021-03-08T23:30:00.92+00:00
Al Vazquez 21 Reputation points
2 answers

Using Excel built in functions with MIN and IF with multiple conditions

So I'm trying to figure out if I need to use the MIN function and IF function separately or together or an entirely different function for my problem. I'm trying to find the minimum value in several ranges (i.e. I3:I54,J3:J54,K3:K54,L3:L54,M3:M54) but…

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,649 questions
asked 2021-02-23T19:18:22.473+00:00
Mikeska, Jack 1 Reputation point
commented 2021-03-06T10:21:07.597+00:00
Lz._ 8,991 Reputation points
1 answer

Investment Tracker template; Australian content

The Investment Tracker template seems to have available information for listed securities; those listed on the Australian Stock Exchange. For the USA, this seems to include mutual funds. In Australia though, this would seem only to include exchange…

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,649 questions
asked 2021-02-23T04:38:30.083+00:00
Simon Tomkinson (Wealth and Security Planners) 1 Reputation point
commented 2021-03-05T10:29:19.957+00:00
Emily Hua-MSFT 27,546 Reputation points
2 answers

Dezimaltrennzeichen ändern, ohne Änderung Zahlen

Hallo zusammen, Ich habe mit Zahlen gearbeitet die als Dezimaltrennzeichen einen Punkt hatten. In meinen Einstellungen war dies jedoch als Tausendertrennzeichen vermerkt und die Zahlen sind nun "falsch" (aus einer 1 wird eine 1000). Wenn ich…

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,649 questions
asked 2021-02-26T10:19:28.62+00:00
Fuchsi 1 Reputation point
commented 2021-03-05T02:53:17.683+00:00
Erin Ding-MSFT 4,456 Reputation points