1,977 questions with Excel tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

Saving the newly created files.

Hi All, I am using Microsoft 365 Apps for Enterprise. When I open any new Excel or Word document or any office application file AutoSave is disabled. Is this the default behavior? Can the AutoSave setting be changed for new Office 365 files? i am seeing…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,730 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
514 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,186 questions
Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
935 questions
asked 2024-11-09T22:14:49.4933333+00:00
Glenn Maxwell 11,541 Reputation points
accepted 2024-11-15T23:05:52.0066667+00:00
Glenn Maxwell 11,541 Reputation points
0 answers

Is there a way to search a date column for a date range and then if the date falls within a certain range, I would like to include any amount ordered within that date range in a sum. If the dates are outside that range, do not include the number ordered

Column A has different dates upon which product was ordered Column b has the number of product that were ordered on that date I want to sum up all the orders from, for example, October only. What is a formula to use to search column A for only dates…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 questions
asked 2024-11-15T22:14:30.8433333+00:00
Todd H 0 Reputation points
0 answers

Get live numbers from web into my excel sheet

I need to get live numbers from a web page (example, googlfinace) into my excel sheet, so I can keep my excel sheet updated at all time, fore purpose of quick action point.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 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,729 questions
asked 2024-11-10T18:48:51.0666667+00:00
Karl Petter Konradsen 0 Reputation points
edited the question 2024-11-15T10:20:54.01+00:00
ajkuma 26,721 Reputation points Microsoft Employee
0 answers

how to fix this error

How can I solve this problem? Что-то пошло не так К сожалению, в текущий момент вход в систему недоступен, но мы стараемся устранить проблему. Повторите попытку позже. Если проблема сохраняется, обратитесь в службу поддержки и укажите следующие…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 questions
Microsoft Exchange Online Management
Microsoft Exchange Online Management
Microsoft Exchange Online: A Microsoft email and calendaring hosted service.Management: The act or process of organizing, handling, directing or controlling something.
4,598 questions
asked 2024-11-14T13:35:13.48+00:00
Kaan Nahya 0 Reputation points
commented 2024-11-15T07:53:18.2733333+00:00
Jiajing Hua-MFST 10,885 Reputation points Microsoft Vendor
1 answer

Upload Failed:Problems Refreshing

Hi there, Im currently using a 2019 version of excel. All my files are saved directly to one drive , however when i open old excel documents using one drive on my desktop (file explorer) , it doesnt just let me save the changes made . instead it…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,157 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,281 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,729 questions
asked 2024-11-14T12:23:26.0733333+00:00
Simone Govender 0 Reputation points
answered 2024-11-15T07:20:16.72+00:00
Simone Govender 0 Reputation points
0 answers

ADODB Parameters: work independent from regional formats

Hi, I'm using an ADODB.Command object and it's Parameters property to insert records into an Access database ("insert into table (...) values (...)"). One of the table fields is of type Currency. The corresponding ADODB.Parameter.Type is…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 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,006 questions
asked 2024-11-14T08:26:00.6266667+00:00
Armin Zingler 0 Reputation points
edited the question 2024-11-15T01:34:57.3633333+00:00
Jiajing Hua-MFST 10,885 Reputation points Microsoft Vendor
0 answers

Is anyone having issues creating, running or recording Office Scripts in Excel?

've been using Office Scripts in Excel to automate some tasking. Yesterday, I tried to add a new script and it gives me the following error. Oops, something went wrong An unexpected error occurred. Click 'Refresh' button to retry. I also tried 'Record…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 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,006 questions
asked 2024-11-14T14:17:02.22+00:00
PrietoChoy, Rosa M. (MITRE) 0 Reputation points
1 answer

How Can I delete #REF! Error in Conditional formatting Manage Rule. It Become my worksheet Slower.

How Can I delete #REF! Error in Conditional formatting Manage Rule. It Become my worksheet Slower.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 questions
asked 2024-11-13T12:04:40.2133333+00:00
DIPANKAR SARKAR 0 Reputation points
answered 2024-11-14T08:00:50.1166667+00:00
Olaf Helper 45,121 Reputation points
1 answer

Excel Visio Data Visualizer add-in - Not working on Office 2019

Hi all, I am not able to use the 'Visio Data Visualizer' excel add-in. When attempting to open it, it just brings a white screen.

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,730 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 questions
Visio Management
Visio Management
Visio: A family of Microsoft products used to create diagrams and vector graphics.Management: The act or process of organizing, handling, directing or controlling something.
256 questions
asked 2024-11-13T16:54:28.73+00:00
Armando Morones 0 Reputation points
answered 2024-11-14T03:20:42.6233333+00:00
Jiajing Hua-MFST 10,885 Reputation points Microsoft Vendor
1 answer

How to Set Excel's "Find All" Feature to Search Entire Workbook by Default Instead of Current Sheet?

I'm trying to adjust Excel's "Find All" feature so that it searches the entire workbook by default, rather than only the current sheet. I’ve researched this and found that there are third-party tools and VBA macros that can accomplish this, but…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,730 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,615 questions
asked 2024-11-07T05:03:57.15+00:00
Researcher 6 Reputation points
answered 2024-11-14T01:20:25.98+00:00
Rojer 0 Reputation points
1 answer

Excel forumla longer than 8192 characters

I have a Excel worksheet that is 5490 columns wide in a shared workbook. When I save the file with zero columns hidden I do NOT get this message. When I hide every 11-15th columns it will work until I get to column 4245 approximately. After that I get…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 questions
asked 2024-11-07T12:53:39.91+00:00
Josh Albers 0 Reputation points
commented 2024-11-13T22:01:40.5766667+00:00
Josh Albers 0 Reputation points
2 answers

SSIS package that supposed to export data from SQL to Excel stopped working after upgrading to SQL2022

Hello. We have multiple SSIS packages that import data from Excel into SQL and export results back to Excel. All those SSIS packages were designed in VS 2012, connecting to SQL 2012 and Excel 2013, and we can run it successfully as a part of SQL job or…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,028 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,595 questions
asked 2024-10-30T19:46:03.3633333+00:00
Alla 0 Reputation points
edited a comment 2024-11-13T20:14:17.5533333+00:00
Yitzhak Khabinsky 25,956 Reputation points
1 answer

How to fix multi conditional formatting issue-- dates

I am attempting to color code Board Member terms based on how many years they have left. I am using conditional formatting formulas to attempt this, but something isn't working correctly.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 questions
asked 2024-11-12T18:38:02.0333333+00:00
Megan Conkle 0 Reputation points
answered 2024-11-12T20:43:27.4633333+00:00
Barry Schwarz 3,071 Reputation points
1 answer

Why do these cells in Excel stay green and cannot be changed?

I have a spreadsheet that my team uses in excel that we share on the web browser and use chrome. When we try to insert new cells they show up as white until we enter txt into them, and then they are hgihlighted as this green color shown below. But we…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 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,729 questions
asked 2024-11-11T16:34:30.3333333+00:00
Rob Benson 0 Reputation points
answered 2024-11-12T02:32:13.1333333+00:00
Emi Zhang-MSFT 25,631 Reputation points Microsoft Vendor
0 answers

Unable to set any property when protecting an excel worksheet using pywin32

Hello, I am using pywin32 for a project to automate a few excel files using python. In the excel file, I want to protect all the cells that contain a formula. So, I first unlock all the cells and then only lock those cells which has a formula. When I…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 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,006 questions
asked 2024-11-11T19:46:23.2066667+00:00
Dhruv Jain 0 Reputation points
1 answer One of the answers was accepted by the question author.

Dialog box blocking access to Excel

Every time I try to open an Excel file, a dialog box opens asking me to save the file. I do, but it pops back up. I hit cancel; it pops back up. Tried repair and reset, still pops back up. I have to use task manager to get it to shut down even. I have…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 questions
asked 2024-11-08T14:17:47.6766667+00:00
Leslie S 20 Reputation points
commented 2024-11-11T15:24:19.6566667+00:00
Leslie S 20 Reputation points
0 answers

How to copy and paste a macro into various tabs making minor adjustments to the code.

I have a workbook that has tabs for each day of the year. The tabs are labeled as the day they correspond to. I want to lock each tab at midnight to prevent accidental changes to the the data. I have the macro code for the locking by date and time. Can…

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.
5,165 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 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,006 questions
asked 2024-11-08T18:51:31.96+00:00
Byron Soley 0 Reputation points
edited the question 2024-11-11T07:03:28.78+00:00
Jiajing Hua-MFST 10,885 Reputation points Microsoft Vendor
0 answers

Excel JS Addin - Offline availability of full application with taskpane and custom functions

Offline access to Excel Add-in with MSAL and custom functions Description We are about to develop an Excel TypeScript Add-in that should replace an existing .xla add-in. This add-in has two main functionalities: Provide custom functions to the Excel…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 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,006 questions
asked 2024-11-08T14:53:21.06+00:00
Yannick T 0 Reputation points
edited the question 2024-11-11T05:18:19.25+00:00
VenkateshDodda-MSFT 21,976 Reputation points Microsoft Employee
4 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.
1,977 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,186 questions
asked 2023-02-13T12:38:39.7266667+00:00
Hicham Salama 5 Reputation points
commented 2024-11-10T14:56:06.2666667+00:00
Gokulbros 0 Reputation points
0 answers

How can I add Excel Notes to cells with the Office Javascript API?

Can support for this be added if it doesn't exist already?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,977 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
1,002 questions
asked 2024-11-09T19:29:52.3766667+00:00
Bon Fisher 0 Reputation points