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
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
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,984 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 13%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
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…
asked 2024-11-18T02:50:11.7166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 69%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWK%3C/text%3E%3C/svg%3E)
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?
asked 2024-11-09T19:29:52.3766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 12%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBF%3C/text%3E%3C/svg%3E)
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
asked 2024-11-18T10:53:25.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 71%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
김솔
0
Reputation points
commented 2024-11-21T01:27:54+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
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,…
asked 2023-06-15T02:52:07.5766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 0%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Sarah Harrison
35
Reputation points
commented 2024-11-21T01:08:21.75+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 87%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
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?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 91%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
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…
asked 2023-06-07T09:37:45.8866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 63%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tony S
15
Reputation points
commented 2024-11-20T11:06:52.7133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 83%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
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
asked 2024-11-20T06:46:47.0233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 87%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Deka S
0
Reputation points
answered 2024-11-20T08:03:38.9633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 96%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYH%3C/text%3E%3C/svg%3E)
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…
asked 2024-05-17T12:10:10.9733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 37%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kirsten Affleck
25
Reputation points
commented 2024-11-19T19:28:21.37+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 72%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
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,021 questions
asked 2024-09-13T16:51:01.04+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 96%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Marco Couch
30
Reputation points
commented 2024-11-19T14:45:31.3233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 93%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
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…
asked 2024-11-14T12:23:26.0733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 22%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
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
asked 2024-11-02T02:29:12.3633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 33%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFH%3C/text%3E%3C/svg%3E)
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.
asked 2024-11-12T18:38:02.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 25%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
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…
asked 2024-11-18T07:49:05.5966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 64%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
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.
asked 2024-11-13T12:04:40.2133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 27%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
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:…
asked 2023-12-12T22:26:20.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DataViz369
5
Reputation points
answered 2024-11-18T09:36:39.2666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 80%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
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,021 questions
asked 2024-11-07T06:46:16.22+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 31%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 42%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
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…
asked 2024-11-15T22:14:30.8433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 22%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
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,742 questions
asked 2024-11-16T15:02:51.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 0%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sangtani, Payal (CSW)
0
Reputation points
answered 2024-11-18T01:47:05.5566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jiachen Li-MSFT
32,451
Reputation points Microsoft Vendor