1,776 questions with Excel Management tags

Sort by: Updated
Updated Created Answers
1 answer

How to Fix Previously Working Macros in Excel that are Now Blocked/Not Loading

(Note: I was directed here from MS Support) I have several excel files that I use in daily work that have macros in them, executed via buttons. While working with one of these files, the macros stopped working. These files are important enough that 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,776 questions
asked 2025-02-27T19:08:45.73+00:00
SRENV 0 Reputation points
edited an answer 2025-02-28T05:57:20.45+00:00
Jiajing Hua-MFST 15,285 Reputation points Microsoft Vendor
2 answers

Excel formula

Put different numbers from two rows on the third row. Any suggestion is appreciated, 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,776 questions
asked 2025-02-27T13:10:01.6933333+00:00
Jamey Luv 40 Reputation points
commented 2025-02-28T05:26:05.4566667+00:00
Barry Schwarz 3,576 Reputation points
1 answer

How can I automatically format a range as a table and apply conditional formatting in Excel using VBA?

I write content for a site where I often have to create tables. I create tables from Google Docs, but the tables are not good. However, I have problems creating tables in Google Docs. But I use Microsoft Excel to create tables well. But I can't easily…

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,776 questions
asked 2025-02-28T03:18:23.5133333+00:00
Tech it 0 Reputation points
answered 2025-02-28T05:24:49.8533333+00:00
Barry Schwarz 3,576 Reputation points
1 answer

I am not able to open Excel documents in 'protected mode' why? What do I have to do?

Up to 2 weeks ago, I was always able to open Excel documents that were protected (read only). I turned my computer off while I was away and now I am not able to open them. What should I do to open them? 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,776 questions
asked 2025-02-27T11:02:46.4733333+00:00
Suzanne et Didier Fradet-Wood 0 Reputation points
answered 2025-02-27T12:17:52.53+00:00
Suzanne et Didier Fradet-Wood 0 Reputation points
0 answers

Excel Instance crashes if a user logs in to the server (Office 2019).

Hello,        I am facing an issue with our .NET application that generates reports in multiple formats such as Word, Excel, PowerPoint, etc.., in this process it opens the excel instances and does few operations to add data and closes them. The…

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,776 questions
asked 2025-02-27T09:14:09.1133333+00:00
Srikar_K 0 Reputation points
1 answer

Require license for Excel 2024 SLng LTSC

I have purchased Excel 2024 SLng LTSC product and downloaded the Microsoft office LTSC standard 2024 from microsoft office site . I have Agreement number, Purchase order number, public customer number but does not have License key or product key. How can…

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,776 questions
asked 2025-02-24T04:41:04.2466667+00:00
Nishant M 0 Reputation points
commented 2025-02-27T09:09:48.78+00:00
Jiajing Hua-MFST 15,285 Reputation points Microsoft Vendor
1 answer

How do I convert Macro to Office Scripts? Can anyone help me?

Sub AssignUniqueIDsToExistingRows()      Dim ws As Worksheet      Dim cell As Range      Dim lastRow As Long      Dim sheetNames As Variant      Dim i As Integer        ' Define the sheets where Unique IDs should be created      sheetNames =…

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,776 questions
asked 2025-02-26T20:53:58.7766667+00:00
Johnson, Sara 0 Reputation points
answered 2025-02-26T22:15:53.7933333+00:00
Michael Taylor 56,966 Reputation points
2 answers One of the answers was accepted by the question author.

Excel 365 2501 Build 64-Bit Won't Use all processors - reverts to using Manual 4

Not sure when this started happening, but with Excel I am able to set the processors to Manual to 4, but when I update to 6 or set to Use all and Save the workbook and open again the Manual of 4 is selected again. Not sure why I can't save using either…

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,776 questions
asked 2025-02-25T23:25:49.5666667+00:00
Doug Rosencrans 20 Reputation points
accepted 2025-02-26T21:20:55.0533333+00:00
Doug Rosencrans 20 Reputation points
2 answers

How to convert multiple xml files to one csv file

There are 33 xml files with varying schema that have to combined and converted to one csv file is this possible with 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,776 questions
asked 2025-02-25T13:45:05.0233333+00:00
CJoeS 0 Reputation points
answered 2025-02-26T09:40:01.8333333+00:00
Jiajing Hua-MFST 15,285 Reputation points Microsoft Vendor
2 answers

EXCEL STAMP DUTY CALCUALTOR

Hi folks, I have been using this formula to calculate stamp duty on possible UK house purchases (residential not investment): =SUMPRODUCT(--(B12>{125000;250000;925000;1500000}), (B12-{125000;250000;925000;1500000}), {0;0.05;0.05;0}) ... but need 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,776 questions
asked 2025-02-22T10:59:57.1666667+00:00
Mark Barrow 0 Reputation points
commented 2025-02-26T08:58:15.6633333+00:00
Jiajing Hua-MFST 15,285 Reputation points Microsoft Vendor
1 answer

Excel Files not Opening on Windows 11 after 24H2 Update

We are on a Domain network with around 230 Users . We have issues now opening Excel sheet as it gets stuck at the loading Splash screen . It was working normal Before Windows 11 24H2 update . The only solution now is to format the PC which is not…

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,776 questions
asked 2025-02-25T20:46:16.5033333+00:00
Nitin S 0 Reputation points
answered 2025-02-26T07:03:45.6833333+00:00
Emi Zhang-MSFT 27,971 Reputation points Microsoft Vendor
4 answers

Get help to amend my syntax

I have two separate syntax to sum up value. Could anyone help me to combine the syntaxs in one go?

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,776 questions
asked 2025-02-25T17:45:00.9333333+00:00
Alan Chen 0 Reputation points
answered 2025-02-26T05:27:45.1566667+00:00
Emi Zhang-MSFT 27,971 Reputation points Microsoft Vendor
0 answers

How to Increment the Value (variable loopIndex) in write to Excel worksheet

How can I increment loopindex by 1? I have tried %LoopIndex%+1 and =LoopIndex+1, but neither is working

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,776 questions
asked 2025-02-25T13:31:10.38+00:00
Sadagopuram, Revathi 0 Reputation points
commented 2025-02-25T23:36:39.4266667+00:00
Viorel 120.1K Reputation points
1 answer

Excel 2016 stuck on opening 100% if it contains external links

On our companies computers, all the new laptops come with windows 11 and this problem only occurs on these new computers. When people are trying to open files that have workbook links it will just get stuck opening the file at 100% and nothing will…

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,776 questions
asked 2025-02-21T09:13:07.9266667+00:00
AP951357 0 Reputation points
commented 2025-02-25T09:57:35.0366667+00:00
Jiajing Hua-MFST 15,285 Reputation points Microsoft Vendor
2 answers

Modifications are not saved, excel file not generated. Unable to save and generate upload file in Excel on Mac OS

I need to generate an upload file from a Microsoft Excel sheet with Macros. However, I keep getting the statement, 'Modifications are not saved, excel file not generated. Unable to save and generate upload file' in Excel on Mac Book. Any help will be…

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,776 questions
asked 2025-02-21T16:53:04.06+00:00
Henry Ibanda 0 Reputation points
answered 2025-02-24T06:59:25.1433333+00:00
Henry Ibanda 0 Reputation points
1 answer

MSoffice 2019 - Microsoft Excel is not working.

We have purchased MS office 2019 Professional through one of our supplier. This was purchased for one the control system project of ours supplied to IOCL. for mapping the purchased MS Office to a email ID, one email ID was created…

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,776 questions
asked 2025-02-21T08:05:37.7533333+00:00
Himanshu Augastya 0 Reputation points
answered 2025-02-24T02:12:59.7233333+00:00
Emi Zhang-MSFT 27,971 Reputation points Microsoft Vendor
0 answers

ActiveX Issue in Excel version 2502

When using the above ActiveX forms on Excel version 2502, Build 16.0.18526.20044 with the below VBA code, it gives a 429 error (ActiveX component can't create object), but it works without issue on version 2412 Build 16.0.18324.20240. Private Sub…

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,776 questions
asked 2025-02-21T16:00:47.72+00:00
Brubaker, Preston 0 Reputation points
commented 2025-02-22T17:28:44.1966667+00:00
Viorel 120.1K Reputation points
1 answer

Excel Macros Not Running on Company Server

Hello, I have an issue where Excel macros work fine on my PC, but when the file is stored on my company’s server, macros are blocked. Excel shows a security risk warning in pink, and the "Unblock" checkbox is missing from the file…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,776 questions
asked 2025-02-17T13:31:03.38+00:00
EULOGIO JIMENEZ JIMENEZ 0 Reputation points
answered 2025-02-18T00:56:11.28+00:00
Emi Zhang-MSFT 27,971 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Power Query error 0xC0000005

User reported experiencing an error (0xC0000005) when running Power Query on two different queries in Excel LDAP settings have been verified correct

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,776 questions
asked 2025-02-15T06:22:24.7933333+00:00
Simpson, Alan 20 Reputation points
accepted 2025-02-17T03:29:30.3166667+00:00
Simpson, Alan 20 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.
474 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,323 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,776 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 5 Reputation points
commented 2025-02-14T15:11:44.54+00:00
Richard Price 0 Reputation points