1,739 questions with Excel Management tags

Sort by: Updated
3 answers One of the answers was accepted by the question author.

Microsoft excel functions returns a wrong result

Hi All, I use this dll "Microsoft.Office.Interop.Excel" in order to evaluate my excel functions. public dynamic EvaluteFormula(string expressionFormula) { Application excelApp = new Application(); return…

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.
11,144 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,739 questions
asked 2021-08-16T14:05:47.153+00:00
Yamen Jeribi 41 Reputation points
answered 2024-12-19T18:25:33.39+00:00
Paul 0 Reputation points
3 answers

How to set default template in Excel

Hi I have a task where I need to set a default Office Template for Word, Excel and PowerPoint. Word and PowerPoint was easy enough, but Excel, am I struggling with. I have created a template file named book.xltx and put it in…

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,739 questions
asked 2022-03-13T17:36:30.673+00:00
Thomas Nielsen 141 Reputation points
commented 2024-12-19T09:36:00.3333333+00:00
Peter Lairo 0 Reputation points
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.
2,044 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,739 questions
asked 2024-11-11T16:34:30.3333333+00:00
Rob Benson 5 Reputation points
commented 2024-12-18T17:30:56.5133333+00:00
Jeanette 0 Reputation points
3 answers

Datestamps in Excel when a cell value changes

I've already looked up adding datestamps in Excel. Not a problem. I already have a table with data in it. I don't want to display the current date if there is already data in the cell. I only want the datestamp to update when the other cell value…

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,739 questions
asked 2022-12-20T17:21:58.08+00:00
Daniel Checkman 11 Reputation points
commented 2024-12-18T09:25:17.4566667+00:00
Paul 20 Reputation points
7 answers

Importing excel workbook data into MS Project isn't working

Hi When I try to import excel data into MS Project, I have to select the tab name (which I haven't had to do before if there is only one active tab), but when I try and select the data - nothing is showing. I have cleared all formatting from the…

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,097 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,739 questions
asked 2022-08-17T14:31:39.707+00:00
Tereza Murphy 1 Reputation point
commented 2024-12-16T13:43:52.07+00:00
Rick Hayward 0 Reputation points
3 answers

Pivot Graph Series Color Changes for Previously Set Data Series

I have a Pivot Chart that shows Red/Yellow/Green metrics. I have set the series colors as appropriate for each series. On the occasion that data conditions result in the absence of one of the series...(for instance there are no Red items), this series…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,044 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,739 questions
asked 2023-06-02T14:09:29.55+00:00
dtaraboletti 0 Reputation points
commented 2024-12-13T09:41:55.7866667+00:00
Lloyd H 0 Reputation points
0 answers

Microsoft Excel Formula to auto-populate Sub-table from Master Table based on Status Change.

An Excel support person tried to help me trouble shoot this problem via Quick Assist screen share and indicated that it was an important issue that should be looked at by a higher development support level and directed me here to raise a ticket. I run…

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.
5,367 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,044 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,097 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,739 questions
asked 2024-12-02T04:45:30.7066667+00:00
Michael Bartlett 0 Reputation points
commented 2024-12-11T07:45:59.13+00:00
Michael Bartlett 0 Reputation points
0 answers

how to give coding for answer scripts in evaluation system?

I want to give coding for answer sheets in evaluations using their hall ticket numbers. after evaluation I need to decode and publish the results. then how can I do this work with excel?

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,097 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,739 questions
asked 2024-12-11T06:32:54.3766667+00:00
Sulthan D 0 Reputation points
edited the question 2024-12-11T07:34:05.5033333+00:00
Emi Zhang-MSFT 26,526 Reputation points Microsoft Vendor
0 answers

Problems with Microsoft Excel 2016 Professional Edition

Hi, I'm experiencing some issues with excel, I click the program and the files but it doesn't open, even when i try by admin mode and this is happening to other people, somebody has an update for this problem? This is for Office 2016, and I don't get any…

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,739 questions
asked 2024-12-10T19:36:01.7033333+00:00
Eliana Selene Oblitas Tafur 0 Reputation points
commented 2024-12-11T06:48:02.94+00:00
Emi Zhang-MSFT 26,526 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

Fill empty cells with the previous value

Hi group! In the attached example I would need to know if there is any way to fill the empty cells of the cod office field with the value of the last cell with value so that the result would be. I need this because I have to do it 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,739 questions
asked 2020-07-30T09:22:19.83+00:00
jm saf 166 Reputation points
commented 2024-12-10T15:19:28.2966667+00:00
Sullivan, Carla 0 Reputation points
0 answers

Excel vba macro stopped working to send outlook mail

Recent change to windows11 has stopped my excel macros from sending emails through outlook. I have added Outlook, Excel and Office library 16.0.

Outlook
Outlook
A family of Microsoft email and calendar products.
4,213 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,097 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,739 questions
asked 2024-12-09T12:59:36.2366667+00:00
Jason Raedy 0 Reputation points
edited the question 2024-12-10T01:28:14.51+00:00
Jiajing Hua-MFST 12,240 Reputation points Microsoft Vendor
0 answers

Excel VBA Code Upgradation help required

Dear VBA Developer, The Excel file below contains two sheets: Master Data and RM Purchase. https://1drv.ms/x/s!AiSRNak3QYCfha1PgPfgI3-lQY3igg?e=fLtC2B In the Master Data sheet, Column B lists the Project Locations, with consumption data spanning from…

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.
5,367 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,044 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,097 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,739 questions
asked 2024-12-07T10:40:40.1466667+00:00
Anbuselvam Kovilmani 41 Reputation points
commented 2024-12-09T02:17:58.6+00:00
Barry Schwarz 3,161 Reputation points
5 answers

OLE error "Microsoft excel is waiting for another application to complete an OLE action"

Hi All, I am getting an error in Excel 2013 version. "Microsoft excel is waiting for another application to complete an OLE action". This error is very frustrating and keeps coming in every 5-10 minutes. I know there are a couple of…

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,097 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,739 questions
asked 2021-09-27T18:34:31.02+00:00
Ankit Kumar Ranka 11 Reputation points
edited an answer 2024-12-05T09:56:18.4366667+00:00
hellcat 0 Reputation points
1 answer

Data type "Stock" "Currency" not found in MS Office Professional 2024 Excel

I am using MS Office Professional 2024 and the data type STOCK/Currency could not be found in EXCEL. Also in the section Option it is not listed to be added in the menu bar. All examples shown in the web are referring to MS Office 365 - is the are…

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,739 questions
asked 2024-11-28T11:00:08.7133333+00:00
Dirk Baader 0 Reputation points
commented 2024-12-02T01:35:09.4033333+00:00
Jiajing Hua-MFST 12,240 Reputation points Microsoft Vendor
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.
2,044 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,739 questions
asked 2024-11-18T02:50:11.7166667+00:00
Wataru Kitagawa 0 Reputation points
commented 2024-11-25T08:50:33.3966667+00:00
Jiajing Hua-MFST 12,240 Reputation points Microsoft Vendor
1 answer

Layout of pages changed when opening excel files

I found out some possible answers for "Layout of pages changed when opening excel files" as below. I guess my problem could be from (a), but i can't adjust screen resolution every time it happens, or adjust Page Layout view, they are time…

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.
2,215 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,739 questions
asked 2024-11-22T08:09:42.4533333+00:00
Kelvin Koh 0 Reputation points
answered 2024-11-25T07:36:49.43+00:00
Emi Zhang-MSFT 26,526 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How to disable F1 in Excel(Win11, Office2021)?

It is quite annoying to press F1 by accident and close the help window when using Excel. How could I disable the F1 shortcut key in Excel? I found a way to disable it with VBA In Office2007 but it works no more in Office 2021

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,739 questions
asked 2021-12-21T06:51:50.047+00:00
Elon 26 Reputation points
commented 2024-11-24T23:09:04.5266667+00:00
Dimas Prayuda 0 Reputation points
7 answers

frequent error when refreshing pivot table

When refreshing a Pivot table that is created from another worksheet, I get: An unexpected error occurred (file'pcminorobjcoll.inl', line 109, function 'PCMinorObjectCollection[class PCProperty.class NameHashSupport]::SetNameAndUpdateCollection') 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,739 questions
asked 2021-05-10T19:42:09.177+00:00
Eric Brinsfield 6 Reputation points
answered 2024-11-22T14:05:03.4233333+00:00
1 answer

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.
2,044 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,739 questions
asked 2024-11-22T01:52:18.1+00:00
Wataru Kitagawa 0 Reputation points
answered 2024-11-22T08:57:09.0066667+00:00
Jiajing Hua-MFST 12,240 Reputation points Microsoft Vendor
6 answers

Can't interact with Excel because of hidden dialog box.

Hidden dialog box keeps Excel from operating properly. I've tried alt-tabbing the dialog does not show up. When I try to shut Excel down using the task manager since close it normaly I get a dialog box stating "You cannot close Microsft Exel…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,044 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,739 questions
asked 2023-01-15T16:07:05.61+00:00
John Wilk 35 Reputation points
commented 2024-11-22T08:27:04.2233333+00:00
Nikhil Matere 0 Reputation points Microsoft Employee