Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,044 questions
1 answer
One of the answers was accepted by the question author.
Data protection, security and validation in excel
It’s been several years now that users complain about protection options but nothing is done by microsoft: when protecting a sheet with an array, it does not extend automatically anymore however it would be convenient to have an option that leaves the…
![](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, 74%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
1 answer
How to transfer office apps over to new computer (Office16OneNoteFreeR_Bypass edition and Office16O365HomePremR_Grace edition)
I had a Surface Laptop 4 that had all the office apps installed when it came (Word, Excel, Ppt, OneNote). I just got a Lenovo ThinkPad P14s Gen 5 AMD. When I logged in on my new computer, it had all the office apps, but it is now saying that "my 5…
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
904 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,795 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,044 questions
asked 2024-12-20T22:54:00.32+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, 88%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tommy Martin
0
Reputation points
commented 2024-12-21T22:39:19.8866667+00:00
Charles Kenyon
2,931
Reputation points
1 answer
How to exactly enable Office Script in excel?
Hello. Currently, I am subscribed with an Office for Home. I tried looking on how to use the 'Office Script' but I can't find anything. Do I have to upgrade my account to Office for Business for this? Please let me know so I won't waste any resources for…
asked 2023-02-28T17:23:44.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(44.800000000000004, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
George Sugden
5
Reputation points
edited a comment 2024-12-21T20:15:36.5866667+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(124.80000000000001, 27%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
Vinay Deo
0
Reputation points
0 answers
Hide workbook tabs in Excel online
Hello, I want to hide the workbook tabs to use only links. For this I go through the advanced options but it does not work on Excel online, how to hide the workbook tabs on Excel online?
0 answers
Unique and sort function not woring in my excel 2019 home and student
Ive microsoft 365 and home and student 2019. unique and sort functions are not working in that.Screenshot 2024-12-21 155052.png
asked 2024-12-21T10:24:01.94+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(230.39999999999998, 54%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
sunil sachdeva
0
Reputation points
commented 2024-12-21T17:02:27.38+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(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Barry Schwarz
3,161
Reputation points
1 answer
A co-worker's My Files under Recent in Sharepoint keep asking to "Open this file?" instead of opening in Microsoft Excel
Hello, One of our employees is trying to open recently viewed files on our Sharepoint site. Issue: He clicks the "My Files" button and selects any of the Excel files. A box then appears asking to open the file. If I try the same on my computer,…
asked 2024-12-20T20:09:52.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(268.8, 62%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Drew H
15
Reputation points
answered 2024-12-20T22:12:57.09+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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
68,406
Reputation points
0 answers
Why won't ChartSeries.getPoints() work in Excel for web?
I have a workbook I've created in Excel for web with just a single column chart and some sample data to its side Using office scripts, I'm trying to set the color of an individual column on the chart with this code: function main(workbook:…
![](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(64, 77%, 16%)' 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 answers
Microsoft Excel cannot access the file ' SegmentExport2_d0ad8d.xlsx'. There are several possible reasons: • The file name or path does not exist. • The file is being used by another program. • The workbook you are try
HI Web application Hosted on IIS Server and when i am trying to open the excel file from vb .net code getting Microsoft Excel cannot access the file 'E:\inetpub\Sites\iHomeSite\main\Macros\SegmentExport2_d0ad8d.xlsx'. There are several possible reasons:…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,044 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
419 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,760 questions
asked 2024-12-20T17:32:35.5733333+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
asked 2024-12-20T17:32:35.5733333+00:00
Sangtani, Payal (CSW)
0
Reputation points
0 answers
How to Maintain Excel Sheet Protections When Opening in Numbers or Google Sheets
An Excel document has been created with protected and hidden sheets, and the workbook is also password protected. It is intended for use by multiple users in a company, allowing them to edit only specific cells while keeping everything else hidden and…
asked 2024-12-20T10:17:15.4766667+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(105.60000000000001, 88%, 20%)' 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)
Jose Luis Loperena
0
Reputation points
asked 2024-12-20T10:17:15.4766667+00:00
Jose Luis Loperena
0
Reputation points
0 answers
How to keep Excel Sheets and protected workbooks protected when opening in Numbers or Google Sheet
I've created an Excel document with both protected and hidden Sheets, and the workbook itself protected. It needs to be used by many users in my company, but they can only edit a few cells, so everything else is hidden and password protected. However,…
asked 2024-12-20T10:14:51.6966667+00:00
Jose Luis Loperena
0
Reputation points
asked 2024-12-20T10:14:51.6966667+00:00
Jose Luis Loperena
0
Reputation points
1 answer
Excel 'Get Data From Web' loses Authorization header
Hi, I work for a company that allows users to generate a HTML feed of data from various tables we hold within our software. In previous versions of Excel, users were able to generate a base64 encoded authorization string within our software, and then…
asked 2024-12-19T07:52:23.3066667+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, 7.000000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Craig Dickinson
0
Reputation points
answered 2024-12-20T07:16:11.8033333+00:00
Emi Zhang-MSFT
26,451
Reputation points Microsoft Vendor
2 answers
Using TODAY() to Date Stamp text changes
I love the formula, =IF(A2<>A2, "", TODAY()), to time stamp quantity changes in a cell. However, does anyone know how to handle this for text? I want a date stamp every time text is changed in a cell (like updating notes, or product…
asked 2023-10-31T00:43:54.4666667+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(150.4, 22%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jansen, Randolph (CCI-RapidScale)
0
Reputation points
answered 2024-12-19T16:54:26.84+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(208, 28.999999999999996%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Paul
0
Reputation points
2 answers
Excel pivot connected to SSAS tabular model locking up when filtered on record that no longer exists and also has another large filter
Hello, I found a potential "bug" or performance issue for a specific setup when referencing an analysis services cube via an Excel pivot table. The specific scenario is like the below: You have a pivot table referencing an analysis services…
asked 2024-12-18T19:59:10.02+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, 97%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETR%3C/text%3E%3C/svg%3E)
Ted Rogers
0
Reputation points
commented 2024-12-19T08:24:47.0166667+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(294.40000000000003, 8%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECU%3C/text%3E%3C/svg%3E)
Chiếu sáng MPE
0
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…
asked 2024-11-11T16:34:30.3333333+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, 61%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Rob Benson
5
Reputation points
commented 2024-12-18T17:30:56.5133333+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, 16%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jeanette
0
Reputation points
0 answers
Issue with OneDrive Embedding Feature
I have been using the OneDrive embedding feature to display specific print areas from two Excel sheets (Sheet 1 and Sheet 2) on my website via HTML. Until recently, this setup worked perfectly. However, both embedded sections now only display the…
asked 2024-12-17T13:08:26.34+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(60.8, 27%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Today0192134
0
Reputation points
commented 2024-12-18T07:56:43.6233333+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
12,240
Reputation points Microsoft Vendor
0 answers
How can I fix the error "Method 'range of object'_Worksheet' failed
I keep getting this error "Method 'range of object'_Worksheet' failed while debugging this code Is there anyone knows how to fix this? If Dir(Sheet2.Range("D" & [Product_ID] + 1).Value, vbDirectory) <> "" Then
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,365 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,044 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,095 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(163.2, 48%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E0%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
unable to find the font.
Hi All, I am using Microsoft 365 Apps for Enterprise, version 16.0.18129.20200. Does the font come by default when you install Microsoft Office, or does it need to be installed separately?
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,795 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,044 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,095 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,214 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.
941 questions
asked 2024-12-15T19:21:00.0533333+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(265.6, 72%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Roger Roger
6,571
Reputation points
edited the question 2024-12-16T21:58:20.43+00:00
Roger Roger
6,571
Reputation points
1 answer
Excel for Mac - PowerQuery to SQL server using Windows account
Hi. I switched from Windows to MacOS recently and I discovered a big limitation with using Excel for Mac when trying to retrieve data from SQL server hosted on our premises. Apparently, there is no way to authenticate using Windows account, only Basic…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,044 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,207 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.
520 questions
asked 2024-12-16T11:43:24.34+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, 35%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKN%3C/text%3E%3C/svg%3E)
Klemen Novak
0
Reputation points
edited an answer 2024-12-16T16:50:37.5333333+00:00
Bruce (SqlWork.com)
68,406
Reputation points
3 answers
One of the answers was accepted by the question author.
How to enable my Data from picture option in Excel?
I have subscribed in office 365 to get the Data from picture feature, however It's not yet in my excel. please help me resolved this
asked 2023-08-31T00:32:17.0933333+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(169.60000000000002, 61%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Johna Redito
30
Reputation points
commented 2024-12-16T10:48:51.67+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, 48%, 34%)' 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)
ahsanuddin mohammed
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Inserting image into cell in Excel 2024 gives error message after reopening file.
Inserting an image into a cell in Excel 2024 (Professional Plus, LTSC) works well initially, but gives an error message after reopening the file. Some here don't see that option at all, but I do, some here also say that this would only work for Office…
![](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(182.40000000000003, 0%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)