1,661 questions with Excel Management tags

Sort by: Updated
Updated Created Answers
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,599 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,958 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,661 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.
440 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 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,252 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,661 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,661 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,554 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,661 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,661 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 22,636 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,554 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,599 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,661 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,406 Reputation points Microsoft Vendor
1 answer

Why are my Ctrl - and Ctrl + shortcuts (delete and insert cells) not behaving properly

I have multiple versions of the same file. I thought that the latest ones got corrupt at some point and Ctrl - wasn't working. All it did was delete the cell contents instead of deleting the cells. So i started testing for the latest non corrupt file and…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 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,661 questions
asked 2024-05-20T06:00:19.39+00:00
Abhinav Jain 5 Reputation points
commented 2024-05-23T04:49:55.31+00:00
Abhinav Jain 5 Reputation points
0 answers

Programmatically read restricted excel file

I have a series of Excel's that are protected by the business. I have the required permissions to view the file manually however I would like to create a programmatic way to extract the data from these excels. I have tried using Python to read and…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 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,599 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,661 questions
asked 2024-04-05T11:44:17.3133333+00:00
Rando 5 Reputation points
commented 2024-05-22T15:18:53.94+00:00
DANIEL COHEN 0 Reputation points
1 answer

Files that are encrypted through the sensitivity label.

Hello    Please i need your help on this issue.    The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files   I've opened the Excel file on my MAC that is in my downloads folder. This issue looks to be on all files…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 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,661 questions
asked 2024-05-16T18:58:07.4566667+00:00
Iniobong Nkanga 1,686 Reputation points
commented 2024-05-22T08:31:07.1366667+00:00
Jiajing Hua-MFST 6,260 Reputation points Microsoft Vendor
0 answers

How can I get the status of calculation request when using Workbook /calculate endpoint?

I am using the Microsoft Graph API endpoint /calculate for workbook recalculation, but it does not provide a way to poll for the status of the calculation asynchronously. After making a POST request to this endpoint, it initiates the calculation process…

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,911 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,913 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,599 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,661 questions
asked 2024-05-21T08:36:06.9+00:00
Sankalp 0 Reputation points
edited the question 2024-05-22T08:18:56.05+00:00
Jiajing Hua-MFST 6,260 Reputation points Microsoft Vendor
22 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,661 questions
asked 2020-07-27T18:53:59.793+00:00
Asha Kanta Sharma 91 Reputation points
commented 2024-05-21T16:17:32.6933333+00:00
Steve Lipsman 30 Reputation points
0 answers

Excel 16.85 is having permission issues

Hello  Please i need your help on this issue.  The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files I am able to open the file while on 16.84 then when I update to the latest update 16.85 I would get the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 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,661 questions
asked 2024-05-20T20:32:55.65+00:00
IBN 0 Reputation points
commented 2024-05-21T08:15:06.4633333+00:00
Emi Zhang-MSFT 22,636 Reputation points Microsoft Vendor
0 answers

Interop.Excel always saving in default path even specifying the path manually for Office 365

Trying to create an Excel file using Office.Interop.dll (15.0.4795.1001).But it is taking the default file path instead of the path which set manually. if (extensionObj != null) { relativeExcelPath =…

C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,420 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,599 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,661 questions
asked 2024-05-20T11:08:56.84+00:00
Venkatachalam S1 0 Reputation points
1 answer

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,368 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 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,599 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,028 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,661 questions
asked 2024-05-17T09:55:50.3666667+00:00
gh X 30 Reputation points
answered 2024-05-20T05:52:48.8033333+00:00
Jiajing Hua-MFST 6,260 Reputation points Microsoft Vendor
3 answers

Excel cells maximum sum

Good evening to all, In excel in cells F8:F9 we have the numbers 17 and 11 respectively (sum 28), in cells M8:M9 we have the numbers 14 and 9 respectively (sum 23) and in cells T8:T9 we have the numbers 17 and 14 respectively (sum 31). I am looking for…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 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,661 questions
asked 2024-05-08T21:45:29.8733333+00:00
Νικόλαος Γιαννέλος 0 Reputation points
commented 2024-05-17T07:18:53.6366667+00:00
Jiajing Hua-MFST 6,260 Reputation points Microsoft Vendor
1 answer

New version of excel is having permission issues with opening some files

Hello    Please i need help on this issue.   The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files. Had to roll back to the older 16.84 version for it to work.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 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,661 questions
asked 2024-05-15T16:58:34.16+00:00
IniobongNkanga-8038 266 Reputation points
commented 2024-05-16T18:04:13.4433333+00:00
IniobongNkanga-8038 266 Reputation points
4 answers One of the answers was accepted by the question author.

Can not type into cells of excel file embeded from OneDrive

Dear Team,I have generate embeded code that allow to type into cells. I see it OK in the PREVIEW mode. (Preview mode included in customizing embed code Screen) The image as…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
879 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,913 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,154 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,661 questions
asked 2024-03-21T02:29:06.85+00:00
Premium Premium 35 Reputation points
edited an answer 2024-05-16T06:18:51.06+00:00
King Chan 0 Reputation points
0 answers

Microsoft Report Builder Creating Blank Column

Hello, I have a report I am editing in Microsoft Report Builder. This is for Epicor... When I tell Epicor to view the report in Excel, it comes up with a blank column in between A and C. So no matter how I rearrange, column B is just blank. But when 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,661 questions
asked 2024-05-14T16:21:25.26+00:00
Michele Pelley 0 Reputation points
1 answer

Cannot read excel file which is in using adls using load_workbook of openpyxl in databricks

Cannot read excel file which is in using load_workbook of openpyxl but can read if copied to dbfs

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,380 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,509 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,985 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,805 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,661 questions
asked 2024-05-10T10:34:09.57+00:00
Alpha 20 Reputation points
commented 2024-05-13T10:00:28.6666667+00:00
phemanth 6,885 Reputation points Microsoft Vendor
1 answer

Highlight blank cell in excel post fixed date

Blank cell to be highlighted post certain dates. For example: Cell B3 is blank which needs to be highlighted after 10-May-24. Pls note, B3 cell will remain blank till due date and numeric data supposed to be filled before 10-May-2024

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 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,661 questions
asked 2024-05-04T12:27:28.4033333+00:00
Jayesh Gangawane 0 Reputation points
commented 2024-05-10T07:05:22.9866667+00:00
Emi Zhang-MSFT 22,636 Reputation points Microsoft Vendor