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…
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…
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…
Reading password protected .xlsx file in sharepoint using Microsoft Graph API
Hi there, I am writing to enquire about whether it is possible to read password protected .xlsx file from Sharepoint online using Microsoft Graph API? I could not find much information regarding this from the official documentation. Any help would…
Trying to search for column by column value in Office Scripts
Hi everyone, I am trying to create an office script that will calculate the percentage of Y's and Y+N's in a certain column, and searching for the column name in row 4 rather than hard-coding the index. Below is my code, but I keep getting the issue…
Data is not populating in WPF Form
I am working on a VSTO Excel Addin and on a button click I am opening a WPF form. case 1: I am working on a Citrix environment and Citrix opened on a single screen now I open excel and click on my ribbon button and my WPF form is working fine. But when I…
training courses for vBA programing in Toronto Canada
Hi Can you please advise where can I take VBA training courses accredited by Microsoft. It should be located in Toronto Canada. Thank you Adriana
I can't sign in to Excel due to Error - Something Went Wrong [1001]
Here are the troubleshooting details, I have already been on other questions with same topic and none of the solutions helped - Correlation Id: cf49974d-5f0c-4f8b-9042-5ef02f81aaa4 Timestamp: 2024-06-19T12:47:11.000Z DPTI:…
File saving issue on Excel in MacBook Air
I was trying to save an excel file and the message: "Errors were detected while saving [file name] Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel…
Do I need to be certified in MS Excel Associate before being certified in MS Excel Expert?
I want to have a certificate for MS Excel Expert. However, I am not sure of its requirements or if there are any pre-requisites. I do not have any MS certifications yet. Do I need to take MS Excel Associate or any other certification/exam first? …
Copilot for Excel
HI all. I just got copilot, so I am still learning how to make it work for me. I was excited about its use in Excel, but it doesn't appear to be ready for prime time. I have a sheet open and when I click copilot, it comes up in the right pane and…
Product Keys provided is for Microsoft LTSB version, but we are unable to install this version on our jump host server. How can we proceed?
We are able to download LTSC version on jump server, but we required LTSB version for product key activation. For MS license Activation. Due to LTSC version we are unable to implement product keys. Please provide us contact details or support email for…
Rotation line is not showing in excel ?
Having problems with copy paste rotation line across a cell is not showing so dont know which data is copy pasting/