1,887 questions with Excel tags

Sort by: Updated
Updated Created Answers
1 answer

Unable to Open or Copy Corrupted Excel Files on Network Drive

Hello, I have encountered an issue with few Excel files stored on a network path. Out of six files, three appear to be corrupted. When I try to open these files by double-clicking, Excel launches but displays the following error message: "Could not…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
Windows Network
Windows Network
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Network: A group of devices that communicate either wirelessly or via a physical connection.
755 questions
asked 2024-10-04T04:20:00.04+00:00
Researcher 6 Reputation points
answered 2024-10-04T13:24:31.2466667+00:00
MotoX80 33,481 Reputation points
0 answers

Editing Excel (Office script) files outside excel

Hello I tried openning and editing Officesript files with Vstudio code however it could not recognize it and there are no extensions sadly for it and copying from excel and pasting it to an empty .ts file works however it does not recognize the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
asked 2024-10-04T10:55:42.01+00:00
AlparKKacsA 0 Reputation points
0 answers

Excel files cannot be opened in new outlook and it works in old outlook.

Whenever a user is trying to open any excel file shared on email he is receiving an error message. The same file can be opened in OWA and old outlook. Reinstallation of office dint work. User was able to open these files in new outlook earlier. Error…

Outlook
Outlook
A family of Microsoft email and calendar products.
3,813 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
asked 2024-10-04T10:17:26.84+00:00
Kumar, P. ab 0 Reputation points
1 answer

My Micro-office isn't working now.

Hello, I bought 1-year of Micro-Office Professional Plus 2021 yesterday, but it isn't working now. #. It used to run fine without any problems, but when I updated it, it said it could only run in safe mode because it had been a long time since I last ran…

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.
4,880 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,627 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.
291 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
Microsoft Q&A
Microsoft Q&A
Use this tag to share suggestions, feature requests, and bugs with the Microsoft Q&A team. The Microsoft Q&A team will evaluate your feedback on a regular basis and provide updates along the way.
840 questions
asked 2024-10-04T07:47:39.07+00:00
신웅 윤 0 Reputation points
answered 2024-10-04T08:49:16.5366667+00:00
Jiajing Hua-MFST 9,905 Reputation points Microsoft Vendor
0 answers

Could not get data from web using Azure AD authentication in Excel

I have a flask web app, and an app registration on my azure account (the tenant is "common"). One endpoint of my web app returns data that can be read by excel. The authentication happen at code level, not in Azure, providing an MS graph access…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
21,684 questions
asked 2024-09-24T15:00:06.21+00:00
Bava, Alberto 0 Reputation points
commented 2024-10-04T06:17:48.3366667+00:00
Navya 10,540 Reputation points Microsoft Vendor
1 answer

Excel error when downloading from an external data manager.

I use an external data management program to download data into excel. It has worked problem free for several months, but I have started getting this error when I try to download. Error report Exception: System.InvalidCastException: Unable to cast COM…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
asked 2024-10-03T14:37:33.17+00:00
David Watt 0 Reputation points
answered 2024-10-04T02:09:09.88+00:00
Jiajing Hua-MFST 9,905 Reputation points Microsoft Vendor
1 answer

Excel: Setting up Conditional Formatting for Skill Expiry Dates

Hello, How can I set up conditional formatting for expiration dates in Excel? I have a sheet with names in a column, skills across the top, and dates in the cells specifying when these skills were completed. There are four types of skills that expire…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 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,715 questions
asked 2023-10-26T02:17:21.92+00:00
Net973 10 Reputation points
commented 2024-10-02T19:04:45.52+00:00
Barry Schwarz 2,901 Reputation points
1 answer

vlookup, xlookup functions does not function in excel and more

Dear sirs, I have Office 365 correctly updated and I found out that in Excel, functions (vlookup, and xlookup - I din't try other) doesn't work. At the same time, in Word, there's no note about Saving to the disk, as was before. Usually Word writes…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
841 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
asked 2024-09-22T11:08:00.9066667+00:00
Ranko Skansi 0 Reputation points
commented 2024-10-02T13:02:07.2366667+00:00
Ranko Skansi 0 Reputation points
0 answers

Excel Automate Changing Formula on Corresponding Tabs.

I am trying to use the Automate feature to simplify some data structuring for my team. Once properly arranged said data is dispersed across two tabs in the same file using a Filtering formula. Once I engage the Automate function the formula on the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 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,895 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,715 questions
asked 2024-10-01T12:32:23.99+00:00
Elia, Nicholas (HEALTH) 20 Reputation points
edited the question 2024-10-02T00:59:47.5666667+00:00
Emi Zhang-MSFT 24,986 Reputation points Microsoft Vendor
0 answers

How to apply the column width along with word wrap

I have an excel in which data is large i.e.2000 characters for a cell.Since no wrap was there I have added the wrap handling and extra code so that I am able to scroll properly. But column width is not getting set. It is 273+ only.Tried autofitcolumn as…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 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,895 questions
asked 2024-10-01T12:15:41.6266667+00:00
Ruchita 40 Reputation points
edited the question 2024-10-02T00:59:32.8533333+00:00
Emi Zhang-MSFT 24,986 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

I can't get Excel SUMIF() function to recognize the asterisk wildcard.

Trying to separate sum by year. Standard mm/dd/yyyy date format was used but there are a half dozen blank cells between dates. =SUMIF($B$9:$B$600,"*2022",$E$9:$E$600) Results are 0 though there are 2 dozen entries for 2022.

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.
4,880 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
Microsoft Managed Desktop
Microsoft Managed Desktop
A cloud-based service that brings together Microsoft 365 Enterprise and adds these features: User device deployment; IT service management and operations; and Security monitoring and response.
56 questions
Microsoft Copilot for Microsoft 365 Development
Microsoft Copilot for Microsoft 365 Development
Microsoft Copilot for Microsoft 365: Microsoft 365 Copilot refers collectively to Copilot experiences within Microsoft 365 applications.Development: The process of researching, productizing, and refining new or existing technologies.
137 questions
asked 2024-09-21T22:53:08.4333333+00:00
Robert Spears 20 Reputation points
commented 2024-10-01T23:02:46.84+00:00
Robert Spears 20 Reputation points
1 answer One of the answers was accepted by the question author.

Excel Conditional Formatting

How do I configure conditional formatting in Excel for years, months, or days? The header row had names of training and header column has names of people. All other cells have dates that training was completed. I have the formula setup to highlight a…

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.
4,880 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,627 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
asked 2024-09-30T15:02:36.3+00:00
Daniel Guardamondo 45 Reputation points
commented 2024-10-01T14:17:44.93+00:00
Daniel Guardamondo 45 Reputation points
2 answers

How do I get Sites/SharePoint to show on Word/Excel?

In Word/Excel, I want to be able to see SharePoint as a place under OneDrive. Others have this option, but I'm not sure why I don't. This is what I see. And this is what I am trying to see. I have uninstalled and reinstalled office, which did not fix…

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.
4,880 questions
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
841 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,684 questions
asked 2024-09-27T20:02:55.0366667+00:00
Cody McCaskill 0 Reputation points
answered 2024-10-01T07:38:28.1966667+00:00
Xyza Xue_MSFT 24,716 Reputation points Microsoft Vendor
1 answer

Excel Relationship Management

In my Excel, in the Data Tools pane, I don't have the Manage Table Relationships icon. Power Pivot was enabled by me. Can you help me? I have Microsoft 365 Home Office.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
asked 2024-09-26T07:22:26.3933333+00:00
Paulina Łacińska 0 Reputation points
commented 2024-10-01T07:06:32.9833333+00:00
Emi Zhang-MSFT 24,986 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Microsoft Word Mail Merge Issue

I am trying to create a mail merge document using an existing list of information from Excel. When completeing the merge Word is converting dates into numerals despite having them formatted as dates in the Excel document. See images below for clarity I…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
841 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
asked 2024-09-25T17:10:46.4866667+00:00
Elia, Nicholas (HEALTH) 20 Reputation points
commented 2024-10-01T07:06:20.7166667+00:00
Emi Zhang-MSFT 24,986 Reputation points Microsoft Vendor
1 answer

How to import complete data from the files in a folder?

I have a bunch of excel files in a folder, those i want to combine and transform. thus I imported them through Power Query. But while importing it, i got only first 30 rows of data, whereas the files contain data upto 10000 rows. it happens with each and…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
asked 2024-09-20T07:31:13.5733333+00:00
kashif khan 0 Reputation points
commented 2024-10-01T07:05:20.61+00:00
Emi Zhang-MSFT 24,986 Reputation points Microsoft Vendor
1 answer

Weird kerning in the formula bar Excel

Excel just started doing this: Expanding the space between the letters when I'm typing in Excel. (Notice the exaggerated space between the "S" and the "L"). When I press Enter, the spacing is corrected, but when I'm editing a cell,…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
asked 2024-09-18T13:40:31.17+00:00
Parker Beck 0 Reputation points
commented 2024-10-01T07:04:51.31+00:00
Emi Zhang-MSFT 24,986 Reputation points Microsoft Vendor
1 answer

Excel - Automatic date changer

Hi I'm trying to have one date that changes once that date is reached, adding 4 weeks to it. example: starting with the cell displaying 18 Oct 24 when it actually gets to that date, the cell adding 4 weeks to it, displaying 15 Nov 24 this action…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 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,895 questions
asked 2024-09-26T09:57:18.4766667+00:00
Kieran Grant 0 Reputation points
commented 2024-10-01T07:00:22.0266667+00:00
Emi Zhang-MSFT 24,986 Reputation points Microsoft Vendor
2 answers

Problem in capability control+shift+⬇ with mouse

control+shift+⬇ Previously chosen by pulling the mouse down all the next text There is no such capability now What is the solution?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
asked 2024-09-28T17:20:12.74+00:00
N H 0 Reputation points
commented 2024-10-01T06:56:56.7433333+00:00
Emi Zhang-MSFT 24,986 Reputation points Microsoft Vendor
2 answers

How to extract duplicate personnel from column B to column C using a formula in Excel?

How to extract duplicate personnel from column B to column C using a formula in Excel?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
asked 2024-09-30T15:30:03.9066667+00:00
pu rechard 100 Reputation points
answered 2024-10-01T06:48:58.15+00:00
Emi Zhang-MSFT 24,986 Reputation points Microsoft Vendor