Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 questions
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…
asked 2024-10-27T10:26:12.8966667+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(28.799999999999997, 39%, 12%)' 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)
Joon Sunwoo
0
Reputation points
commented 2024-11-04T09:24:32.9566667+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
10,560
Reputation points Microsoft Vendor
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…
asked 2024-11-04T09:03:44.57+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(176, 61%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETJ%3C/text%3E%3C/svg%3E)
Tarjei Jensen
0
Reputation points
asked 2024-11-04T09:03:44.57+00:00
Tarjei Jensen
0
Reputation points
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.
879 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,281 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,796 questions
asked 2024-10-23T05:55:23.9033333+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(281.6, 34%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Saqlain Ahmed
20
Reputation points
edited a comment 2024-11-04T08:55:23.44+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, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
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?
asked 2024-11-03T13:18:22.68+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(172.8, 20%, 26%)' 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)
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
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…
asked 2024-11-01T09:39:22.4133333+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(150.4, 97%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELT%3C/text%3E%3C/svg%3E)
LAILA TEIXEIRA COSTA
0
Reputation points
edited a comment 2024-11-04T07:30:58.7966667+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(172.8, 53%, 26%)' 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)
Barry Schwarz
3,071
Reputation points
0 answers
I have two groups of images with links and I want to swap them base on condition
I have two groups of image with their respectives links to link in the worksheet to sections, glossary or other sheet. I want to superpose the group base on a condition. If the condition says E for English, I want dynamically the image group for…
Bing Image Search
Bing Image Search
A Bing service that supports searching for images and gets comprehensive results.
49 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 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,971 questions
Microsoft Intune Grouping
Microsoft Intune Grouping
Microsoft Intune: A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.Grouping: The arrangement or formation of people or things in a group or groups.
59 questions
asked 2024-10-30T19:11:49.25+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(54.400000000000006, 5%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Joël Delisle
0
Reputation points
edited the question 2024-11-04T06:28:51.46+00:00
KapilAnanth-MSFT
46,681
Reputation points Microsoft Employee
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
asked 2024-11-01T16:16:23.7366667+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, 92%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sood, Anoop
0
Reputation points
answered 2024-11-04T05:51:34.65+00:00
Jiajing Hua-MFST
10,560
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…
asked 2024-10-30T21:11:48.6933333+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(278.4, 88%, 36%)' 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)
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
asked 2024-11-02T02:29:12.3633333+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, 33%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFH%3C/text%3E%3C/svg%3E)
Frederic Ho
0
Reputation points
answered 2024-11-02T05:05:25.9033333+00:00
Olaf Helper
45,016
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…
asked 2024-10-31T17:34:22.77+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(16, 90%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
barnaby king
0
Reputation points
commented 2024-11-01T16:53:05.85+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(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Taylor
54,806
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…
![](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(172.8, 10%, 26%)' 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 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,954 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,971 questions
asked 2024-11-01T06:34:00.0933333+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(108.80000000000001, 90%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mohamed Ali Samsudeen
0
Reputation points
commented 2024-11-01T08:39:06.1133333+00:00
Jiajing Hua-MFST
10,560
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.
asked 2024-07-09T05:44:33.5666667+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, 12%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Kumar, P. ab
35
Reputation points
commented 2024-11-01T04:12:15.9933333+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, 17%, 33%)' 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)
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…
asked 2024-06-12T08:26:04.3733333+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, 11%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mr. George S
5
Reputation points
edited the question 2024-10-31T16:28:22.86+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(67.2, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
simo-k
555
Reputation points
![](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(233.6, 99%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
4 answers
how to fix Excel LTSC 2021 install problem, error code 0-2048(0)
when I start the installation of excel LTSC 2021 I have an error message that comes out 0-2048 (0) I deactivated the firewall, I uninstalled all office products, I tested the installation on another machine, it gives the same error
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,172 questions
asked 2023-02-13T12:38:39.7266667+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, 63%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hicham Salama
5
Reputation points
commented 2024-10-31T14:23:13.8266667+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(227.2, 45%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
Dimas Ahmad Eka Putra
0
Reputation points
1 answer
Not all data fields from excel uploading to MS Project via the import wizard.
I'm trying to upload a simple excel sheet to project via the import wizard. I have two issues; Task Name does not show up when mapping to project on the wizard I have 2 columns/rows to upload - task name and duration, however only the duration will…
asked 2024-10-30T14:55:14.11+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, 98%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EER%3C/text%3E%3C/svg%3E)
Edwards, Ryan
0
Reputation points
commented 2024-10-31T08:36:35.5633333+00:00
Jiajing Hua-MFST
10,560
Reputation points Microsoft Vendor
1 answer
Stuck on "Not Responding" when opening Excel and Publisher
Task Viewer Result: Microsoft Office 16 Alerts Event id: 300 What I already did: reinstalled Microsoft 365 repair Microsoft 365 program restart computer Please email XXXX@XXXXXXXX.com with results. Thank you
asked 2024-10-30T18:10:15.3633333+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(227.2, 64%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E7%3C/text%3E%3C/svg%3E)
73937208
0
Reputation points
answered 2024-10-31T07:40:57.9233333+00:00
Emi Zhang-MSFT
25,546
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…
asked 2024-10-30T20:50:31.79+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, 15%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Artillis Prado
0
Reputation points
commented 2024-10-31T06:56:04.12+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, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJX%3C/text%3E%3C/svg%3E)
Jiale Xue - MSFT
46,296
Reputation points Microsoft Vendor
2 answers
How to calculate the date difference excluding weekend and public holidays for specific date format
I have the following date format , but I can't use these date format to calculate the date difference excluding weekends and holiday. The two date is input as 01-Oct-2024 and 15-Oct-2024. The result should be 9. However, when I use excel function…
asked 2024-10-24T09:10:44.09+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, 71%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
nononame2021
256
Reputation points
commented 2024-10-31T01:14:25.83+00:00
Jiajing Hua-MFST
10,560
Reputation points Microsoft Vendor