Azure SQL Database
An Azure relational database service.
5,998 questions
2 answers
"An operation that uses the database driver could not be completed. 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 Query."
One of the users receive this error. is this issue at our end or at microsofts ?
asked 2023-10-25T20:03:28.8633333+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(64, 5%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZA%3C/text%3E%3C/svg%3E)
zubaid ahmed
5
Reputation points
commented 2025-02-14T15:11:44.54+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(236.8, 22%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Richard Price
0
Reputation points
2 answers
"An operation that uses the database driver could not be completed. 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 Query."
One of the users receive this error. is this issue at our end or at microsofts ?
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed
5
Reputation points
commented 2025-02-14T15:11:44.54+00:00
Richard Price
0
Reputation points
0 answers
Runbooks issue
SharePointExcelAutomation code does not run all the way. Copilot cannot give solution for errors. We need someone from Microsoft Support.
asked 2025-02-14T14:47:11.97+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, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZC%3C/text%3E%3C/svg%3E)
Zoltan Csirke
0
Reputation points
asked 2025-02-14T14:47:11.97+00:00
Zoltan Csirke
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Conditional formating
Good day. I have watched a number of videos related to conditional formatting and using vlookup, but either I am not understanding them or what I am looking to do it not really what I am looking for. With reference to the below table. I need to…
asked 2025-02-14T09:05:39.66+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(272, 10%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHF%3C/text%3E%3C/svg%3E)
Hilton Fynn
20
Reputation points
commented 2025-02-14T13:12:28.6266667+00:00
Hilton Fynn
20
Reputation points
2 answers
One of the answers was accepted by the question author.
i have to select a cell based on a data on the columns and one on the rows
i have a table where in the columns there is one data like column1 = 100 ; columns2 = 200 etc..... on the rows there is some other data like rows1 = a ; rows2=b etc i need to find a " formula " where when i put in the " criteria"…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,906 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,160 questions
asked 2025-02-13T09:59:52.1566667+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(25.6, 78%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELG%3C/text%3E%3C/svg%3E)
Luca Gallarate
20
Reputation points
commented 2025-02-14T11:46:31.3133333+00:00
Luca Gallarate
20
Reputation points
1 answer
If you attempt to paste link from encrypted(Internal sensitivity labelled) document (ex. excel), the option to paste link to Powerpoint as Microsoft Excel Worksheet Object is missing. The only option is a hyperlink.
If you attempt to paste link from encrypted(Internal sensitivity labelled) document (ex. excel), the option to paste link to Powerpoint as Microsoft Excel Worksheet Object is missing. The only option is a hyperlink.
asked 2025-02-14T06:10:36.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(80, 68%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOM%3C/text%3E%3C/svg%3E)
Owakiabul Molla
0
Reputation points
edited the question 2025-02-14T10:35:16.13+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(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
20,285
Reputation points Microsoft Vendor
2 answers
How to enable the macro automatically on other computer
Suppose I sign an Excel macro with a certificate from a trusted Certificate Authority (CA). Will the macro automatically enable on another computer even if that computer does not have the CA's root certificate installed?
asked 2025-02-12T15:26:13.6133333+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(281.6, 35%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKR%3C/text%3E%3C/svg%3E)
Karthikeyan R
0
Reputation points
answered 2025-02-14T09:06:28.0266667+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
14,575
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
How can I get screentips or equivalent on shapes in excel 365
Help please In 2023 I wrote a genealogy spreadsheet with macro buttons on the sheets. I added an icon for each button with a screentip describing the button's function. The screentips worked 2 years ago but some update on 365 has disabled them despite…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,160 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.
4,262 questions
asked 2025-02-13T09:44:59.8766667+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, 24%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Ken M Hanley
0
Reputation points
answered 2025-02-14T09:02:25.3966667+00:00
Ken M Hanley
0
Reputation points
1 answer
Regarding the problem that Excel mouse wheel cannot scroll smoothly
I have installed mouse smoothing software, but Excel still does not support smooth scrolling with the mouse wheel. I have tried many methods in the community, but still cannot solve it. I hope someone can help me solve this problem. Thank you.(The…
asked 2025-02-14T04:37:39.86+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(230.39999999999998, 75%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
庞九权
0
Reputation points
answered 2025-02-14T08:22:27.8233333+00:00
Emi Zhang-MSFT
27,716
Reputation points Microsoft Vendor
0 answers
Microsoft EXCEL issue. Anywhere else on my PC i can copy a number and a drop down will pop up with how I can make a phone call
So as stated above I can copy a number anywhere and a pop up will appear and I can click an icon and make a phone call. I used to be able to do it in excel on the actual cell but cant anymore after my it reset my pc but I can do it everywhere else. But…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,160 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.
4,262 questions
asked 2025-02-13T19:38:35.8266667+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(211.20000000000002, 6%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Ben Sperry
0
Reputation points
edited the question 2025-02-14T02:02:51.6+00:00
Emi Zhang-MSFT
27,716
Reputation points Microsoft Vendor
0 answers
How to suppress the "Select a certification for Authentication in excel addin"
We want to prevent a bad user experience for our React JS Excel add-in in higher environments like QA, UAT, and PROD by controlling the "Select a certification for Authentication" from popping out every time. Is there a workaround for…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,160 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.
4,262 questions
asked 2025-02-13T13:56:50.52+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(249.60000000000002, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Ted Borlongan
0
Reputation points
asked 2025-02-13T13:56:50.52+00:00
Ted Borlongan
0
Reputation points
2 answers
Excel Scripts "Refresh All" function not working for Excel Online
I have recorded a very basic Office script, as below: function main(workbook: ExcelScript.Workbook) { // Refresh all data connections workbook.refreshAllDataConnections(); } It refuses to refresh the Power Query data that is coming from 2 tables…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,906 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,160 questions
asked 2024-10-09T22:21:39.6866667+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, 27%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Keiran
0
Reputation points
answered 2025-02-13T07:31:07.5866667+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(25.6, 79%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Anjuri, Pavan Sai Kumar
0
Reputation points
2 answers
Excel cannot print anymore, the other apps can
We have a Windows 10 Home edition. Office 365 is installed with the user who has a business standard license. Word, Outlook, .... works fine. And the user can print from the apps. The printer is located in the same lan. If we do the same in Excel we get…
asked 2025-02-11T12:54:14.33+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(67.2, 54%, 16%)' 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)
Kurt Stichelmans
661
Reputation points
commented 2025-02-13T06:14:40.5066667+00:00
Jiajing Hua-MFST
14,575
Reputation points Microsoft Vendor
1 answer
how to stop refresh removing field entries.
When I enter or update a comment in the comment field and perform a refresh the comments that I entered are removed. How I write entries in the comment field. I create a query called comments and enter the comments in the output and then create another…
asked 2025-02-12T18:22:31.2033333+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(252.8, 56.00000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
Norman McIlwaine
0
Reputation points
answered 2025-02-13T06:00:14.9366667+00:00
Emi Zhang-MSFT
27,716
Reputation points Microsoft Vendor
1 answer
How to extract value of MS Word form Content control box to excel
Hello y'all, I have a folder with about 200 word documents that contain data I am trying to get into excel. The word template used has many content control plain text boxes with unique names. My users have filled out these word forms and now I need to…
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
955 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,160 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.
4,262 questions
asked 2025-02-12T14:04: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(60.8, 51%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
deepslp
0
Reputation points
edited the question 2025-02-13T01:58:32.42+00:00
Emi Zhang-MSFT
27,716
Reputation points Microsoft Vendor
1 answer
Choice One, other cells self populate
How can you make columns B&C self-populate with choices when you choice a specific drop-down on column A? I've tried theses three formulas to try to make it happen. =IF; =VLOOKUP; =XLOOKUP
asked 2025-02-12T23:04:34.0366667+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(272, 75%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Steven Meade
0
Reputation points
commented 2025-02-13T01:57:43.09+00:00
Emi Zhang-MSFT
27,716
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Superposición de una tabla dinámica con datos de la misma hoja de cálculo
Estoy haciendo un Dashboard en una hoja de Excel, en el que se analiza los factores interviniente en las bajas voluntarias producidas en una empresa. Para ello he realizado varias tablas dinámicas. Algunos de los paneles que compone con el dashboard van…
asked 2023-08-03T14:55:02.1333333+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(134.4, 43%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Ana Maria Jimenez Ortega
25
Reputation points
commented 2025-02-12T18:39:15.4633333+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(169.60000000000002, 91%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Cristian Mena
0
Reputation points
1 answer
Issues with .xlsm Files and Macros After Uploading to OneDrive
Hello everyone! There have been persistent issues with .xlsm documents that contain macros/VBA after uploading them to OneDrive. A function was added in VBA to update the last modified date of the workbook: Function LastModifiedDate() As String …
asked 2025-02-03T15:49:00.42+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(256, 91%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dneesal
0
Reputation points
commented 2025-02-12T09:34:26.0066667+00:00
Jiajing Hua-MFST
14,575
Reputation points Microsoft Vendor
0 answers
How do I have lower rows in a pivot table stay visible when collapsing the row above it?
I have sales data by center and team member in an Excel Pivot Table. When I have weeks showing, I can see the center and team member results, like below. (Team members show when the center in expanded) If I collapse to just the see the period results, I…
asked 2025-02-11T02:20:56.0466667+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(118.4, 44%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kurt Clawson
0
Reputation points
commented 2025-02-12T02:17:05.3266667+00:00
Emi Zhang-MSFT
27,716
Reputation points Microsoft Vendor
1 answer
Excel won't open on my MAC
Excel won't open on my MAC. System message says it's because it is being updated, but it's been saying that for a few hours. I'm on the latest version of Sequoia 15.3. Latest date modified for EXCEL is 12/11/24; for WORD last date modified is 2/4/25, and…
asked 2025-02-09T22:33:11.33+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(201.6, 91%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKL%3C/text%3E%3C/svg%3E)
Ken Lay
0
Reputation points
commented 2025-02-12T01:18:36.0333333+00:00
Emi Zhang-MSFT
27,716
Reputation points Microsoft Vendor