Microsoft Q&A

Excel Management

1,362 questions

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.

Browse all Office tags

1,362 questions with Excel Management tags

Sort by: Updated
2 answers

how to hide or remove excel userform titlebar,

i want to remove titlebar

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,362 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.
2,174 questions
asked 2023-03-21T10:03:37.1733333+00:00
kanchha Chaudhary 0 Reputation points
edited the question 2023-03-22T01:51:04.24+00:00
Emily Hua-MSFT 23,621 Reputation points Microsoft Vendor
22 answers

Excel "3D Map" feature error: 3D Maps encountered an error while contacting Microsoft Bing mapping services. Functionality may be limited. (Status Code: 4)

Hello, I am running into an issue with Excel application where I am no longer able to use the "3D Map" feature. I used to use the search bar to load the feature but now when i do that i am faced with the following error: 3D Maps…

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.
2,174 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,362 questions
asked 2022-09-26T22:10:32.693+00:00
Said A 576 Reputation points
commented 2023-03-21T08:47:51.6733333+00:00
Martin Manscher 0 Reputation points
1 answer

Excel based application doesn't work after Office 365 auto updates are pushed

Hi, We have a .NET application which embeds Excel inside of it. Generally, our application is installed in PCs running in plants and they are in isolated network. So our application needs only desktop version of Excel. Some of our application…

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,362 questions
asked 2020-10-22T11:20:48.237+00:00
Rajaiah 1 Reputation point
commented 2023-03-20T09:58:56.1666667+00:00
Mohiuddin Chy 1 Reputation point
1 answer

Date Time format changes after saving

Hey All, I am needing an excel file to save my date in the following format dd:mm:yyyy hh:mm:ss. When I change the column to that format using "custom" it shows in the column correctly and in the formula. However, when I save the document and…

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,362 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
276 questions
asked 2023-03-17T12:43:59.01+00:00
Kirby Baxter 0 Reputation points
answered 2023-03-20T08:44:52.5+00:00
Emily Hua-MSFT 23,621 Reputation points Microsoft Vendor
2 answers

when we insert a excel file into a word document,

when we insert a Excel file into a word document, the data are - (1) placed in a word table (2) Linked (3) hyperlinked (4) Embedded Please tell the correct option

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,362 questions
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
1,873 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.
790 questions
asked 2023-03-19T05:44:45.09+00:00
abhilash dan 0 Reputation points
answered 2023-03-20T08:40:02.5633333+00:00
Emi Zhang-MSFT 11,566 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

'External table is not in the expected format.' Got this error when importing a .xls Excel file

Hi, In my C# winform application, I use the following code to import the Excel file and get a list of worksheets names. public static List<string> ListSheetInExcel(string filePath) { OleDbConnectionStringBuilder…

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,362 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
7,516 questions
asked 2022-05-29T20:45:53.217+00:00
Spellman.Lau 101 Reputation points
commented 2023-03-20T04:16:21.0633333+00:00
Huy Duong Tr 0 Reputation points
1 answer

How to get two field values of a form in the same column of excel sheet generated

I created 2 branches from a question in the ms forms, one of them is drop-down, other one is text field, I wish to get the response of both these fields in the same of column of the excel sheet. How should I do that?

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,362 questions
asked 2023-03-13T15:34:55.7933333+00:00
HEMRAJ RAIKWAR 0 Reputation points
commented 2023-03-20T02:35:28.89+00:00
Emily Hua-MSFT 23,621 Reputation points Microsoft Vendor
2 answers

How to make a column that only shows data if the cell value is contained in the referenced column?

Hello, I am looking to use Power Query to do the following: I have two columns I'm comparing: Column A and Column B I want it to be so that IF the cell value for a given row in Column A is contained anywhere within Column B, then display the row. 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,362 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
213 questions
asked 2023-03-07T17:12:20.9666667+00:00
KING, Dylan 0 Reputation points
commented 2023-03-20T02:13:39.49+00:00
Emily Hua-MSFT 23,621 Reputation points Microsoft Vendor
0 answers

How to add xlam file in sharepoint excel?

I have a data-picker xlam file that I added to my excel workbook in the home page. But when I import the file to the Sharepoint excel I don't see that.

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,362 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
276 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
6,441 questions
asked 2023-03-13T14:23:02.2866667+00:00
M.Ali 0 Reputation points
commented 2023-03-20T01:38:55.17+00:00
Emily Du-MSFT 26,631 Reputation points Microsoft Vendor
5 answers

Microsoft excel- unknown error trying to lock file

My users with Win 10 pro (up to date) is having trouble opening files (xlsx and xlsm) from SharePoint in Excel app, they are getting the error "Unknown error trying to lock file." They are running Excel 2016, fully up to date. Only my users who…

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,362 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
1,609 questions
asked 2023-03-14T05:38:15.7066667+00:00
Nur Adibah binti Abd Razak 15 Reputation points
edited an answer 2023-03-16T11:18:27.5566667+00:00
MiSo 5 Reputation points
2 answers

EXCEL macros with Windows and MacOs

I have an Excel file that several colleagues share. On windows the file macros work perfectly but on Mac systems they don't. (Windows macros detect them but not on Mac) I leave the macro below: Sub AfegirSilla() Dim Pregunta As String …

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.
2,174 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,362 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
276 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
320 questions
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.
459 questions
asked 2023-03-10T17:05:12.2733333+00:00
Pol Arenas 0 Reputation points
commented 2023-03-16T05:47:47.4033333+00:00
Viorel 88,321 Reputation points
1 answer

Extracting a list of hours from time range in Power Query Excel

Hello, I need your assistance with a problem that I couldn't find the solution to myself, I have a list of employees with their planning in an excel sheet, and I need to extract the hours between the Start and End columns to make it easier to filter by…

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,362 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
276 questions
asked 2023-03-14T16:38:29.76+00:00
Paa 0 Reputation points
commented 2023-03-16T02:36:36.3933333+00:00
Herbert Seidenberg 1,111 Reputation points
1 answer One of the answers was accepted by the question author.

How could I convert Shamsi date to Gregorian in Excel or Sheet?

How could I convert Shamsi date to Gregorian in Excel or Sheet?

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,362 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
276 questions
asked 2023-03-09T19:41:51.4166667+00:00
raha azad 20 Reputation points
edited the question 2023-03-14T01:10:02.23+00:00
Emily Hua-MSFT 23,621 Reputation points Microsoft Vendor
0 answers

The links used within two worksheets in same workbook saved in One drive is broken

The problem does not occur when we saved files in local drives it happens only when the files are saved in one drive. The problem is the excel file saved in One drive doesn't recognize links between two worksheets in the same workbook. For ex: say first…

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,362 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
213 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
276 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
168 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.
833 questions
asked 2023-03-04T07:43:01.66+00:00
Boova Raghavan 0 Reputation points
commented 2023-03-13T08:28:40.5833333+00:00
Emily Hua-MSFT 23,621 Reputation points Microsoft Vendor
2 answers

Get Excel File local absolute path instead of OneDrive Url

Hi everyone! I am having an issue with finding the local path of my Excel file on disk when synced with OneDrive. Here is the context: I have an Excel file on my local machine that is also synced with OneDrive. When I try the formula…

OneDrive Management
OneDrive Management
OneDrive: A Microsoft file hosting and synchronization service.Management: The act or process of organizing, handling, directing or controlling something.
833 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,362 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
1,959 questions
asked 2021-11-17T17:11:23.71+00:00
Struggling 11 Reputation points
commented 2023-03-10T01:50:15.0066667+00:00
Witt-Dörring Guido 0 Reputation points
1 answer

Is CAL required for MS Excel pivot table users accessing a SSAS Cube

Hi. We are using SQL Server 2019 and 2017 (not sure which one to go with yet) for a small .NET application leveraging a SQL server database and SSAS cube. The front end is IIS. We are trying to optimize the CAL user licenses we will need 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,362 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,053 questions
asked 2023-03-09T16:56:37.4066667+00:00
Marcus Serrao 1 Reputation point
edited the question 2023-03-10T01:15:05.5833333+00:00
CosmogHong-MSFT 8,376 Reputation points Microsoft Vendor
8 answers

Microsoft should FIX - "Errors were detected while saving (filename)"

Microsoft must FIX this decade long bug with appears out of nowhere and has ruined a lot of months of work of my life. Please fix the below error message. It is even appearing in latest Office 2019. "Errors were detected while saving (filename).…

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,362 questions
asked 2020-07-27T18:53:59.793+00:00
Asha Kanta Sharma 6 Reputation points
commented 2023-03-08T16:42:45.99+00:00
Andrew Hardy 0 Reputation points
1 answer

Excelfiles seems corrupt when upploaded to storage container in Blob

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,362 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
1,521 questions
asked 2023-02-03T11:01:23.45+00:00
Erik Arwinge 0 Reputation points
commented 2023-03-07T09:35:05.71+00:00
Sumarigo-MSFT 31,996 Reputation points Microsoft Employee
2 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…

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,362 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
362 questions
Microsoft Exchange
Exchange Server
Exchange Server
A family of Microsoft client/server messaging and collaboration software.
309 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.
6,302 questions
asked 2023-03-02T02:49:39.17+00:00
Gatchalian, AD 25 Reputation points
commented 2023-03-07T06:05:25.9166667+00:00
Aholic Liang-MSFT 7,106 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

How to fix [Microsoft]ODBC Driver Manager] Data source name not found and no default driver specified pivot table Excel 365 connecting to csv file

I have created a pivot table relying on data from .CSV files using Excel 2013 using the following connection string which has been saved in an .ODC file and refresh works perfectly well in Excel 2013: DBQ=Q:\data;DefaultDir=Q:\data;Driver={Microsoft…

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,362 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
276 questions
asked 2023-03-02T07:06:43.0333333+00:00
David Marjolin 25 Reputation points
accepted 2023-03-03T16:54:24.8966667+00:00
David Marjolin 25 Reputation points