This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Microsoft Q&A
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.
i want to remove titlebar
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…
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…
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, the data are - (1) placed in a word table (2) Linked (3) hyperlinked (4) Embedded Please tell the correct option
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…
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?
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,…
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.
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…
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 …
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?
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…
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…
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 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).…
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…
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…