1,984 questions with Excel tags

Sort by: Updated
0 answers

Excel 2021 LTSC VL for VDI

We have a VDI environment where we want to use Excel 2021. We have volume licenses for Excel 2021 LTSC with up to 10 activations. In our VDI environment, each user login creates a machine, but we would validate the license with a specific user email. The…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,743 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 questions
asked 2024-11-21T12:37:19.84+00:00
TI CHUIMI 0 Reputation points
0 answers

Understanding 'Sysgen Names' and 'Sysgen Names Error' in Office 2021's Spreadsheet Compare Tool

Hello, My colleagues and I use Office Professional Plus 2021 which comes with an add-in with an app called Spreadsheet Compare that compares two Excel books and shows differences in each cell. Apparently, it has an option that enables to detect…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 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,731 questions
asked 2024-11-18T02:50:11.7166667+00:00
Wataru Kitagawa 0 Reputation points
commented 2024-11-21T04:30:52.8733333+00:00
Wataru Kitagawa 0 Reputation points
2 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,984 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
1,003 questions
asked 2024-11-09T19:29:52.3766667+00:00
Bon Fisher 0 Reputation points
edited an answer 2024-11-21T02:22:55.59+00:00
Meekou 1 Reputation point
1 answer

I am using the Korean version of Excel on my Mac, but when I go into Data Analysis, it shows up in the English version

I am using the Korean version of Excel on my Mac, but when I go into Data Analysis, it shows up in the English version

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 questions
asked 2024-11-18T10:53:25.8+00:00
김솔 0 Reputation points
commented 2024-11-21T01:27:54+00:00
Jiajing Hua-MFST 11,360 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Excel - How do I get cells to change colour when they are nearing future expiry dates

Hi, I have a spreadsheet with staff names down column A, and across the top I have different training courses they attend which they are required to refresh after 1, 2 or 4 years (depending on training). I want to be able to enter the date they attend,…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 questions
asked 2023-06-15T02:52:07.5766667+00:00
Sarah Harrison 35 Reputation points
commented 2024-11-21T01:08:21.75+00:00
sabrina anderson 0 Reputation points
3 answers

How to report a bug?

I need to report a bug in Excel embedded files. How do I do that?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 questions
asked 2024-11-16T15:52:04.64+00:00
Stefan 0 Reputation points
answered 2024-11-20T21:11:13.6066667+00:00
Stefan 0 Reputation points
3 answers

How do I lock cells in excel365 by date and time

Hi, I have a table which is editable. So I have say 10 rows 3 columns. In each of the rows I want to be able to stop them being editable after a date and time. Each row will may have the same date but a different time. So in row one and the 3 columns…

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,197 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 questions
asked 2023-06-07T09:37:45.8866667+00:00
Tony S 15 Reputation points
commented 2024-11-20T11:06:52.7133333+00:00
Caroline R 0 Reputation points
1 answer

Graph API For Excel Online

Using Graph API, can we create columns in an Excel Worksheet? I am trying to duplicate the column headers to multiple new worksheets using Graph API. Also, can we create a new Excel Workbook through Graph API

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,370 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 questions
asked 2024-11-20T06:46:47.0233333+00:00
Deka S 0 Reputation points
answered 2024-11-20T08:03:38.9633333+00:00
Yakun Huang-MSFT 6,965 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

Creating a link from a word doc to a specific excel cell

Hi, I'd like to create a link from a word document to a specific cell in a workbook sheet. I have tried \  work book address #gid=.'pagename -'!$A$160. which initially takes me to the correct cell but I get a pop up box saying "reference isn't…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 questions
asked 2024-05-17T12:10:10.9733333+00:00
Kirsten Affleck 25 Reputation points
commented 2024-11-19T19:28:21.37+00:00
Carl Potter 0 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.
1,984 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,022 questions
asked 2024-09-13T16:51:01.04+00:00
Marco Couch 30 Reputation points
commented 2024-11-19T14:45:31.3233333+00:00
Arttu Pyykönen 0 Reputation points
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,984 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,161 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,285 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,731 questions
asked 2024-11-14T12:23:26.0733333+00:00
Simone Govender 0 Reputation points
commented 2024-11-19T09:47:12.7133333+00:00
Jiajing Hua-MFST 11,360 Reputation points Microsoft Vendor
1 answer

the microsoft.ace.oledb.12.0 provider is not registered on the local machine

My system are windows 11, office 365 , Amos 26. When I import excel file to Amos which show the error of microsoft.ace.oledb.12.0 provider . would you tell me how reinstall ace.oledb 12 regards, Frederic

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 questions
asked 2024-11-02T02:29:12.3633333+00:00
Frederic Ho 0 Reputation points
commented 2024-11-19T01:24:34.0533333+00:00
Emi Zhang-MSFT 25,711 Reputation points Microsoft Vendor
2 answers

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,984 questions
asked 2024-11-12T18:38:02.0333333+00:00
Megan Conkle 0 Reputation points
answered 2024-11-19T01:23:23.46+00:00
Emi Zhang-MSFT 25,711 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Optimizing Pivot Tables and Slicers for Dynamic Excel Dashboards

A dynamic dashboard is being created in Excel to analyze sales data, including Date, Region, Product, Sales, and Profit. What are the steps to configure Pivot Tables for automatic refreshing with source data updates, ensure that multiple Pivot Tables…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 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,731 questions
asked 2024-11-18T07:49:05.5966667+00:00
DexterHale 20 Reputation points
accepted 2024-11-18T18:04:15.2366667+00:00
DexterHale 20 Reputation points
4 answers

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,984 questions
asked 2024-11-13T12:04:40.2133333+00:00
DIPANKAR SARKAR 0 Reputation points
answered 2024-11-18T09:50:54.37+00:00
Jiajing Hua-MFST 11,360 Reputation points Microsoft Vendor
2 answers

[DataFormat.Error] when refreshing queries in Excel

I have a "master" excel file stored on a SharePoint site which has a number of queries fetching data from other Excel files stored in the same SharePoint folder. Recently, when I pressed "Refresh All", I got an error message stating:…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,897 questions
asked 2023-12-12T22:26:20.86+00:00
DataViz369 5 Reputation points
answered 2024-11-18T09:36:39.2666667+00:00
Sander Ten Wolde 0 Reputation points
0 answers

modifications are not saved upload file not generated cannot access a certain file. This error is on my laptop only but does appear on the same excel file on another laptop. My Macros are enabled and i have done a repair but still facing same issue

I am getting this error 'modifications are not saved upload file not generated cannot access a "certain file"'. This error is on my laptop only but does appear on the same excel file on another laptop. My Macros are enabled and i have done a…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 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,022 questions
asked 2024-11-07T06:46:16.22+00:00
Adil Jin Mohammed 0 Reputation points
edited the question 2024-11-18T08:59:02.59+00:00
Jiajing Hua-MFST 11,360 Reputation points Microsoft Vendor
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,743 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 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.
257 questions
asked 2024-11-13T16:54:28.73+00:00
Armando Morones 0 Reputation points
commented 2024-11-18T08:54:59.27+00:00
Jiajing Hua-MFST 11,360 Reputation points Microsoft Vendor
2 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,984 questions
asked 2024-11-15T22:14:30.8433333+00:00
Todd H 0 Reputation points
answered 2024-11-18T07:37:19.6133333+00:00
Emi Zhang-MSFT 25,711 Reputation points Microsoft Vendor
2 answers

Microsoft Excel cannot access the file 'SegmentExport2_f7d153.xlsx'. There are several possible reasons The file name or path does not exist. The file is being used by another program.

when we open the excel getting permission issue . first create function to create the macro then open it .getting error on xlWorkBook = xlApp.Workbooks.Open(MacroFolderPath + sTmpExcelFile). Please find the below code.pleas ehelp me out. Protected…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
402 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,743 questions
asked 2024-11-16T15:02:51.11+00:00
Sangtani, Payal (CSW) 0 Reputation points
answered 2024-11-18T01:47:05.5566667+00:00
Jiachen Li-MSFT 32,451 Reputation points Microsoft Vendor