Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,667 questions
1 answer
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…
asked 2024-06-27T08:57:56.29+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 64%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Tamashevich, Tatsiana
60
Reputation points
commented 2024-07-01T06:28:16.75+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Harishga
5,910
Reputation points Microsoft Vendor
1 answer
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 >…
asked 2024-06-27T08:10:58.9333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 16%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDJ%3C/text%3E%3C/svg%3E)
David JAOUEN
0
Reputation points
commented 2024-07-01T06:24:09.1833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 33%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHX%3C/text%3E%3C/svg%3E)
Haoyan Xue_MSFT
22,146
Reputation points Microsoft Vendor
3 answers
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
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.
4,317 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
3,046 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,688 questions
asked 2024-06-11T11:04:59.1266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 18%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Hamxa Khan
0
Reputation points
commented 2024-07-01T05:17:21.9366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
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?
asked 2024-06-26T07:32:25.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 53%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
Dixan Lal Thomas
60
Reputation points
accepted 2024-06-30T18:25:53.73+00:00
Dixan Lal Thomas
60
Reputation points
2 answers
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…
asked 2024-01-22T19:33:10.16+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 34%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Samuel COFFEY
0
Reputation points
answered 2024-06-30T12:28:08.4966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 22%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWS%3C/text%3E%3C/svg%3E)
W S
1
Reputation point
1 answer
One of the answers was accepted by the question author.
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 54%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
0 answers
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…
Windows Presentation Foundation
Windows Presentation Foundation
A part of the .NET Framework that provides a unified programming model for building line-of-business desktop applications on Windows.
2,709 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
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.
10,619 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.
3,707 questions
asked 2024-06-27T10:30:54.05+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 56.00000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Abhishek Bali
0
Reputation points
edited the question 2024-06-28T02:33:14.1666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jiachen Li-MSFT
28,941
Reputation points Microsoft Vendor
1 answer
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
asked 2024-06-27T14:01:12.7233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 86%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Adriana Nistoroiu
0
Reputation points
answered 2024-06-28T01:53:31.27+00:00
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor
2 answers
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:…
asked 2024-06-19T12:52:20.8466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 86%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Manas Damle
0
Reputation points
answered 2024-06-27T10:22:24.0533333+00:00
Manas Damle
0
Reputation points
1 answer
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 83%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
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? …
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 10%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
1 answer
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…
asked 2024-06-12T17:18:13.0666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 90%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWI%3C/text%3E%3C/svg%3E)
WRMC IT
0
Reputation points
commented 2024-06-27T06:48:47.53+00:00
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor
1 answer
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…
asked 2024-06-19T13:58:25.65+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 84%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Vaibhavi Rastogi
0
Reputation points
commented 2024-06-27T06:38:18.6266667+00:00
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor
2 answers
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/
asked 2024-06-20T08:55:31.6066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 10%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Purva
20
Reputation points
commented 2024-06-27T06:32:56.43+00:00
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor
1 answer
How can i export data on excel from a password protected PDF using "Get Data" tool
How can i export data on excel from a password protected PDF using "Get Data" tool. password is available with me.
asked 2024-06-23T18:33:30.9+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 8%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
prateek sharma (प्रतिक शर्मा)
0
Reputation points
commented 2024-06-27T06:19:59.23+00:00
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor
1 answer
Office Client - Excel
Hello Please i need your help on this issue. A number of problems browser clocking with certain programs/data refresh is not working in excel and trying to attach file in email. We are getting error message "download failed path doesn't…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,457 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 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,688 questions
asked 2024-06-26T16:37:09.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 76%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI8%3C/text%3E%3C/svg%3E)
IniobongNkanga-8038
296
Reputation points
commented 2024-06-27T05:40:37.08+00:00
Emi Zhang-MSFT
23,736
Reputation points Microsoft Vendor
1 answer
ExcelScript.ConditionalRangeFill interface can't manage pattern ?
The ConditionalRangeFill interface don't include .setPattern() as a valid fonction : Documentation In contrary, the RangeFill interface include .setPattern() and even .setPatternColor() as valid fonction : Documentation By using excel menu, you can set a…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 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.
3,707 questions
asked 2024-06-26T15:10:49.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 22%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Abélard Martin
0
Reputation points
answered 2024-06-26T15:10:49.0866667+00:00
Q&A Assist
5 answers
Excel macro keyboard shortcuts not working
I have read all of the "answers" to my question, but none apply to my problem, so: I have several Excel 2013 workbooks with macros that work with the buttons I have created; i.e. SAVE, Print, etc. I have tried to create keyboard shortcuts to…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 87%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 11%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
2 answers
FileOpenUserUnauthorized error for excel API
Hi, I hope you are doing well. I am exploring Microsoft Graph Explorer for excel API and testing get worksheets in workbook endpoint. Although I have provided correct drive-item-id , I'm keep getting following error. { "error": { …
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,364 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 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.
3,707 questions
asked 2024-03-20T10:15:33.05+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 57.99999999999999%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
kishan parmar
0
Reputation points
commented 2024-06-26T11:48:55.2833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 59%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Abhijith V S
0
Reputation points
2 answers
How to display fractions as decimal sixteenths
Ok so this a srange request. I want excel to display fractions and decimals in decimal sixteenths. What I mean by that is 1/16 is .01 1/8 is .02 3/16 is .03 so on and so forth. Is there any way to accomplish this?
asked 2024-06-19T17:08:32.79+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 44%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
Fiya
0
Reputation points
commented 2024-06-26T09:18:53.7466667+00:00
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor