1,956 questions with Excel tags

Sort by: Updated
1 answer

I need a formula that will count the numbers using the name as the identifier. So if ‘Glen’ as a name is set in the formula then it will count the number underneath in all instances of the name Glen.

Book1.pdf

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
asked 2024-11-06T18:42:44.6733333+00:00
AA 0 Reputation points
answered 2024-11-06T20:10:46.2233333+00:00
Barry Schwarz 3,071 Reputation points
0 answers

I want to be able to click on an acronyn cell and it then hightlights the cost centres attached to that acronyn

We have a list of teams with several cost centres attached to each team. I want to be able to click on a team and when I do, I want it to highlight the predetermined cells of the cost centres attached to that team. I have two lists - 1 list a cost…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 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,978 questions
asked 2024-11-06T01:08:57.8466667+00:00
Jeanette Seeds 0 Reputation points
commented 2024-11-06T08:48:14.6266667+00:00
Barry Schwarz 3,071 Reputation points
2 answers

Strange Excel Bug I haven't seen before - inserting new columns prevents calculation

I have a excel file I'm working on, it uses efficient formulas and only takes 3 seconds to calculate... until If I try inserting a new column anywhere in the sheet, something strange happens. it takes ages to create to the column (longer than usual) then…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
asked 2024-10-31T17:34:22.77+00:00
barnaby king 0 Reputation points
commented 2024-11-06T08:34:36.3033333+00:00
Jiajing Hua-MFST 10,645 Reputation points Microsoft Vendor
1 answer

Conditional Formatting

Hi I had applied those rules for : green - is up-to-date red - expired yellow - near to expire ( around 90 days before) I have another sheet that worked from my other training matrix. However, the YELLOW does not apply when it is inside the 90 days…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
asked 2024-11-01T09:39:22.4133333+00:00
LAILA TEIXEIRA COSTA 0 Reputation points
commented 2024-11-06T08:27:18.23+00:00
Jiajing Hua-MFST 10,645 Reputation points Microsoft Vendor
2 answers

My pivot does not show the GETPIVOTDATA functionality even though it is turned on

My pivot does not show the GETPIVOTDATA functionality even though it is turned on

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
asked 2024-11-01T16:16:23.7366667+00:00
Sood, Anoop 0 Reputation points
commented 2024-11-06T08:26:49.8+00:00
Jiajing Hua-MFST 10,645 Reputation points Microsoft Vendor
1 answer

ClosedXML and System.Memory Error in .NET 8: Anyone Solved This?

Hi everyone! I’m migrating a project from .NET 4.8 to .NET 8. The ClosedXML library is compatible with .NET 8, but I’m encountering an error when using the XLWorkbook class. Despite installing System.Memory, the error still occurs, as shown in the image…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,915 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
asked 2024-10-30T20:50:31.79+00:00
Artillis Prado 0 Reputation points
commented 2024-11-06T06:25:51.7466667+00:00
Jiale Xue - MSFT 46,376 Reputation points Microsoft Vendor
6 answers

Need to stop office apps from EVER opening in a browser on my PC. Was told to post here by answers.microsoft

I need to stop files (Excel files on SharePoint/OneDrive primarily) from opening in a browser on my PC. I feel like I've tried everything. All the advice I get is to click on the ellipses and select "open in desktop app", or go to SharePoint…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,140 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,817 questions
asked 2024-03-12T14:25:38.0033333+00:00
Patrick Ldierts 20 Reputation points
commented 2024-11-05T18:58:54.7+00:00
Chris Farnsworth 0 Reputation points
13 answers

Workbook.refreshAllDataConnections() is not supported in Power Automate.

Dear all, I have an excel sheet with an active connection which I am able to refresh to get the newest data. Now I've got another PowerAutomate Flow which is working fine with a script inside this Sheet to send me via Teams numbers which I want to be…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 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,978 questions
asked 2023-04-20T06:58:58.2433333+00:00
MMPB 80 Reputation points
commented 2024-11-05T14:30:02.0933333+00:00
Gerald Herman 0 Reputation points
0 answers

Make ProcMon easier to use with MicroSoft Excel

I have tried to export PML files to CSV in order to use Excel to work on the file. This is not going well. I have found that Excel does not support the precision that ProcMon has in the "Time of Day" field. The precision is so low that it is…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
asked 2024-11-04T09:03:44.57+00:00
Tarjei Jensen 0 Reputation points
commented 2024-11-05T08:33:35.6366667+00:00
Emi Zhang-MSFT 25,546 Reputation points Microsoft Vendor
2 answers

Excel - how to convert dd-mmm-yyyy to dd/mm/yyyy

My date format is now 01-Oct-2024, how can i use excel formula to change to 01/10/2024 dd/mm/2024

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 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,725 questions
asked 2024-10-25T08:56:29.37+00:00
nononame2021 256 Reputation points
commented 2024-11-05T07:05:28.8933333+00:00
Jiajing Hua-MFST 10,645 Reputation points Microsoft Vendor
1 answer

Formatted columns were not able to be read from sharepoint files using graph api.

Hi Team, Currently there is a use case I am working on where I will be reading excel files from Sharepoint standalone server via graph API. Everything is good but suddently I was not able to read few columns from the file. When debugged I…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,706 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,256 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,619 questions
asked 2024-10-28T06:44:01.18+00:00
Anumalasetti, Naveen 0 Reputation points
commented 2024-11-05T02:53:58.45+00:00
Emily Du-MSFT 47,296 Reputation points Microsoft Vendor
1 answer

When I try to use data analysis add in, my excel shows "automation error exception occurred" and crashes.

When I click Data analysis, i get the error "Microsoft Visual Basic for Applications Automation error Exception occurred." and then it crashes. I have no idea how to fix, I've tried clicking the 1.0 check box alt f11 and I have uninstalled and…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
asked 2024-10-27T10:26:12.8966667+00:00
Joon Sunwoo 0 Reputation points
commented 2024-11-04T09:24:32.9566667+00:00
Jiajing Hua-MFST 10,645 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How can AI-driven solutions like Microsoft's AI tools improve productivity in daily workflows across Microsoft 365 apps?

I've been exploring AI tools integrated into Microsoft 365 apps like Word, Excel, and Teams. I’m curious to understand how AI-powered features like Copilot or AI-driven insights can streamline workflows for professionals. What are some practical examples…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
878 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,297 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,817 questions
asked 2024-10-23T05:55:23.9033333+00:00
Saqlain Ahmed 20 Reputation points
edited a comment 2024-11-04T08:55:23.44+00:00
Emily Du-MSFT 47,296 Reputation points Microsoft Vendor
1 answer

how many rows can excel sort?

i have a large excel document but the when I try to sort it only takes into account part of the data an not all of it how can i solve this problem?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
asked 2024-11-03T13:18:22.68+00:00
anton twersky 0 Reputation points
answered 2024-11-04T08:24:12.9366667+00:00
Emi Zhang-MSFT 25,546 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

What are the limitations and best practices export custom list to excel ?

Hi, I created some custom lists in Team Site in SharePoint 2019 and created list items with custom columns, here What are the limitations and best practices export custom list to excel how many number of list items can be export to excel as i…

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,372 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
asked 2024-10-30T21:11:48.6933333+00:00
adil 1,286 Reputation points
edited the question 2024-11-04T01:31:23.0733333+00:00
Emily Du-MSFT 47,296 Reputation points Microsoft Vendor
1 answer

the microsoft.ace.oledb.12.0 provider is not registered on the local machine

My system are windows 11, office 365 , Amos 26. When I import excel file to Amos which show the error of microsoft.ace.oledb.12.0 provider . would you tell me how reinstall ace.oledb 12 regards, Frederic

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
asked 2024-11-02T02:29:12.3633333+00:00
Frederic Ho 0 Reputation points
answered 2024-11-02T05:05:25.9033333+00:00
Olaf Helper 45,096 Reputation points
2 answers

SSIS package that supposed to export data from SQL to Excel stopped working after upgrading to SQL2022

Hello. We have multiple SSIS packages that import data from Excel into SQL and export results back to Excel. All those SSIS packages were designed in VS 2012, connecting to SQL 2012 and Excel 2013, and we can run it successfully as a part of SQL job or…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 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,977 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,590 questions
asked 2024-10-30T19:46:03.3633333+00:00
Alla 0 Reputation points
commented 2024-11-01T14:17:05.1333333+00:00
Alla 0 Reputation points
0 answers

how to lock dropdown cells after date passed

i am preparing invoice in Excell, i want lock dropdown cells after date passed in password protected active sheets. cells E8 to E27 (Product) activated dropdown, I8 to I27 and P8 to P27 also required to lock without editable. Note:- remining columns (…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 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,978 questions
asked 2024-11-01T06:34:00.0933333+00:00
Mohamed Ali Samsudeen 0 Reputation points
commented 2024-11-01T08:39:06.1133333+00:00
Jiajing Hua-MFST 10,645 Reputation points Microsoft Vendor
1 answer

Excel/Powerpoint send as attachment feature not working correctly in new Outlook

When sending emails from excel/powerpoint as attachment, the email doesn't get delivered to user in new outlook. The same can be done in old outlook.

Outlook
Outlook
A family of Microsoft email and calendar products.
3,994 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.
302 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
asked 2024-07-09T05:44:33.5666667+00:00
Kumar, P. ab 35 Reputation points
commented 2024-11-01T04:12:15.9933333+00:00
Sean Leary 0 Reputation points
1 answer

Is Power Query Refresh Broken?

I'm experiencing an issue with Power Query refresh in Excel. I'm using Excel Microsoft Office Home and Business 2016 and the issue started after the May 30th, 2024 update. Here's a detailed description of the problem: I upload data from various sources…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
asked 2024-06-12T08:26:04.3733333+00:00
Mr. George S 5 Reputation points
edited the question 2024-10-31T16:28:22.86+00:00
simo-k 555 Reputation points