Cannot connect Excel to Postgres database?
I would like to connect excel to a Postgres database. I have downloaded the ngpsql 4.0.17 from the below reference page https://github.com/npgsql/Npgsql/releases When I try to connect, I get this message: the ngpsql version that comes with an MSI…
Error when importing .csv-file to Outlook calendar
Hi! I want to import a number of calendar events from Excel (.csv) to the Outlook calendar. I created the .csv file myself and made three simple columns to test: Subject (A), Start Date (B), and End Date (C), along with two test rows with values. In…
Excel Script to work with Power Automate that will copy Data from 1 cell in a worksheet to another cell in another worksheet based on criteria in a cell on the row.
Hello: I am new to the scripts part of Excel and Power Automate. I need MAJOR help. See HERE for the images! I have 1 single Workbook with 10 different worksheets within it. This script is focusing on just 2 of the worksheets. (They are labeled…
How to break line inside an Exel cell
Hi, is it possible to enter a long line of content inside a cell with line breaks? Not by wrap text, but break lines at the words that you desire. Thanks.
An Excel file has been overwritten by another user.
Hello Please i need your help on this issue. I want to recover my file before a colleague overwrote it and didn't save my changes
How can I set my personal OneDrive as a Trusted Location.
How can I set my personal OneDrive as a Trusted Location. I want to set my personal OneDrive sync folder as the Office 365 Excel trusted folder. As Internet-based Excel macro files were restricted this month, I checked the following documents.…
HELP IN EXCEL
Hello !! I am trying to save my invoice in the orderlog sheet, but when i press the button saveorderlog, replace the previous order, it is not adding after the previous order. in the OrderlogTrack i need to track all the quantity a specific item,…
Excel Sheets movement
Hello, I hope I am wording this correctly. I have an expense sheet for each month on separate sheets in Excel. I'd like them to stay separate whilst moving these sheets into a 'sub-sheet' so-to-say so I can do my 12 month sheets into one sheet for 2024,…
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…
Unable to find excel content in file explorer search
Environment - Windows Server 2022. Office - M365 - as per the MCO. The excel files doesn't show up when the cx tries to search the contents of the excel file in the search bar of the file explorer. The issue only occurs…
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…
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.