1,732 questions with Excel Management tags

Sort by: Updated
0 answers

Error with Excel's Spreadsheet Compare: Cannot open files generated by write.xlsx() in R.

Using Office Professional Plus 2021, Excel's Spreadsheet Compare tool fails to open files when I attempt to compare two xlsx files. An error message below appears: 'Error opening workbook. Specified part does not exist in the package.' This happens…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,986 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,732 questions
asked 2024-11-22T01:52:18.1+00:00
Wataru Kitagawa 0 Reputation points
0 answers

Understanding 'Sysgen Names' and 'Sysgen Names Error' in Office 2021's Spreadsheet Compare Tool

Hello, My colleagues and I use Office Professional Plus 2021 which comes with an add-in with an app called Spreadsheet Compare that compares two Excel books and shows differences in each cell. Apparently, it has an option that enables to detect…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,986 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,732 questions
asked 2024-11-18T02:50:11.7166667+00:00
Wataru Kitagawa 0 Reputation points
commented 2024-11-21T04:30:52.8733333+00:00
Wataru Kitagawa 0 Reputation points
1 answer

Upload Failed:Problems Refreshing

Hi there, Im currently using a 2019 version of excel. All my files are saved directly to one drive , however when i open old excel documents using one drive on my desktop (file explorer) , it doesnt just let me save the changes made . instead it…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,986 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,164 questions
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,285 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,732 questions
asked 2024-11-14T12:23:26.0733333+00:00
Simone Govender 0 Reputation points
commented 2024-11-19T09:47:12.7133333+00:00
Jiajing Hua-MFST 11,360 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Optimizing Pivot Tables and Slicers for Dynamic Excel Dashboards

A dynamic dashboard is being created in Excel to analyze sales data, including Date, Region, Product, Sales, and Profit. What are the steps to configure Pivot Tables for automatic refreshing with source data updates, ensure that multiple Pivot Tables…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,986 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,732 questions
asked 2024-11-18T07:49:05.5966667+00:00
DexterHale 20 Reputation points
accepted 2024-11-18T18:04:15.2366667+00:00
DexterHale 20 Reputation points
0 answers

Numbers spell in excel with three decemals

Hi, can anyone help me with excel to spell number like this ? its for a currency BHD 101.123 = one hundred one Bahraini Dinars And One Hundred and Twenty Three Fils Only. The Fils decimals are three from 1-999

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,732 questions
asked 2022-10-27T09:32:48.297+00:00
excel help 11 Reputation points
commented 2024-11-18T11:23:41.7833333+00:00
Ismail Kunju 0 Reputation points
0 answers

Get live numbers from web into my excel sheet

I need to get live numbers from a web page (example, googlfinace) into my excel sheet, so I can keep my excel sheet updated at all time, fore purpose of quick action point.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,986 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,732 questions
asked 2024-11-10T18:48:51.0666667+00:00
Karl Petter Konradsen 0 Reputation points
edited the question 2024-11-15T10:20:54.01+00:00
ajkuma 27,026 Reputation points Microsoft Employee
1 answer

Why do these cells in Excel stay green and cannot be changed?

I have a spreadsheet that my team uses in excel that we share on the web browser and use chrome. When we try to insert new cells they show up as white until we enter txt into them, and then they are hgihlighted as this green color shown below. But we…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,986 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,732 questions
asked 2024-11-11T16:34:30.3333333+00:00
Rob Benson 0 Reputation points
answered 2024-11-12T02:32:13.1333333+00:00
Emi Zhang-MSFT 25,711 Reputation points Microsoft Vendor
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,986 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,732 questions
asked 2024-10-25T08:56:29.37+00:00
nononame2021 256 Reputation points
commented 2024-11-09T13:12:08.66+00:00
Jonas Kufner 85 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,732 questions
asked 2023-05-08T13:09:11.0033333+00:00
Maria Victoria Mosquera 10 Reputation points
commented 2024-11-09T01:43:13.9366667+00:00
Juan Pablo 0 Reputation points
0 answers

Multiple Condition Match Look-up [INDEX, MATCH, LEFT, SEARCH]

If after hyphen( -) full match found with A vs B + if left 3 of D match found with A= result need "found" Excel version 2021If after hyphen( -) full match found with A vs B + if left 3 of D match found with A= result need "found"…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,986 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.
936 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,732 questions
Microsoft Configuration Manager
asked 2024-11-07T05:51:39.1166667+00:00
Md Yeasin 0 Reputation points
commented 2024-11-07T08:51:24.5066667+00:00
Paul Edstein 571 Reputation points
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.
4,024 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,732 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
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,986 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,732 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 715 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,242 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,732 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,986 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,732 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 11,360 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,732 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,743 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,986 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,732 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,356 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,690 questions
Microsoft Exchange
Microsoft Exchange
Microsoft messaging and collaboration software.
578 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,732 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,634 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,732 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,711 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,732 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,986 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,024 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,732 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,711 Reputation points Microsoft Vendor