Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 questions
2 answers
One of the answers was accepted by the question author.
Why doesn't table connection for Excel pivot table work?
Hello, I'm creating a pivot table based on two Excel tables: Sales and Orders. The unique field is the OrderDetailNumber. The OrderDetailNumber exists only one time in both tables. It's origin is in the Orders table and it shows up (is put) in the Sales…
asked 2023-02-01T16:00:45.3166667+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(240, 6%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jan Sijben
20
Reputation points
accepted 2023-02-10T16:18:22.9233333+00:00
Jan Sijben
20
Reputation points
1 answer
Problem with Excel file on network share and edit queue
Hello. There is an Excel file on the network share. It needs to be opened and edited by multiple people. Accordingly, when the first user opens for editing, he is blocked for the rest and when trying to open it, Excel will inform them about it and give…
asked 2023-02-09T12:02:55.0766667+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(105.60000000000001, 30%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Pavel.Dyachuk
251
Reputation points
commented 2023-02-10T12:22:30.4433333+00:00
Pavel.Dyachuk
251
Reputation points
1 answer
How do I protect part of a worksheet in an Excel workbook?
Hi, I am trying to protect a tab within an Excel worksheet. Intent is to protect so that no one can change formatting, enter columns, delete information, etc. However, I do want individuals to be able to enter new rows and/or edit data in cells on…
asked 2023-02-06T14:09:33.7433333+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, 15%, 17%)' 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)
Brooks, Suzanne
0
Reputation points
commented 2023-02-10T09:37:46.7+00:00
Emily Hua-MSFT
27,601
Reputation points
1 answer
How can i use an sql query to bring data into a table in excel?
Im using an ODBC connection with mysql.
asked 2023-02-09T17:22:36.94+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(243.2, 97%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
Rubén Gamboa
0
Reputation points
answered 2023-02-09T17:31:25.7933333+00:00
Rubén Gamboa
0
Reputation points
3 answers
Do not open file with VBA in Excel
I have problem with open file .xlsb .xlsm in Excel (Office 365). After open file with start macros VBA code, file automatic close. In logs: Назва аварійного застосунку: EXCEL.EXE, версія: 16.0.15928.20216, позначка часу: 0x63b610f9 Назва аварійного…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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,715 questions
asked 2023-01-20T20:42:33.32+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(316.8, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TVY
5
Reputation points
commented 2023-02-09T09:06:07.2466667+00:00
Emily Hua-MSFT
27,601
Reputation points
1 answer
One of the answers was accepted by the question author.
MATCH the result
I need the Column J result:
![](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, 48%, 23%)' 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)
0 answers
Importing Date in a .csv file.
Hello dear support, I have a problem regarding an import of datatype Date from a .csv file. The problem is described in the attached screenshit: I do import correctly dates in the blue rectangle ( because it can only be a dd/MM/yyyy i suggest), like…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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,640 questions
asked 2023-02-08T08:02:35.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(144, 36%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Pierre Velluet
1
Reputation point
commented 2023-02-08T11:34:45.32+00:00
Olaf Helper
43,246
Reputation points
1 answer
why /me/drive/SharedWithMe Returns "value": []
I'm getting it: R R I'm getting it "error": { "code": "accessDenied", "message": "Access denied", "innerError": { "date":…
asked 2023-01-18T19:29:09.71+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, 96%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Lucas Matheus Rodrigues Brum
0
Reputation points
commented 2023-02-08T06:08:47.3066667+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, 5%, 34%)' 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)
RaytheonXie_MSFT
33,641
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Multi-conditional search returns non-duplicate values
Returns the non-repeating value of column A according to the date and name
1 answer
Power Query Contains in collum
Hello I wanted to make a function, in which, if the value of column 1 is inside column 2, show "yes" if not, show "No"
asked 2023-02-03T17:32:22.4266667+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(243.2, 14.000000000000002%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPF%3C/text%3E%3C/svg%3E)
Pedro Faria / DUX SAO
0
Reputation points
answered 2023-02-06T08:35:26.12+00:00
Emily Hua-MSFT
27,601
Reputation points
1 answer
How to fix excel student account credential?
Hi Unfortunately, I just disabled my student credential for excel. From managing device options I disabled it. Please help me with this. How can I fix this issue?
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,470 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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,715 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,689 questions
asked 2023-01-19T07:04:53.72+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, 9%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYA%3C/text%3E%3C/svg%3E)
Yeasin Arafat
0
Reputation points
edited the question 2023-02-06T07:38:48.8866667+00:00
Jayce Yang-MSFT
1,331
Reputation points Microsoft Vendor
2 answers
Is there any way to load wininet.dll using macros, scripts, or PowerShell??
Hi guys ! I use a couple of macros that handle files in SharePoint thru commands like "Dir" , "Save" , "open" etc. Many of these commands (Dir for instance) do not work if wininet.dll is not "loaded". In the…
asked 2023-02-02T14:21:29.1933333+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, 63%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Marcelo Buarque (Nokia)
0
Reputation points
commented 2023-02-06T06:03:11.7733333+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(102.4, 65%, 19%)' 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)
AllenXu-MSFT
18,361
Reputation points Microsoft Vendor
1 answer
The current .NET security policy prohibits C:\Users\...\File.xlsx from loading custom macros.
I am working on a project in Visual Studio Community 2022. The project is an Excel VSTO Workbook using Visual Basic (Target framework is .NET Framework 4.8). Up until yesterday everything was working fine, I could run and debug my project whenever I…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,643 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,883 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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,715 questions
asked 2023-01-19T01:59:19.6166667+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(224.00000000000003, 15%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERF%3C/text%3E%3C/svg%3E)
Ricardo Freccero
1
Reputation point
answered 2023-02-03T19:42:40.97+00:00
Abraham Valencia
0
Reputation points
1 answer
1. i have an excel file which is called 20221226_Cash Flow_KA. 2. in this Excel file a query of CSV files is made by power query. These files are located in the folder current accounts. Accordingly, the worksheet that is output by the query is called Curr
i have an excel file which is called 20221226_Cash Flow_KA. in this Excel file a query of CSV files is made by power query. These files are located in the folder current accounts. Accordingly, the worksheet that is output by the query is called…
asked 2023-02-02T13:54:43.3166667+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(41.6, 51%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Andreas Giannaku
0
Reputation points
answered 2023-02-03T06:33:53.57+00:00
Emily Hua-MSFT
27,601
Reputation points
1 answer
Importing excel data to MS SQL using EPPlus
I am writing a C# code in .Net 6 to read data from excel and save them into the database. when reading the column with date/ date time value I realized that if the cell contains a time portion, Epplus will return the cell value as 9/1/2000 8:00:00 AM,…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 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,640 questions
asked 2023-02-03T02:31:52.5066667+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(131.20000000000002, 69%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Benjamin Chew
41
Reputation points
answered 2023-02-03T06:20:47.2766667+00:00
Olaf Helper
43,246
Reputation points
1 answer
Thousand Separator support for different region in Excel addin
Hi Team, - We are offering a Excel addin where user can upload local excel and save it to onedrive, The addin is available on office store. - In this Addin we are providing one feature where user can upload numbers in any region format(thousand…
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,420 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
974 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,715 questions
asked 2023-01-31T06:50:01.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(246.4, 57.99999999999999%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO3%3C/text%3E%3C/svg%3E)
office 365
1
Reputation point
answered 2023-02-02T13:18:21.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(3.2, 35%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Shivam Dhiman
5,951
Reputation points
1 answer
Trying to Rescale images remotely in word from excel macro
For my company one of the processes is copying graphs from an Excel spreadsheet and pasting them into a word document. However, these graphs are pasted slightly too big and need to be descaled to 80% their original size. I'm trying to write a macro in…
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
751 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,665 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,715 questions
asked 2023-01-27T16:24:48.3666667+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(44.800000000000004, 8%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Archie Smith
0
Reputation points
commented 2023-02-02T08:06:06.4333333+00:00
Emi Zhang-MSFT
23,906
Reputation points Microsoft Vendor
asked 2023-01-29T18:40:08.5133333+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(204.8, 17%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
San Lin
0
Reputation points
commented 2023-02-02T07:59:38.53+00:00
Emi Zhang-MSFT
23,906
Reputation points Microsoft Vendor
2 answers
Accessing Cheaper/Free Student Certifications
I work with students with disabilities and all are in technology classes working with Microsoft Applications. We are wanting to look at having some of them try for their certifications but cannot pay the $100 for each test knowing many may not be able to…
asked 2023-02-01T14:27:24.4366667+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, 99%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Richard, Kayla
0
Reputation points
answered 2023-02-02T03:08:32.35+00:00
Emily Hua-MSFT
27,601
Reputation points
1 answer
One of the answers was accepted by the question author.
C# Office.Interop.Excel How do I loop through the AutoFilter'd returned rows?
I have created the following AutoFilter: excelRange = excelWorksheet.get_Range("G1"); excelRange.AutoFilter(Field: 7, Criteria1: "Part Number"); excelRange.AutoFilter(Field: 7, Criteria1: ">A*", Operator:…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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,640 questions
asked 2023-01-30T17:01:16.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(89.60000000000001, 64%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Alvord, Timothy
236
Reputation points
accepted 2023-02-01T16:32:25.4333333+00:00
Alvord, Timothy
236
Reputation points