3,711 questions with Excel-related tags

Sort by: Updated
Updated Created Answers
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
commented 2025-02-28T07:41:07.4266667+00:00
Emi Zhang-MSFT 28,056 Reputation points Microsoft Vendor
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

Is .setColumnWidth() broken in Excel scripts?

I have written a very simple code in Office Scripts which should simply set some column widths and the header rows (see below). However, when I run the script, the column widths are nowhere near the values I have input (I have added comments to show the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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.
4,294 questions
asked 2024-09-13T16:51:01.04+00:00
Marco Couch 30 Reputation points
commented 2025-02-27T23:13:31.2666667+00:00
Michelle Ran 346 Reputation points Microsoft Employee
1 answer

How to fix this error that happens when I try to convert xls to pdf

The warning in the picture pops up when I try to save an excel file (format: xls) into pdf using the save as function. When translated, it means "This file format is not supported by Microsoft Information Protection. You must convert the document…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2024-10-08T11:35:08.8233333+00:00
Ji Su Seo 0 Reputation points
edited an answer 2025-02-27T22:47:02.8933333+00:00
nicolay -- 0 Reputation points
1 answer One of the answers was accepted by the question author.

Help with IF Function in Excel

I need help with an IF function if that is what makes the most sense for the following scenario: In Sheet 1, I have a list of User IDs In Sheet 2, I have the same list of User IDs, but they could be listed multiple times in the same column In Sheet…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2025-02-18T18:39:37.41+00:00
EH_47 0 Reputation points
commented 2025-02-27T17:33:45.37+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
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 28,056 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 28,056 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

Regarding the problem that Excel mouse wheel cannot scroll smoothly

I have installed mouse smoothing software, but Excel still does not support smooth scrolling with the mouse wheel. I have tried many methods in the community, but still cannot solve it. I hope someone can help me solve this problem. Thank you.(The…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2025-02-14T04:37:39.86+00:00
庞九权 0 Reputation points
commented 2025-02-25T01:03:42.82+00:00
Emi Zhang-MSFT 28,056 Reputation points Microsoft Vendor
5 answers

how to fix Excel LTSC 2021 install problem, error code 0-2048(0)

when I start the installation of excel LTSC 2021 I have an error message that comes out 0-2048 (0) I deactivated the firewall, I uninstalled all office products, I tested the installation on another machine, it gives the same error

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,302 questions
asked 2023-02-13T12:38:39.7266667+00:00
Hicham Salama 5 Reputation points
answered 2025-02-24T16:20:05.34+00:00
Gabrielle Lawrence 0 Reputation points
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