Looking for a formula to highlight an entire row when a date in column J is 60 or < days than current date in Excel
I need a formula for conditional formatting that will highlight a row when the date in column J is <60 days from current date. Any help would be appreciated!
Linking data from an Excel file to a Visio file using SharePoint?
I am trying to use the 'Link Data' feature in Visio to link to an Excel spreadsheet located in SharePoint. Currently it is accessing the file through my OneDrive which means that when others with access to the SharePoint open the Visio file, the data…
Data from a csv file to excel, date is in MM/DD/YYYY format, region set as Australia
Newbie here so simple language please. Data was transferred as a csv file into excel file. I have subsequently entered more data. I have noticed the date of the imported data is in MM/DD/YYYY format even though settings, region, language and cell format…
Automate data entry on specific date every month
I have designed a table for my monthly income and expense entry. There are certain entry like home loan EMI needs to enter on specific date i.e. 5th of every month. now i wanted to make this entry on auto mode every month in my table. i tried few of…
split cells in excel
how to split individual cells?
Why does DATEDIF give different results in Excel and SharePoint?
The following formula gives different results in an Excel worksheet and a SharePoint list: =DateDif([Date_1],[Date_2],"md") There are ten cases where Excel gives a higher number than Sharepoint, and two cases where SharePoint gives a higher…
How to fix "an operation that uses the driver could noet be compleated. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Querry." whiel using Inventory Cube in Escel
Hello, We're trying to troubleshoot the error that is occurring for one of our user's when he tries to run Inventory Cube within Excel. We've already tried reinstalling Office, running Excel in safe mode, changed the settings in order to unblock DDE,…
Excel Differences between two worksheets but worksheets have dependent columns
I need to find a formula that supports the ability to highlight differences between two worksheets. Each worksheet has the same two columns. Those two columns are dependent of each other in order for the information to be correct. I need the formula to…
How to fix the issue regarding the limit of 256 characters in data validation in excel
Hi, I am directly inputting values from code base on to the drop-down list using data validation, where facing issues while opening the excel file. Where have notice if the total characters of the list of dropdowns is within 256 characters, am able to…
Excel Add In Can't Add Comments - This operation is not implemented.
Trying to add comments programatically to Excel through my add in, but getting "this operation is not implemented" error every time. Code for reference (in taskpane.js): function comment(text) { Excel.run(async context => { const range…
Excel Add In Can't Add Comments - This operation is not implemented.
I'm currently on MacOS Sonoma (14.5) using Office16.86 (appears to be as updated as possible) building an Excel add in. I am trying to programatically add a comment to Excel on a specific cell through taskpane.js. However, every time I try to add this…
Excel - VBA macro code to pull outlook files by spesific date range in spesific folder and save as today date
Hi everyone, Need advise from the expert here. I am trying to pull outlook files but the results it extract all the file in that spesific folder. I am trying to only pull all the files on today date. May i know what code should i put so that the VBA code…
Need to stop office apps from EVER opening in a browser on my PC. Was told to post here by answers.microsoft
I need to stop files (Excel files on SharePoint/OneDrive primarily) from opening in a browser on my PC. I feel like I've tried everything. All the advice I get is to click on the ellipses and select "open in desktop app", or go to SharePoint…
I cant redeem my Microsoft Office 2019 Home & Student code on my new pc
So I bought a pc a while back, and it can with Microsoft Office 2019 Home & Office preinstalled, but now I want to download it on my new Computer. I tried redeeming the code on https://setup.office.com/, but the following error came with it: Kehren…
how to remove auto group window
how to remove this, I don't want this auto group and add another window too many function and lag, too slow when i want to change my work book. if i want another group from a-b to a-c? y create auto group?
Synapse how to read excel with formula
Hello, in Synapse spark pool we need to read excel file that contains formula inside of cells (sometimes it is simple sum, sometimes complicated formula, sometimes it is reference to another spread sheet and cell). Unfortunately, we observe that some…
How to insert Sharepoint Document ID in a document (Word, Excel...)?
Hi, I enabled the Document ID in Sharepoint so each document have a unique ID. I would like to insert this Document ID in documents (Word, Excel...) but I do not have access to this property of the document (it does not exist in File > Info >…
How to renew Microsoft 365 Developer licence
I had subscribed to the Microsoft 365 Developer Program, but my subscription has expired and was not renewed. I am seeking assistance to resubscribe to the program
Insert Excel Data in Sharepoint/Onedrive to SQl DB using ADF - cannot use Storage Account
I want to insert the data in Excel placed in a Sharepoint/Onedrive, into a DB using ADF. I found that this can be done using a storage account. My requirement is not to use a Storage account. Can anyone guide me?
In word I am unable to insert excel worksheet object
I am using the most updated version of word and excel, on a Windows 10 device. Both apps are working with out issue. When I am in word I got to the insert tab and select object, then select Microsoft Excel Worksheet. But I am given an error saying…