1,725 questions with Excel Management tags

Sort by: Updated
2 answers

Excel - how to convert dd-mmm-yyyy to dd/mm/yyyy

My date format is now 01-Oct-2024, how can i use excel formula to change to 01/10/2024 dd/mm/2024

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 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,725 questions
asked 2024-10-25T08:56:29.37+00:00
nononame2021 256 Reputation points
commented 2024-11-05T07:05:28.8933333+00:00
Jiajing Hua-MFST 10,565 Reputation points Microsoft Vendor
1 answer

Pivot Table doesn't count all data

Everything in the table is mostly correct except the ones with the correct numbers on the right. I kept refreshing the data, but it's still not giving me the correct data and I don't know why. For the count, it's counting every…

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.
3,974 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,725 questions
asked 2022-08-02T16:34:50.957+00:00
jellyfish 1 Reputation point
commented 2024-11-02T16:13:06.0966667+00:00
NancyR4 0 Reputation points
4 answers

Otra cuenta de tu organización ya inició sesión en este dispositivo. Intentalo de nuevo con otra cuenta.

mi office no me deja ingresar Correlation Id: 76bf7b82-af8c-5640-bd8c-c46d8a8d3b01 Timestamp: 2023-05-08T13:02:52.000Z DPTI: 0eb6fbfed0064a71e4f84f24bf3e853acbd48b6bed4f2bcdab4f7aef376e507e

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,725 questions
asked 2023-05-08T13:09:11.0033333+00:00
Maria Victoria Mosquera 10 Reputation points
answered 2024-11-02T15:14:37.7833333+00:00
HELEN JOHANNA ALVAREZ VÁSQUEZ 0 Reputation points
1 answer

how to combine all sheets in power query

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 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,725 questions
asked 2024-07-11T07:30:33.8266667+00:00
slardar22 0 Reputation points
edited the question 2024-10-31T16:23:16.34+00:00
simo-k 555 Reputation points
5 answers

Doesn't show the AutoSave button

Hi........! Please answer me, My MS Excel doesn't show the AutoSave icon/ (on and off button) on the top of the left-hand corner. why so that? please give me a solution. My other MS Office products (MS Word, Powerpoint, etc.... are shown it). please sort…

Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
7,090 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,725 questions
asked 2022-07-17T12:56:53.9+00:00
Amila Weerasekara 1 Reputation point
commented 2024-10-31T13:42:18.5033333+00:00
David Evans 0 Reputation points
2 answers

How to calculate the date difference excluding weekend and public holidays for specific date format

I have the following date format , but I can't use these date format to calculate the date difference excluding weekends and holiday. The two date is input as 01-Oct-2024 and 15-Oct-2024. The result should be 9. However, when I use excel function…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 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,725 questions
asked 2024-10-24T09:10:44.09+00:00
nononame2021 256 Reputation points
commented 2024-10-31T01:14:25.83+00:00
Jiajing Hua-MFST 10,565 Reputation points Microsoft Vendor
2 answers

Excel's default workbook calculation keeps changing to manual

Got myself a new laptop, after installing Office 365, my Excel's default workbook calculation keeps changing to manual, even though I did not open a file which had manual calculations saved before. Even after I change the settings to be automatic…

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,725 questions
asked 2022-03-23T01:58:38.083+00:00
Arthur 1 Reputation point
answered 2024-10-30T17:31:00.5266667+00:00
Phillip Llacuna 0 Reputation points
1 answer

Formula problem Excel

Can you please help me? I have a table where columns A and B are combinations of 12 to 19 numbers, and I need to obtain the common number between columns A and B. Any help is appreciated.

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,702 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 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,725 questions
asked 2024-10-29T14:39:36.5666667+00:00
KOE NATE 0 Reputation points
answered 2024-10-30T01:33:38.0733333+00:00
Barry Schwarz 3,071 Reputation points
3 answers

Delete multiple members of distribution group using CSV thru Exchange Management Shell On Premise

I received a request from our employees to delete all the members of this particular distribution group within our organization, and upon checking this DL has a total of 7,000 members. Is there any powershell script I can use to delete just the members…

Exchange Server
Exchange Server
A family of Microsoft client/server messaging and collaboration software.
1,334 questions
Exchange Server Management
Exchange Server Management
Exchange Server: A family of Microsoft client/server messaging and collaboration software.Management: The act or process of organizing, handling, directing or controlling something.
7,662 questions
Microsoft Exchange
Microsoft Exchange
Microsoft messaging and collaboration software.
561 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,725 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,579 questions
asked 2023-03-02T02:49:39.17+00:00
Gatchalian, AD 25 Reputation points
answered 2024-10-29T15:39:40.9266667+00:00
Hilton, Brett 0 Reputation points
1 answer

Too much data in PowerQuery can cause Excel to freeze

Import data from an Excel workbook through Power Query, but the data is quite large, with approximately 3000+rows. Importing is normal, but when loaded into Excel, it can cause Excel to freeze. I have created a simple example and this issue will not…

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,725 questions
asked 2024-10-28T12:54:18.56+00:00
Wolfe M 0 Reputation points
answered 2024-10-29T09:08:46.67+00:00
Emi Zhang-MSFT 25,546 Reputation points Microsoft Vendor
1 answer

disable Ease of access feedback options

Hello, We use Office 365 version 2006 (build 13001.20384) and we want to disable the ease of access option "Provide feedback with sound" for all out users. This option is default enabled. In Office 365 (version 2002 build 12527.20278) this…

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,725 questions
asked 2020-08-06T08:49:07.12+00:00
Solfoit 1 Reputation point
edited a comment 2024-10-29T07:14:42.39+00:00
Abood Alhamwi 0 Reputation points
0 answers

Why can't a program I am writing a script in (AutoHotKey) not getting access to Excel's COMObject feature?

I've been on a chat for hours with Microsoft support and they have passed me on to you here. I have been working with chatGPT, trying to write a script to enable Excel to use a few Auto Hot Keys to run a simple stopwatch function directly in a sheet? …

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 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.
3,974 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,725 questions
asked 2024-10-28T08:19:12.73+00:00
Kelly Yero 0 Reputation points
edited the question 2024-10-29T01:16:00.04+00:00
Emi Zhang-MSFT 25,546 Reputation points Microsoft Vendor
2 answers

creating ODBC connection for Microsoft Excel Driver 64 bit

I have ran ODBC 64-bit as administrator. I have added a new connection with the SystemDSN tab. I then click on Microsoft Excel Driver. In the Dialog I enter the datasource name, description and click on select Workbook and choose my Office 365 Excel 64…

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,725 questions
asked 2024-10-23T07:42:51.4066667+00:00
Rusty1208 0 Reputation points
commented 2024-10-28T07:32:31.4833333+00:00
Emi Zhang-MSFT 25,546 Reputation points Microsoft Vendor
1 answer

Excel convert date format

My date format is now 01-Oct-2024, how can i use excel formula to change to 01/10/2024 dd/mm/2024

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 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,725 questions
asked 2024-10-25T09:05:13.71+00:00
nononame2021 256 Reputation points
commented 2024-10-28T00:30:24.27+00:00
Barry Schwarz 3,071 Reputation points
3 answers

not able to access the macro.

Hi, I'm not able to access macro, could you please help me on this!

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,725 questions
asked 2024-10-24T06:14:36.4466667+00:00
Nagarjuna, Yenakandla 0 Reputation points
answered 2024-10-25T01:34:22.25+00:00
Jiajing Hua-MFST 10,565 Reputation points Microsoft Vendor
2 answers

The insertWorksheetsFromBase64() Excel api is missing capability to insert hidden worksheets

Currently we are utilizing  insertWorksheetsFromBase64() api for our plugin to insert worksheets into excel workbook. Our team would like to insert HIDDEN worksheets using insertWorksheetsFromBase64() Excel api. Is it feasible from your end to expose…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,702 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 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.
3,974 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,725 questions
asked 2024-07-18T20:49:58.24+00:00
Tashpulatov, Azizbek 0 Reputation points
answered 2024-10-23T20:56:17.1933333+00:00
emmasab 0 Reputation points Microsoft Employee
4 answers One of the answers was accepted by the question author.

Excel Stocks Data Type Error - Subscription Sign-in Required

I have been using the stocks data types feature on Excel without any issues until yesterday. However, I'm now receiving the following error message: "You need to sign in with an account associated with a subscription to use these data types. Select…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 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,725 questions
asked 2023-07-11T14:53:14.63+00:00
talk2manikan 55 Reputation points
answered 2024-10-21T23:04:38.3033333+00:00
LM Santos 0 Reputation points
3 answers One of the answers was accepted by the question author.

Table transform in Excel

Hello, I have raw data that are extracted in complex design, so I need to transfer these data from below: to below design: There are thousands of Customers IDs and thousands of Parts and Parts type, each part has 2 subtypes, so subtypes need to be…

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,725 questions
asked 2023-05-25T14:58:38.27+00:00
Ahmed Moursi 20 Reputation points
commented 2024-10-19T13:56:19.35+00:00
Viswjheet Viswjheet 0 Reputation points
1 answer

macros et classeur partagé

Bonjour, j'ai un classeur tout simple : une feuille liste de personnes avec une colonne pour le nom et une autre pour le numéro d'adhérent. La feuille est protégée pour éviter les erreurs de manipulation. Ce classeur doit être partagé sur un réseau…

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,725 questions
asked 2024-10-15T15:52:58.36+00:00
Patrick POULY 0 Reputation points
answered 2024-10-16T02:30:34.79+00:00
Emi Zhang-MSFT 25,546 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How to setup custom expiry dates for tasks with visual reminders

Hi, I am creating a custom show management tool using MS Excel. I need help with setting up expiry dates. The expiry dates will work backwards from the show start date (B3) and change colour. Colour changes will include no change when still ok, orange…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 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,725 questions
asked 2024-10-12T11:13:56.5233333+00:00
Elvis Necovski 20 Reputation points
accepted 2024-10-15T01:17:22.7666667+00:00
Elvis Necovski 20 Reputation points