1,689 questions with Excel Management tags

Sort by: Updated
Updated Created Answers
1 answer

I dont see automatization card in excel

private pc

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,689 questions
asked 2024-06-06T10:41:18.78+00:00
Kateřina Baťková 0 Reputation points
commented 2024-06-27T06:59:50.8966667+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
1 answer

using conditional sumproduct, trabspose

Hi I have a huge data base and need to sort and filter some results I need to calculate " The labour" working hours in multiple tables of ONE SHEET, as…

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,689 questions
asked 2024-06-17T06:05:40.3166667+00:00
David Polsangi 0 Reputation points
commented 2024-06-27T06:39:54.5933333+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
1 answer

Office Client - Excel

Hello    Please i need your help on this issue.   A number of problems browser clocking with certain programs/data refresh is not working in excel and trying to attach file in email. We are getting error message "download failed path doesn't…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,459 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 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,689 questions
asked 2024-06-26T16:37:09.0333333+00:00
IniobongNkanga-8038 296 Reputation points
commented 2024-06-27T05:40:37.08+00:00
Emi Zhang-MSFT 23,736 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How do I write an excel formula to count the number of times a result occurs in a column for each user (user name in another column of same data set)?

Data Sources: Summary data table which contains a column for employee name and a column for each type of occurrences we want to track, e.g. wrong status or past due date Detail data is on another tab and contains a column with employee name as well as…

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,689 questions
asked 2024-06-24T18:16:05.14+00:00
Rosie, Nina 20 Reputation points
commented 2024-06-25T18:47:18.1666667+00:00
Rosie, Nina 20 Reputation points
1 answer

Unable to correctly print all tabs/files from Excel that was shared document

I have a user who has access to a shared SharePoint site and user downloaded an excel file on his pc locally. User then attempts to copy and paste 4 certain tabs from the excel file to a new excel file removing any hyperlinks and any attachments. The…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 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,689 questions
asked 2024-06-24T20:16:23.56+00:00
MOIZ ARSHAD 40 Reputation points
answered 2024-06-25T02:38:00.76+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
1 answer

How to embed a video in an Excel Userform?

I want to be able to insert a video into a frame in an excel user form.

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,709 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,689 questions
asked 2024-06-23T15:33:46.4+00:00
Alden Kollman 0 Reputation points
answered 2024-06-24T07:13:14.9166667+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
1 answer

Microsoft Onedrive for Business

I am experiencing an issue with a Microsoft Excel file stored on SharePoint. When I open this file, the AutoSave feature automatically saves it to my local OneDrive account instead of the shared SharePoint drive. This is causing confusion and…

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,249 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.
1,194 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,689 questions
asked 2024-06-05T12:38:25.0066667+00:00
TCStevie 40 Reputation points
commented 2024-06-21T07:12:43.85+00:00
Ling Zhou_MSFT 15,320 Reputation points Microsoft Vendor
1 answer

Excel 1900 leap year bug

I think that Excel's 1900-02-29 bug should be fixed. Over the years, many other users have complained about this. To prevent any disruption, "Thu, 1900-03-01" should retain its "day 61" serial number, so that all later dates…

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,689 questions
asked 2021-05-31T17:13:09.773+00:00
Paul Margus 6 Reputation points
commented 2024-06-19T22:14:15.6433333+00:00
isidro co 0 Reputation points
2 answers

Excel, percentages in conditional formatting

I have multiple columns with complex conditional format data in excel. For example, if people attend a recent course they go green, if training is out of date they turn red. I want to be able to create a constant updating percentage of the number who…

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,689 questions
asked 2024-06-17T09:33:18.45+00:00
Ruth Gill 0 Reputation points
answered 2024-06-18T02:20:53.0133333+00:00
Emi Zhang-MSFT 23,736 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

In excel, it is very hard to find the mouse stays in that cell, how to solve it?

In excel, the cell where the mouse is located will be identified with a thin black box, please, is there any way to modify the color and line thickness of this thin black box, so that the user can easily identify the mouse to stay in that cell?   Thank…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,459 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 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,709 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,062 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,689 questions
asked 2024-05-17T09:55:50.3666667+00:00
gh X 50 Reputation points
accepted 2024-06-17T17:18:22.45+00:00
gh X 50 Reputation points
2 answers

Errors were detected while saving excel file how I should save it

Errors were detected while saving excel sheet how I should save it.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 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,689 questions
asked 2024-06-13T08:27:51.8333333+00:00
amer mohammed 0 Reputation points
answered 2024-06-14T06:35:22.7033333+00:00
Emi Zhang-MSFT 23,736 Reputation points Microsoft Vendor
2 answers

Datestamps in Excel when a cell value changes

I've already looked up adding datestamps in Excel. Not a problem. I already have a table with data in it. I don't want to display the current date if there is already data in the cell. I only want the datestamp to update when the other cell value…

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,689 questions
asked 2022-12-20T17:21:58.08+00:00
Daniel Checkman 6 Reputation points
edited a comment 2024-06-11T20:31:55.29+00:00
Donut_Disturbance 0 Reputation points
1 answer

My admin-managed Excel Office.js add-in is not appearing on iPad

Hi there, I've developed an Office.js excel add-in which has recently been deployed by my organisation through Integrated Apps. The add-in works perfectly on MacOS and through the browser, but I would like to use it on iPad. The 'admin-managed' add-in…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 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,709 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,062 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,689 questions
asked 2024-06-09T08:51:27.98+00:00
Freja Tara 0 Reputation points
answered 2024-06-10T03:01:59.96+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
1 answer

How to add Analyze data if already add

Hello, I already add-ins Analysis ToolPak and Analysis ToolPak - VBA but The Analysis Data tool does not appear on my Home. My Excel is Version 2405. How & What should I do? Please Help Me !!!

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 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,689 questions
asked 2024-06-05T14:40:32.4233333+00:00
Sofia 0 Reputation points
answered 2024-06-06T01:58:48.75+00:00
Emi Zhang-MSFT 23,736 Reputation points Microsoft Vendor
2 answers

Microsoft Excel Application missing in DCOMCNFG for Excel 365

Just upgraded from Excel 2016 to Excel 365 and now Microsoft Excel Application is missing in DCOMCNFG so I can't configure the security setting for my old ASP code to work. I tried editing the setting for My Computer in Component Services but that…

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,689 questions
asked 2021-12-17T17:04:14.383+00:00
NeilNYG 1 Reputation point
commented 2024-06-05T17:29:36.9366667+00:00
Pablo Harguindey 0 Reputation points
1 answer

How do I create an excel file for csv export

How do I create an excel file so that it can be converted to a csv file to be exported into quickbooks online

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,459 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 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,689 questions
asked 2024-06-03T19:04:49.7833333+00:00
Mills Judy E 0 Reputation points
answered 2024-06-03T19:09:00.55+00:00
Olaf Helper 43,161 Reputation points
2 answers One of the answers was accepted by the question author.

How to insert a new reference in an excel projet

Good morning, I have a Ms Access project that creates a new Ms Excel project and inserts data into a sheet. I need to insert a new reference in the created Excel project. I want to insert a reference to Ms Access to be able to invoke a Ms Access form.…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
854 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,689 questions
asked 2024-06-02T15:13:41.3166667+00:00
Marco Dell'Oca 161 Reputation points
accepted 2024-06-03T16:25:22.3066667+00:00
Marco Dell'Oca 161 Reputation points
3 answers

Excel file with view permission won't open in desktop app got you don't have permission to open this file

Hi team, We granted a user view permission to an excel file. The user can open the Excel file from the web but encounters a "You don't have permission to open this file" error when trying to open it from the desktop app. Thank you for your help

Microsoft Exchange Online
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 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,689 questions
asked 2023-10-16T18:53:34.3966667+00:00
J-3804 1,566 Reputation points
edited an answer 2024-06-03T04:10:49.06+00:00
Sal 0 Reputation points
1 answer

How to fix a ActiveX cannot create a object error Outlook automation from Excel vba.

I have Office profesional plus 2021 64bit and Windows 10 64bit. I receive this error: Error 429: ActiveX component cannot create object I have a Excel Macro that prepare a customized email according to several data in a worksheet. This used to work, but…

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,709 questions
Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
5,064 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,689 questions
asked 2024-05-27T15:24:15.78+00:00
Antonio Garrido 0 Reputation points
answered 2024-05-30T01:27:21.0433333+00:00
Antonio Garrido 0 Reputation points
1 answer One of the answers was accepted by the question author.

Get Formula Text of a Cell on Another Sheet in Excel 2010

=FORMULATEXT only works in Excel 2013 and after. Is there a way to do that in Excel 2010? Thanks

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,689 questions
asked 2021-09-04T23:03:50.327+00:00
Ian3 66 Reputation points
commented 2024-05-25T21:13:44.88+00:00
Kim Wilson 0 Reputation points