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