Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 questions
1 answer
Unable to import excel workbook into MSSQ.
I created a localdb through cmd via a youtube tutorial which allowed me to connect. i am in the mssql application and created my first database. I am wanting to import excel workbooks but the wizard is showing the below error message here, i checked…
asked 2024-04-24T12:44:49.56+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(262.40000000000003, 19%, 35%)' 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)
Mo
0
Reputation points
answered 2024-04-25T01:34:31.8933333+00:00
ZoeHui-MSFT
32,586
Reputation points
2 answers
One of the answers was accepted by the question author.
file extension not displaying during save as
Hi, When I want to save as a file, the file extension does not display in drop-down menu! for example I mean (*xtds)
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,297 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 questions
0 answers
getSeries() does not work in Excel scripts
Hi, I got an issue with using the getSeries() function in excel script. I want to write script to change the color of the pie chart. I did it manually and I recorded it. The below is the code: function main(workbook: ExcelScript.Workbook) { let…
![](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(102.4, 14.000000000000002%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
0 answers
Using ADF, how to dynamicaly replace excel headers blank spaces with underscores?
Hello, I'm working on an ADF pipeline whose goal is to copy an Excel file to a blob storage as a parquet file. To do so, I'm using a copy data activity. This activity needs to be as parametrized as possible, meaning that the Excel file schema is not to…
asked 2024-04-24T13:33:57.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(310.4, 27%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
DIAMANT Marius
0
Reputation points
asked 2024-04-24T13:33:57.16+00:00
DIAMANT Marius
0
Reputation points
3 answers
How to fix "There was a problem saving and AutoSave was disabled. Please Save As or close and reopen the file."
Hi, so this is the problem we're having: Me and my colleague at work use Excel Spreadsheet (with VBA macro) in Onedrive for our working paper. It works just fine most of the time, but sometime we ran into a problem when saving our progress, it says…
asked 2024-02-01T11:31:38.63+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, 89%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Penn Tan
10
Reputation points
answered 2024-04-24T09:53:10.3133333+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, 62%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
Philip Leicester
0
Reputation points
1 answer
Powershell (?) run a task that open and closes a Sharepoint excel file in the desktop version
I need to open an Excel file from sharepoint in the desktop app daily many times a day, keep it open a couple of minutes and have it close. This so the file updates itself, as it is connected to external data. Can this be acomplished in some way?
asked 2024-04-24T06:37:18.2933333+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, 21%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mata Ricardo
0
Reputation points
answered 2024-04-24T09:35:33.7766667+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, 82%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELZ%3C/text%3E%3C/svg%3E)
Ling Zhou_MSFT
13,105
Reputation points Microsoft Vendor
2 answers
Power Query cannot list the content of certain SharePoint pages
Hello everyone, I hope someone can give me a tip. We have Office 2021 Professional on the computer and we have SharePoint 2013. There is the function "From File" and then "From SharePoint Folder". So now it's getting funny. Site 1Site…
asked 2024-04-22T16:33:46.62+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, 34%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Ramaka
0
Reputation points
commented 2024-04-24T08:01:56.18+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(160, 17%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYJ%3C/text%3E%3C/svg%3E)
Yanli Jiang - MSFT
21,371
Reputation points Microsoft Vendor
0 answers
COM timeout Excel
Microsoft 365 Excel version 2403. C# application (WPF on .Net 8) using excel COM interop ("automation") which adds a menu in the Excel application and setsup a click handler (in WPF). All works normally just fine, but when debugging and say…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 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,234 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,479 questions
![](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(240, 30%, 33%)' 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)
1 answer
Opening an .html file with columnar data in Excel
Hi, I have an .html document that is generated by another application that I would like to import into Excel. I couldn't figure out how to paste .html into this post without having it interpreted, so I have attached it as an image below. I have also…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 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,479 questions
asked 2024-04-23T18:44:36.4233333+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(73.60000000000001, 9%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Paul Kraemer
266
Reputation points
answered 2024-04-24T03:57:54.9433333+00:00
Andreas Killer
80
Reputation points
21 answers
Error Another account from your organization is already signed in on this device. Try again with a different account.
Hello, I keep getting the error - "Error Another account from your organization is already signed in on this device. Try again with a different account." I've been trying to use all of the tips, tricks, and fixes available online, but nothing…
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
657 questions
OneNote
OneNote
A family of Microsoft products that enable users to capture, organize, and reuse notes electronically.
159 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,059 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 questions
asked 2023-02-17T17:42:05.4166667+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, 21%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Sarah Nelson
60
Reputation points
commented 2024-04-23T14:36:44.98+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(195.2, 60%, 28%)' 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)
Delante
0
Reputation points
1 answer
New Excel workbooks (created in SharePoint library) not launching in app - .xlsx "extension is not valid"
Hi there, Having a recent issue in some SharePoint sites - in Document Libraries, using the (default) New > Excel Workbook action gives the error when launching the app: "Excel cannot open the file 'Book.xlsx' because the file format or file…
asked 2024-04-16T01:29:14.2533333+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(70.4, 64%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Alan Walker
20
Reputation points
commented 2024-04-23T09:02:38.6633333+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
19,636
Reputation points Microsoft Vendor
0 answers
In Excel's Python, when running a double for loop, it shows "timeout".
import pandas as pd for index, row in df1.iterrows(): invoice_num = row['num'] for index2, row2 in df2.iterrows(): if row2['num'] == invoice_num: receivable_balance = df1.loc[index, 'rece‘] - row2['come'] df1.loc[index, 'rece'] =…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 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,479 questions
asked 2024-04-23T01:36:19.53+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, 89%, 15%)' 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
edited the question 2024-04-23T08:06:05.27+00:00
Emi Zhang-MSFT
21,706
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How do I update a cell in Excel without firing an Change event?
I'm trying to backfill a cell that is used to hold a function parameter. The new value may be different from the original, hence the need to update. What I don't want to do is execute the function after the new parameter is set.
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 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,479 questions
![](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, 92%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
1 answer
[excel] how to do "enter" in a cell or how to calculate the cell with VBA
Good evening all, First of all english is not my mother langage, so I apologize, I have a question about a VBA I made a macro that works but not in the way I want. I have a sheet that is the sum of a yearly planning updated monthly. In this sheet I have…
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.
3,764 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 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,479 questions
![](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, 2%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
1 answer
In XLOOKUP and XMATCH wildcard search does not work together with binary search
In a spreadsheet with NameAmountCarol90Christel43Christian85Christopher27the formulas =XLOOKUP("Christ*";A2:A6;B2:B6;;2;1) =XMATCH("Christ*";A2:A6;2;1) work. But…
asked 2024-04-20T21:10:25.9433333+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(300.8, 83%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Regina Henschel
151
Reputation points
commented 2024-04-23T05:25:14.6233333+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
4,675
Reputation points Microsoft Vendor
2 answers
Conditional formatting issue
I am having an issue with conditional formatting on an excel spread sheet. I am trying to have the cell change colour based on a true value, i.e., a specific word, but it will not recognize the words "Low" or "Medium" I can use the…
asked 2024-04-19T13:51:08+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(313.6, 36%, 40%)' 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)
Colin M
0
Reputation points
commented 2024-04-23T02:54:02.3033333+00:00
Jiajing Hua-MFST
4,675
Reputation points Microsoft Vendor
0 answers
ERROR: -2147467259 - Unable to get property 'restorePruning' of undefined or null reference
We have a perl script on a Linux server that invokes a VBScript on Windows Server 2019 to refresh the data in an excel pivot sheet and then save a copy of the same without the data connections. We randomly face an error in this process, but the issue is…
Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,454 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 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,479 questions
asked 2024-04-22T14:15:43.4933333+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, 89%, 21%)' 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)
Abhishek Mendon
0
Reputation points
edited the question 2024-04-23T00:32:37.21+00:00
Emi Zhang-MSFT
21,706
Reputation points Microsoft Vendor
0 answers
how to get all work sheet names and cell details
Hello, i have the existing script in my workbook: I would like to get all the worksheet names (instead of specifying as ive done), and include it in the batch details output. Thank you function main(workbook: ExcelScript.Workbook) { const ws =…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
866 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,479 questions
asked 2024-04-22T11:20:07.47+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, 34%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Cooke, Scipio UK/LPL
0
Reputation points
edited the question 2024-04-23T00:31:35.3433333+00:00
Emi Zhang-MSFT
21,706
Reputation points Microsoft Vendor
1 answer
Office Script
When there will be in Office Script: Alert(), Confirm(), Prompt(). It's the minimum to interact with the user and guide them.
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 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,479 questions
asked 2024-04-21T20:05:13.46+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(310.4, 84%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
GIVANILDO SILVA DE AMORIM
0
Reputation points
answered 2024-04-22T22:39:01.05+00:00
GIVANILDO SILVA DE AMORIM
0
Reputation points
3 answers
One of the answers was accepted by the question author.
Is support for SQL data queries in Excel being phased out?
I was told today by my IT department that I'll have to stop using Excel with SQL data queries to pull data directly into Excel from a SQL server. They stated that Microsoft was phasing out this feature. I couldn't find anything searching the Microsoft…
asked 2024-04-19T19:34:52.87+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(217.60000000000002, 18%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Colin Sachs
40
Reputation points
answered 2024-04-22T15:44:42.1933333+00:00
Colin Sachs
40
Reputation points