1,671 questions with Excel Management tags

Sort by: Updated
Updated Created Answers
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,671 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,031 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,400 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 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,652 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,045 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,671 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
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,671 questions
asked 2024-06-17T06:05:40.3166667+00:00
David Polsangi 0 Reputation points
answered 2024-06-17T08:17:35.0833333+00:00
Jiajing Hua-MFST 6,745 Reputation points Microsoft Vendor
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,615 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,671 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,031 Reputation points Microsoft Vendor
2 answers

How to renew Microsoft 365 Developer licence

I had subscribed to the Microsoft 365 Developer Program, but my subscription has expired and was not renewed. I am seeking assistance to resubscribe to the program

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,121 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 questions
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.
2,967 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,671 questions
asked 2024-06-11T11:04:59.1266667+00:00
Hamxa Khan 0 Reputation points
commented 2024-06-14T01:44:48.4433333+00:00
Jiajing Hua-MFST 6,745 Reputation points Microsoft Vendor
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,671 questions
asked 2024-06-06T10:41:18.78+00:00
Kateřina Baťková 0 Reputation points
commented 2024-06-14T01:34:03.5466667+00:00
Jiajing Hua-MFST 6,745 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,047 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,170 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,671 questions
asked 2024-06-05T12:38:25.0066667+00:00
TCStevie 40 Reputation points
commented 2024-06-13T08:58:09.64+00:00
Yanli Jiang - MSFT 22,811 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,671 questions
asked 2022-12-20T17:21:58.08+00:00
Daniel Checkman 1 Reputation point
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,615 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,652 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,045 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,671 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 6,745 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,615 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,671 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,031 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,671 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,400 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 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,671 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 42,561 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.
845 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,671 questions
asked 2024-06-02T15:13:41.3166667+00:00
Marco Dell'Oca 141 Reputation points
accepted 2024-06-03T16:25:22.3066667+00:00
Marco Dell'Oca 141 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,615 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,671 questions
asked 2023-10-16T18:53:34.3966667+00:00
J-3804 1,561 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,652 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.
4,996 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,671 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
2 answers

"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."

One of the users receive this error. is this issue at our end or at microsofts ?

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 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,256 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,671 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 0 Reputation points
answered 2024-05-28T13:30:39.0233333+00:00
Gabriel Roldan 25 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,671 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
1 answer

How to Default name of the user who signed in to an Excel field

Hi, I want to default name of the user who Signed in to an excel field and make it non editable. If user not signed in, prompt as 'Please Sign In'. Please advice how to do it. Regards, Sudheer.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 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,671 questions
asked 2024-05-23T15:42:16.9966667+00:00
Sudheer 0 Reputation points
commented 2024-05-24T13:13:52.4566667+00:00
Sudheer 0 Reputation points
1 answer

how to enable macro of excel worksheet received via email

How to make an excel file a trusted document so that I can enable the marcos?

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,671 questions
asked 2024-05-24T04:35:27.37+00:00
Ricky Chung 0 Reputation points
answered 2024-05-24T08:34:03.58+00:00
Emi Zhang-MSFT 23,031 Reputation points Microsoft Vendor
1 answer

Resize table using VBA

Hello, I currently use the following code in order to copy data to another worksheet. However, when I eliminate rows on the original worksheet, the range of the table for the second worksheet remains the same when I run the macro. I was wondering if…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 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,652 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,671 questions
asked 2024-05-23T17:14:23.4833333+00:00
DavidG 0 Reputation points
edited the question 2024-05-24T01:08:18.03+00:00
Jiachen Li-MSFT 27,666 Reputation points Microsoft Vendor