Microsoft Q&A

Excel Management

1,348 questions

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.

Browse all Office tags

1,348 questions with Excel Management tags

Sort by: Updated
1 answer

Indirect Formula - (Excel Online Version)

Hello, I'm trying to add an indirect excel formula in an online excel file. I need to link the indirect formula to other external online excel files. Basically, we have individual files by location that track performance. I'm creating a new…

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,348 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
84 questions
asked 2023-02-07T19:44:34.17+00:00
King Java 95 Reputation points
answered 2023-02-08T03:21:37.62+00:00
Aido 0 Reputation points
2 answers

How to send only one email using Power Automate based on a condition in different rows in Sharepoint Excel?

I am trying to send just one email to a particular user in Power Automate, where the program runs through all the rows in an Excel file, and based on a condition, adds the particular rows to a table, which it then sends to the user altogether. So far, I…

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,348 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
6,079 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
116 questions
asked 2023-01-18T21:37:28.2133333+00:00
KLOSINSKI Antoine-EXT 0 Reputation points
commented 2023-02-08T01:48:01.57+00:00
Yi Lu_MSFT 16,751 Reputation points Microsoft Employee
0 answers

Excelfiles seems corrupt when upploaded to storage container in Blob

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,348 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
1,420 questions
asked 2023-02-03T11:01:23.45+00:00
Erik Arwinge 0 Reputation points
commented 2023-02-07T22:58:22.6233333+00:00
SaiKishor-MSFT 15,096 Reputation points Microsoft Employee
7 answers

Microsoft should FIX - "Errors were detected while saving (filename)"

Microsoft must FIX this decade long bug with appears out of nowhere and has ruined a lot of months of work of my life. Please fix the below error message. It is even appearing in latest Office 2019. "Errors were detected while saving (filename).…

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,348 questions
asked 2020-07-27T18:53:59.793+00:00
Asha Kanta Sharma 6 Reputation points
commented 2023-02-07T14:56:04.3666667+00:00
Blitzer 0 Reputation points
1 answer

MS edge > Excel not running > error(Unsupported browser)

Windows 10 Microsoft Edge 109.0.1518.78 지원되지 않는 브라우저 Office는 최신 브라우저 기술을 사용하며 최신 브라우저에서 최적의 성능을 나타냅니다. 브라우저를 업그레이드하세요. Unsupported browser Office uses the latest browser technology and performs best in modern browsers. Upgrade your browser. This issue…

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,348 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
84 questions
asked 2023-02-06T02:52:17.06+00:00
김광수 0 Reputation points
commented 2023-02-07T10:28:04.8+00:00
Emi Zhang-MSFT 10,711 Reputation points Microsoft Employee
1 answer

Open macro provide an odd error message

Upon opening error message: Compile error: Expected End Sub I am definitely at a loss. Below is the code. This code works fine outside the open macro. Private Sub Workbook_Open() Sub UnProtectAllSheets() Dim ws As Worksheet For Each ws In…

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,348 questions
asked 2023-02-01T19:01:57.29+00:00
Rick Tidd 16 Reputation points
commented 2023-02-07T10:22:19.6333333+00:00
Emi Zhang-MSFT 10,711 Reputation points Microsoft Employee
2 answers

2D Map Chart

I am using Office LTSC Pro Plus 2021 x64 Multilingual, installed a Week ago Issue: Data tab > Data Types > Geography is not available in MSEXCEL and I am unable to create city name wise 2D Map chart, currently its only Province Or State Or Country…

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,348 questions
asked 2023-01-31T19:06:40.88+00:00
Zeeshan Haider 0 Reputation points
commented 2023-02-07T08:50:40.43+00:00
Emily Hua-MSFT 22,201 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

some message get garbled after adding disclaimer to a message

Dear experts, After I added an external message disclaimer via transport rule, some of our external message get garbled. I have confirmed that it's called by the disclaimer because when I disable the rule, everything is OK. below are the disclaimer and…

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,348 questions
Exchange Server
Exchange Server
A family of Microsoft client/server messaging and collaboration software.
78 questions
asked 2023-02-01T09:44:02.2366667+00:00
xhope 181 Reputation points
accepted 2023-02-07T08:12:57.5233333+00:00
xhope 181 Reputation points
0 answers

Need some help with my office script code

Hi, I need my code to run only in AC5:AC column but it runs in every cell, not sure what the problem is, where's my code: function main(workbook: ExcelScript.Workbook) { // Get the specific sheet in the workbook. let sheet: ExcelScript.Worksheet =…

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.
1,980 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,348 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
450 questions
Microsoft Graph Permissions API
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
1,708 questions
asked 2023-02-05T02:16:46.2866667+00:00
Sand Man 0 Reputation points
commented 2023-02-06T19:53:49.48+00:00
Tiaan 651 Reputation points
5 answers

Importing excel workbook data into MS Project isn't working

Hi When I try to import excel data into MS Project, I have to select the tab name (which I haven't had to do before if there is only one active tab), but when I try and select the data - nothing is showing. I have cleared all formatting from the…

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.
1,980 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,348 questions
asked 2022-08-17T14:31:39.707+00:00
Tereza Murphy 1 Reputation point
answered 2023-02-06T18:42:16.4733333+00:00
Michal Blazejczyk 0 Reputation points
1 answer One of the answers was accepted by the question author.

TEXT formula

Mark 1, 2, 3, 4 and so on for every 10000 accumulated customer amounts in column D, and the results are listed in column E

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,348 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
84 questions
asked 2023-01-31T13:20:58.6066667+00:00
BABY_JOJO 81 Reputation points
accepted 2023-02-06T14:37:00.9666667+00:00
BABY_JOJO 81 Reputation points
1 answer One of the answers was accepted by the question author.

Multi-conditional search returns non-duplicate values

Returns the non-repeating value of column A according to the date and name

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,348 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
84 questions
asked 2023-01-31T13:30:49.5366667+00:00
BABY_JOJO 81 Reputation points
accepted 2023-02-06T14:36:15.7366667+00:00
BABY_JOJO 81 Reputation points
5 answers

SharePoint file is downloaded instead when opened in Desktop App

Hello! I have a company laptop and we have Microsoft 365 licenses. In my previous company laptop, whenever I open a file in SharePoint, it opens in browser and then if I want it opened in Desktop app, I just click Editing > Open in Desktop App and…

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,348 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
6,079 questions
asked 2023-01-04T00:59:00.88+00:00
newgirl326 1 Reputation point
commented 2023-02-06T10:17:22.53+00:00
Yanli Jiang - MSFT 6,126 Reputation points Microsoft Employee
0 answers

Excel: Exporting Show Changes Log

Hello all, it was suggested by a Microsoft Community Mod that I ask this here: I have a SharePoint-stored Excel file that is used by my team to store which local restaurants are open on any given day, where the rows are the restaurants and the columns…

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,348 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.
1,980 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
6,079 questions
asked 2023-02-03T18:17:39.9466667+00:00
Dillon Hause 0 Reputation points
edited the question 2023-02-06T07:53:08.2033333+00:00
Haoyan Xue_MSFT 5,416 Reputation points Microsoft Employee
1 answer

How to fix excel student account credential?

Hi Unfortunately, I just disabled my student credential for excel. From managing device options I disabled it. Please help me with this. How can I fix this issue?

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.
1,980 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,348 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
84 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
87 questions
asked 2023-01-19T07:04:53.72+00:00
Yeasin Arafat 0 Reputation points
edited the question 2023-02-06T07:38:48.8866667+00:00
Jayce Yang-MSFT 161 Reputation points Microsoft Employee
13 answers

Excel: How can I add "Last Modified" to Excel

Excel: How can I add "Last Modified date" in a cell on an Excel spreadsheet every time I save it? Office 2019

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.
1,980 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,348 questions
asked 2021-11-02T13:44:49.91+00:00
Terry Seagert 81 Reputation points
answered 2023-02-04T16:48:31.8066667+00:00
Terry Seagert 106 Reputation points
3 answers

Is there a difference in Excel 2007 and Excel 365 with respect to Visual Basic Macros?

I have a spreadsheet with Macros that was created in excel 2007. It will not run correctly on my machine with Excel 365.

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,348 questions
asked 2020-08-20T19:17:29.49+00:00
Hogan, Edward 1 Reputation point
answered 2023-02-04T01:26:15.5733333+00:00
Ken Burns 0 Reputation points
4 answers

I don't see the Automate tab in the Office Excel.

I need an Automate tab to use macros in Excel. But I don't see it. I can't even see the option Please help me. ]1

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,348 questions
asked 2022-04-06T00:19:06.083+00:00
설서진 1 Reputation point
answered 2023-02-04T01:24:17.4933333+00:00
Ken Burns 0 Reputation points
2 answers

PivotTable in Excel

Hi All, I'm using a tabular model in Excel, everytime i add a filter, row or column in the PivotTable, the excel tries to execute the query to refresh data. Since our tabular model is full of data and dax, it takes time every time the excel refresh…

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,348 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,007 questions
asked 2021-05-03T21:26:19.957+00:00
Samir abdelmalek 21 Reputation points
answered 2023-02-04T01:03:24.8+00:00
Ken Burns 0 Reputation points
5 answers

merge excel files

How to merge several Excel file into one worksheet in Excel?

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,348 questions
asked 2021-04-23T11:50:20.727+00:00
Patrick Wu 1 Reputation point
answered 2023-02-03T23:57:32.5333333+00:00
Ken Burns 0 Reputation points