1,961 questions with Excel tags

Sort by: Updated
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,961 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,983 questions
asked 2024-11-06T01:08:57.8466667+00:00
Jeanette Seeds 0 Reputation points
commented 2024-11-07T19:53:23.9866667+00:00
Jeanette Seeds 0 Reputation points
0 answers

Excel forumla longer than 8192 characters

I have a Excel worksheet that is 5490 columns wide in a shared workbook. When I save the file with zero columns hidden I do NOT get this message. When I hide every 11-15th columns it will work until I get to column 4245 approximately. After that I get…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,961 questions
asked 2024-11-07T12:53:39.91+00:00
Josh Albers 0 Reputation points
commented 2024-11-07T18:25:25.91+00:00
Josh Albers 0 Reputation points
2 answers One of the answers was accepted by the question author.

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,961 questions
asked 2024-11-06T18:42:44.6733333+00:00
AA 0 Reputation points
commented 2024-11-07T17:51:47.51+00:00
AA 0 Reputation points
0 answers

How to clear Run-time error '1004'

Received Run-time error '1004' when using macro. I'm not familiar with this macro. I believe it needs to have atleast 2 rows selected. Selection.Offset (1,0). Select is highlighted.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,961 questions
asked 2024-11-07T14:29:57.31+00:00
Jeaneth Guzman 0 Reputation points
0 answers

Multiple Condition Match Look-up [INDEX, MATCH, LEFT, SEARCH]

If after hyphen( -) full match found with A vs B + if left 3 of D match found with A= result need "found" Excel version 2021If after hyphen( -) full match found with A vs B + if left 3 of D match found with A= result need "found"…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,961 questions
Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
932 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,726 questions
Microsoft Configuration Manager
asked 2024-11-07T05:51:39.1166667+00:00
Md Yeasin 0 Reputation points
commented 2024-11-07T08:51:24.5066667+00:00
Paul Edstein 491 Reputation points
0 answers

How to Set Excel's "Find All" Feature to Search Entire Workbook by Default Instead of Current Sheet?

I'm trying to adjust Excel's "Find All" feature so that it searches the entire workbook by default, rather than only the current sheet. I’ve researched this and found that there are third-party tools and VBA macros that can accomplish this, but…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,707 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,961 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,592 questions
asked 2024-11-07T05:03:57.15+00:00
Researcher 6 Reputation points
commented 2024-11-07T07:55:01.5766667+00:00
Jiajing Hua-MFST 10,645 Reputation points Microsoft Vendor
0 answers

modifications are not saved upload file not generated cannot access a certain file. This error is on my laptop only but does appear on the same excel file on another laptop. My Macros are enabled and i have done a repair but still facing same issue

I am getting this error 'modifications are not saved upload file not generated cannot access a "certain file"'. This error is on my laptop only but does appear on the same excel file on another laptop. My Macros are enabled and i have done a…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,961 questions
asked 2024-11-07T06:46:16.22+00:00
Adil Jin Mohammed 0 Reputation points
8 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,707 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,961 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,093 questions
asked 2024-01-03T10:26:38.1066667+00:00
sumit 25 Reputation points
answered 2024-11-07T04:12:31.6866667+00:00
Anonymous
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,961 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,961 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,961 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,917 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,961 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,456 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,961 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,143 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,821 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,961 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,983 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,961 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,961 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,726 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,707 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,265 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,961 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,961 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.
882 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,307 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,961 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,821 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,961 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