3,623 questions with Excel-related tags

Sort by: Updated
1 answer

pivot and groupby function does not work in excel

The pivot and groupby function does not work in Excel, I have a Microsoft 365 E5 license, Excel is updated with version 24.11 build 18227.20222. I ran Microsoft 365 Repair Tool and still have the issue.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
asked 2025-01-25T19:13:12+00:00
Silva, Igor 0 Reputation points
answered 2025-01-27T11:32:42.9466667+00:00
Silva, Igor 0 Reputation points
1 answer

What Excel products support Picture in Cell?

I have an Excel application created using Excel 365 and in 2023 (I believe) Microsoft Excel began to support inserting an image in a cell. Whereas prior to that, one could place an image on sheet but the image would remain over the cells. With the…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,857 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
asked 2025-01-22T18:08:34.69+00:00
Steve Bisel 0 Reputation points
commented 2025-01-27T09:54:57.1666667+00:00
Jiajing Hua-MFST 13,760 Reputation points Microsoft Vendor
1 answer

Cannot Save-As Any Excel File As Of This Morning

I cannot save-as any new Excel files as of this morning (1/21/2025). Attempts to save-as existing Excel files as new files is also not possible. What can I do to remedy this?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
asked 2025-01-21T17:47:11.5466667+00:00
Harrison Pierce 0 Reputation points
commented 2025-01-27T09:19:20.8266667+00:00
Emi Zhang-MSFT 27,396 Reputation points Microsoft Vendor
1 answer

Encrypted Excel File Modified in Other Office Software Cannot Be Opened in Microsoft Excel

Hello Everyone, I encrypted an Excel file using Microsoft Excel's built-in password protection. Later, I opened and modified the file in WPS Office(another Office software). After saving the file in WPS, it can no longer be opened in Microsoft Excel.…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,857 questions
Azure Disk Encryption
Azure Disk Encryption
An Azure service for virtual machines (VMs) that helps address organizational security and compliance requirements by encrypting the VM boot and data disks with keys and policies that are controlled in Azure Key Vault.
178 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
Azure Site Recovery
Azure Site Recovery
An Azure native disaster recovery service. Previously known as Microsoft Azure Hyper-V Recovery Manager.
750 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,177 questions
asked 2025-01-24T05:51:52.0266667+00:00
Bohan Wang 0 Reputation points
commented 2025-01-27T08:59:57.45+00:00
Jiajing Hua-MFST 13,760 Reputation points Microsoft Vendor
6 answers

How to fix error AADSTS500200: User account is a personal Microsoft account. Personal Microsoft accounts are not supported for this application

Sorry, but we’re having trouble signing you in. AADSTS500200: User account 'su*****sk@gmail.com' is a personal Microsoft account. Personal Microsoft accounts are not supported for this application unless explicitly invited to an organization. Try signing…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,857 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
23,004 questions
asked 2024-01-03T10:26:38.1066667+00:00
sumit 35 Reputation points
commented 2025-01-27T07:50:28.7733333+00:00
djf 0 Reputation points
1 answer

I am trying to update an excel report that someone else created. Anytime I select Data > Refresh All I get the following error: [ODBC Driver Manager] The specified DSN contains an mismatch between the driver and application

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 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,752 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,752 questions
asked 2025-01-24T21:17:45.4966667+00:00
Cheryl Mallory/USA 0 Reputation points
answered 2025-01-27T07:32:45.4266667+00:00
Emi Zhang-MSFT 27,396 Reputation points Microsoft Vendor
1 answer

I am trying to update an excel report that someone else created. Anytime I select Data > Refresh All I get the following error: [ODBC Driver Manager] The specified DSN contains an mismatch between the driver and application

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 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,752 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,752 questions
asked 2025-01-24T21:17:45.4966667+00:00
Cheryl Mallory/USA 0 Reputation points
answered 2025-01-27T07:32:45.4266667+00:00
Emi Zhang-MSFT 27,396 Reputation points Microsoft Vendor
1 answer

Excel 2016 don't open

I am trying to open excel files with external link data without success. It load until 100% but don't open. I did tried this solutions: -Uninstalled Microsoft 365 (Office) -Uninstall Office 2016 / Clean Registry Keys / Reinstall -Apply all Office updates…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,857 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
10,546 questions
asked 2025-01-24T09:09:22.4433333+00:00
MarcusMonteiro-1399 0 Reputation points
answered 2025-01-27T07:12:11.04+00:00
Emi Zhang-MSFT 27,396 Reputation points Microsoft Vendor
1 answer

I need help with vba coding to properly create an entry form that inputs data to a master table

In microsoft excel, I have a ws titled "ENTRY". On this ws, I have several inputs one of which is "LINE ITEMS" that asks for a quantity between 1-20. Depending on this input, the amount of rows the entry data will be is assigned into…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 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,177 questions
asked 2025-01-23T17:20:12.2033333+00:00
Bobby Lichenstein 0 Reputation points
answered 2025-01-27T06:55:39.8033333+00:00
Barry Schwarz 3,326 Reputation points
1 answer

Files on SharePoint cannot be edited due to the error that shows we temporarily repaired.

Hello Please i need your help on this issue. There is an error message saying WORK BOOK REPAIRED We temporarily repaired this workbook so that you can open it in Reading View on a SharePoint file. The user is trying to Edit Workbook ] Fix it ] Ran…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,124 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,124 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
3,225 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
3,225 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,752 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,752 questions
asked 2025-01-25T00:57:29.9366667+00:00
IniobongNkanga-8038 931 Reputation points
answered 2025-01-27T02:48:28.9033333+00:00
AllenXu-MSFT 22,856 Reputation points Microsoft Vendor
1 answer

Files on SharePoint cannot be edited due to the error that shows we temporarily repaired.

Hello Please i need your help on this issue. There is an error message saying WORK BOOK REPAIRED We temporarily repaired this workbook so that you can open it in Reading View on a SharePoint file. The user is trying to Edit Workbook ] Fix it ] Ran…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,124 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,124 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
3,225 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
3,225 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,752 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,752 questions
asked 2025-01-25T00:57:29.9366667+00:00
IniobongNkanga-8038 931 Reputation points
answered 2025-01-27T02:48:28.9033333+00:00
AllenXu-MSFT 22,856 Reputation points Microsoft Vendor
2 answers

Error 53 - how to fix

Brand new Mac mini purchased today - installed Office 365 with my work credentials and met with this on start-up

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
934 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,857 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
asked 2024-03-25T07:25:05.7533333+00:00
MS 0 Reputation points
commented 2025-01-25T07:00:50.5033333+00:00
Szabolcs SzT 0 Reputation points
1 answer

Export scheduling poll results to an excel spreadsheet

I am scheduling a meeting using the scheduling poll for over 15 people and over 30 options. Is there a way to export the results to an excel spreadsheet (similar to the Doodle export function)?

Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
5,421 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,752 questions
asked 2023-07-10T17:45:07.75+00:00
Jessica Dery 20 Reputation points
commented 2025-01-24T20:06:01.47+00:00
TenHulzen, Bre 0 Reputation points
1 answer

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,857 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
asked 2024-10-09T22:21:39.6866667+00:00
Keiran 0 Reputation points
commented 2025-01-24T14:44:24.1766667+00:00
Alan Ramos 0 Reputation points
1 answer

I keep getting error code 9n155 while sign in for MS365.

Hi, I am facing this issue for few weeks and unable to sign in MS365. I am using Mac 2024 with update software. I get this message while sign in MS 365: Correlation Id: 60442844-a2a7-4143-b80a-5e3001c84f34 Timestamp: 2025-01-22T15:51:52.000Z DPTI:…

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.
5,568 questions
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
934 questions
PowerPoint
PowerPoint
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
330 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
526 questions
asked 2025-01-22T16:06:27.1433333+00:00
NKO 0 Reputation points
commented 2025-01-24T12:35:48.9+00:00
NKO 0 Reputation points
0 answers

How to fix 0x8002802B Excel issue without repair Microsoft 365?

I have develop a tool which is using Microsoft.Office.Interop.Excel.Application and Microsoft.Office.Interop.Excel.Workbook to operate Excel. It can work well, but when my office get update from IT, my tool will get…

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.
5,568 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
asked 2025-01-24T11:37:25.95+00:00
Zhang, Xiaona 0 Reputation points
7 answers One of the answers was accepted by the question author.

How to create Excel file with Visual Studio 2022 and C#

I'm working with Visual Studio 2022, Project WPF C# with .Net 6.0 and Entity Framework Core. DataBase MS SQL Express.I have also a valid and active licence Microsoft Office 365. I try to Create an Excel File but I have different error msg (see…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,066 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 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.
11,237 questions
asked 2023-08-06T15:37:30.7133333+00:00
Dmtr_Grms 331 Reputation points
answered 2025-01-24T10:28:07.3566667+00:00
Stefan Krabbe 0 Reputation points
1 answer

Single value expected, but array delivered

Hi @ all! This formula should spill all data from January 2025 and expand this array by 3 (3 = WEEKDAY from January 1st, 2025). But it only works if the @ is…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
asked 2025-01-17T11:47:25.6966667+00:00
Boris Georgi 0 Reputation points
commented 2025-01-24T09:49:41.39+00:00
Emi Zhang-MSFT 27,396 Reputation points Microsoft Vendor
1 answer

Security Excel

After browsing several forums, I find that the only real security for an Excel file is encryption with a password. Unfortunately, a person who knows the password can change it after having access to the file. Is it possible with VBA to put a password in…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 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,177 questions
asked 2025-01-15T22:08:56.6533333+00:00
Orkit 45 Reputation points
commented 2025-01-24T08:52:08.2166667+00:00
Jiajing Hua-MFST 13,760 Reputation points Microsoft Vendor
0 answers

How can I fix 0x8002802B (TYPE_E_ELEMENTNOTFOUND) issue without repair Microsoft 365?

I have develop a tool which is using Microsoft.Office.Interop.Excel.Application and Microsoft.Office.Interop.Excel.Workbook to operate Excel. It can work well, but when my office get update from IT, my tool will get…

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.
5,568 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,107 questions
asked 2025-01-24T08:47:06.8166667+00:00
Zhang, Xiaona 0 Reputation points