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.
Content
how to hide or remove excel userform titlebar,
i want to remove titlebar


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…


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…


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…


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


'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…


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?


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,…


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.


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 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 …


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…


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


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…


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…


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…


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).…




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…


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…

