Microsoft Q&A

Excel Management

1,333 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,333 questions with Excel Management tags

Sort by: Updated
Updated Created Answers
1 answer

Prompt to enable Macro's isn't consistent Office 2019 - Excel

Hello, I was wondering if anyone would be able to provide some insight on why it seems the prompt to enable macro's on Excel behaves very inconsistently. Our CRM system gives files the 'Mark of the Web' so following the recent changes…

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,333 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
52 questions
asked 2023-01-17T10:48:37.31+00:00
Connor Smith 0 Reputation points
commented 2023-01-27T05:43:07.8933333+00:00
Emily Hua-MSFT 21,526 Reputation points Microsoft Employee
2 answers

Office 365 Apps Functions Limited On A Mac

I have an Office 365 subscription, and have for several years. I use the apps in my business. My primary computer systems are Mac computers. For years the Office apps have worked just fine on my MAc computers, but now I am getting a warning message when…

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,333 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
299 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.
780 questions
asked 2023-01-26T20:07:45.79+00:00
R Allan Jensen 0 Reputation points
answered 2023-01-27T05:29:23.36+00:00
Emily Hua-MSFT 21,526 Reputation points Microsoft Employee
1 answer

Best courses to become certified in Excel and PowerPoint

I would like to become certified in excel, What is the best option in doin this? Thank you

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,333 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
52 questions
asked 2023-01-26T16:37:14.55+00:00
KristieS 0 Reputation points
answered 2023-01-26T17:32:35.83+00:00
Dillon Silzer 33,226 Reputation points
5 answers

number format in excel sheet

Hi Expert how to change datatype in pivot table in excel sheets . from text to numbers currently value is in text as it is in column section i,e. id value 1 23

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,333 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
52 questions
asked 2023-01-19T10:52:23.3133333+00:00
Shambhu Rai 646 Reputation points
commented 2023-01-26T16:33:01.49+00:00
Shambhu Rai 646 Reputation points
3 answers

Question about Dynamics Business Central & Excel

Hi- I am a beginner using Microsoft products and have been at my job 5 months. My boss gave me a new task which is to... using a an Excel master file we have which list every inventory item we have and the cost and pricing etc. All anyone know to do is…

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,333 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
52 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.
1,563 questions
asked 2023-01-11T21:41:38.91+00:00
Melissa Obrien 0 Reputation points
answered 2023-01-26T16:31:20.4733333+00:00
Melissa Obrien 0 Reputation points
1 answer One of the answers was accepted by the question author.

Threaded comment support by Office professional version of Excel

Is threaded comment supported by Office professional Plus 2021 version of Excel? When I tried to edit the comments by it that are edited by Office Home and Business 2021 or Microsoft 365 enterprise version of Excel, every single comment shows an error…

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,333 questions
asked 2023-01-14T07:39:16.0766667+00:00
Atsushi Ando 20 Reputation points
accepted 2023-01-26T00:02:18.9266667+00:00
Atsushi Ando 20 Reputation points
2 answers

ADF Copy Activity fail when loading Excel file which size is more than 40 MB

I have a requirement where I am using ADF copy activity processing large-size excel files ( includes more than 30 columns, file size around 80-10MBs ) which meets "Out of Memory" error intermittently. I cannot get the solution to 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,333 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,253 questions
asked 2023-01-20T08:42:21.6033333+00:00
Vipinkumar Jha 0 Reputation points
commented 2023-01-25T20:19:30.1433333+00:00
MartinJaffer-MSFT 23,926 Reputation points Microsoft Employee
4 answers

Import data from Web using login details

How do I import data from Web in excel using login details. It does not allow me to enter my login credentials. If anyone could provide me with steps that would be highly appreciated. Thanks Pasang

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,333 questions
asked 2021-04-16T04:55:30.087+00:00
pasang kaji sherpa 1 Reputation point
commented 2023-01-25T19:27:53.0966667+00:00
Mary Jane Caniette 0 Reputation points
1 answer One of the answers was accepted by the question author.

how to wright a function in VBA to calculate total minutes worked in a specific hour.

How to wright a function in VBA to calculate total minutes worked in a specific hour. I need to calculate total time worked in each hour in a spreadsheet and i am open for any ideas. I not sure if a function is the best route to go. I like to…

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,333 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.
1,563 questions
asked 2022-10-20T02:13:44.74+00:00
Petar Novakovic 21 Reputation points
accepted 2023-01-25T16:09:42.9833333+00:00
Petar Novakovic 21 Reputation points
2 answers

How can I modify this pivot table to show the desired data?

I am creating a pivot table where the row is the reason code, the column the month/year, and the values Distinct Count of Production Number. There are moments where a production number is found in reason code 4 and 22 or in 5 and 26. Regardless, how can…

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,931 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,333 questions
asked 2023-01-04T00:01:12.593+00:00
Lopez, Ahiezer 191 Reputation points
commented 2023-01-25T14:56:06.67+00:00
Herbert Seidenberg 1,106 Reputation points
1 answer

SUMIFs from the Employee Attendance Record Template

From the Employee Attendance Template I downloaded for Excel, I have the following cells in the Calendar View Sheet: The cell "Days on Leave" show the following formula: =SUMIFS(LeaveTracker[Days],LeaveTracker[Employee…

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,333 questions
asked 2022-05-02T02:05:46.42+00:00
Joe Knowes 6 Reputation points
answered 2023-01-24T23:20:21.0833333+00:00
Nichole Jones 0 Reputation points
1 answer

office 365 - outlook now opening excel attachments as read only

we have office 365, and suddenly today, I am seeing lots of people complaining that when they receive an excel spreadsheet via email, it is always opening in Read Only mode. I have tried in Excel going to Trust Center and unchecking everything under…

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,333 questions
Microsoft Exchange Online Management
Microsoft Exchange Online Management
Microsoft Exchange Online: A Microsoft email and calendaring hosted service.Management: The act or process of organizing, handling, directing or controlling something.
2,879 questions
asked 2023-01-04T16:00:47.517+00:00
Captain Kirk 121 Reputation points
edited the question 2023-01-24T09:09:10.1666667+00:00
Crystal-MSFT 19,331 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?

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,333 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
52 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,931 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
54 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
5,268 questions
asked 2023-01-19T07:04:53.72+00:00
Yeasin Arafat 0 Reputation points
commented 2023-01-23T09:20:01.3233333+00:00
Emily Hua-MSFT 21,526 Reputation points Microsoft Employee
2 answers

Power Pivot doesn't connect all tables

Hi, I cant get my tables to connect in power pivot. I have SQL and ODBC databases loaded in pv and connected them all to make some pivot tables. Everything works accept adding a relation with the ODBC table. I want this to connect to a column but it…

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,333 questions
asked 2023-01-20T09:57:02.63+00:00
patrick kroezen 0 Reputation points
answered 2023-01-23T09:01:37.87+00:00
Emily Hua-MSFT 21,526 Reputation points Microsoft Employee
2 answers

Excel macros not working with the two recipients, all three users sharing utilizing OneDrive and Microsoft 365..?

Excel macros not working with the two recipients, all three users sharing utilizing OneDrive and Microsoft 365… I share several Excel files with two other individuals through OneDrive utilizing Office 365. Myself and the other two individuals use…

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,333 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
52 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
32 questions
OneDrive Management
OneDrive Management
OneDrive: A Microsoft file hosting and synchronization service.Management: The act or process of organizing, handling, directing or controlling something.
801 questions
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.
108 questions
asked 2023-01-19T14:57:21.95+00:00
Lloyd Johnson 0 Reputation points
answered 2023-01-20T11:48:03.69+00:00
Oskar Shon 786 Reputation points Microsoft MVP
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,333 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
52 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
5,971 questions
asked 2023-01-18T21:37:28.2133333+00:00
KLOSINSKI Antoine-EXT 0 Reputation points
commented 2023-01-20T07:50:53.5066667+00:00
Tong Zhang_MSFT 8,706 Reputation points Microsoft Employee
1 answer

Can't interact with Excel because of hidden dialog box.

Hidden dialog box keeps Excel from operating properly. I've tried alt-tabbing the dialog does not show up. When I try to shut Excel down using the task manager since close it normaly I get a dialog box stating "You cannot close Microsft Exel…

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,333 questions
asked 2023-01-15T16:07:05.61+00:00
John Wilk 0 Reputation points
commented 2023-01-20T07:18:11.39+00:00
Emily Hua-MSFT 21,526 Reputation points Microsoft Employee
1 answer

Have Recon with only 2 columns but might have several rows on other to match, how can I find Matches?

Have a general Ledger account debit / credit but sometimes/most it several credits to match one debit, i have been doing by adding subtracting and takes a long long time. Plus they don't really have a unique name that would match the debit to credits,…

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,333 questions
asked 2023-01-14T18:58:32.0333333+00:00
J806 0 Reputation points
commented 2023-01-20T07:17:14.0166667+00:00
Emily Hua-MSFT 21,526 Reputation points Microsoft Employee
2 answers

How do I change the default font for notes in Excel?

The default font for a New Note in Excel is 'Bold' and I want to set the default to 'Regular'.

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,333 questions
asked 2020-11-09T04:22:31.007+00:00
Anonymous
answered 2023-01-19T06:32:31.74+00:00
Elardus Mare 0 Reputation points
2 answers

Excel solvertable error

Every time I am running solvertable in Excel, I got a message: Error number 13 Type mismatch Does anyone knows how to fix it?

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,333 questions
asked 2021-12-17T08:42:08.49+00:00
Alexey11226 1 Reputation point
commented 2023-01-19T05:50:52.5166667+00:00
Mancero Villareal, Julio C 0 Reputation points