2,048 questions with Excel tags

Sort by: Updated
1 answer

Regarding Mapping of the excel file to another excel file

We have 1 case where user have mapped the excel file to another excel file using VLOOKUP formula, but now the original file which was mapped to another excel file is being deleted and cannot be restored. Here question is, If the original excel file…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,219 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,999 questions
asked 2024-12-25T11:53:59.0766667+00:00
Utkarsha 0 Reputation points
answered 2024-12-25T14:47:28.1333333+00:00
Mohsin M Khan 0 Reputation points
1 answer

Unable to find excel content in file explorer search

Environment - Windows Server 2022.                             Office - M365 - as per the MCO. The excel files doesn't show up when the cx tries to search the contents of the excel file in the search bar of the file explorer. The issue only occurs…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 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,740 questions
asked 2024-12-24T19:45:50.2333333+00:00
DeepakCONVERGYSCORPORATION-2792 5 Reputation points
commented 2024-12-25T14:23:34.1033333+00:00
DeepakCONVERGYSCORPORATION-2792 5 Reputation points
1 answer

Saving an Excel file in a sharepoint synchronized local folder as PDF takes a long time to show up locally

Hi there, Hopefully someone can help me. I have the following situation: Excel Files are on SharePoint Online The SharePoint Online folders are synced locally I open the Excel file from the local folder showing a path like: C:\Users\etc\temp.xls.…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,999 questions
asked 2024-12-23T08:41:36.75+00:00
Stefan Verheggen 0 Reputation points
commented 2024-12-25T12:42:13.7233333+00:00
Stefan Verheggen 0 Reputation points
1 answer

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?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
asked 2024-12-21T18:58:20.37+00:00
Orkit 40 Reputation points
commented 2024-12-25T08:49:49.14+00:00
Jiajing Hua-MFST 12,240 Reputation points Microsoft Vendor
1 answer

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,048 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
420 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
Sangtani, Payal (CSW) 0 Reputation points
commented 2024-12-24T03:18:40.6433333+00:00
Jiachen Li-MSFT 32,961 Reputation points Microsoft Vendor
1 answer

Embedding links change to 1drv how to change back to onedrive.live

Hi, I am trying in excel to use get data>>>from web>>> And insert a onedrive embed link (and changing embed to download) but lately when i go to embed on onedrive it is no longer giving me onedrive.live links it is shortening them to…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,219 questions
asked 2024-09-10T11:26:13.9366667+00:00
J 0 Reputation points
commented 2024-12-23T22:21:59.6633333+00:00
Erland Sommarskog 114.6K Reputation points MVP
0 answers

Cannot Change Read-Only Status of Folder for Saving Files in Excel VBA on Windows 11 Pro.

I'm running Win 11 Pro, Microsoft® Excel® for Microsoft 365 MSO (Version 2412 Build 16.0.18324.20092) 64-bit. I am having a problem saving a file using VBA now using the code below, although the macro used to work without a problem. …

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 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,103 questions
asked 2024-12-23T17:07:24.3266667+00:00
N. Manganaro 0 Reputation points
commented 2024-12-23T18:23:44.8633333+00:00
N. Manganaro 0 Reputation points
1 answer

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:…

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,373 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 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,103 questions
asked 2024-12-20T21:41:18.6666667+00:00
Austin 0 Reputation points
answered 2024-12-23T07:57:20.1366667+00:00
Jiajing Hua-MFST 12,240 Reputation points Microsoft Vendor
2 answers

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,…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,219 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,999 questions
asked 2024-12-20T20:09:52.22+00:00
Drew H 15 Reputation points
answered 2024-12-23T06:59:28.6433333+00:00
AllenXu-MSFT 22,156 Reputation points Microsoft Vendor
1 answer

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,…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
asked 2024-12-20T10:14:51.6966667+00:00
Jose Luis Loperena 0 Reputation points
answered 2024-12-23T06:07:37.86+00:00
Jiajing Hua-MFST 12,240 Reputation points Microsoft Vendor
1 answer

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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
asked 2024-12-21T10:24:01.94+00:00
sunil sachdeva 0 Reputation points
answered 2024-12-23T02:30:53.7266667+00:00
Emi Zhang-MSFT 26,606 Reputation points Microsoft Vendor
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.
908 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,800 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
asked 2024-12-20T22:54:00.32+00:00
Tommy Martin 0 Reputation points
commented 2024-12-23T02:27:39.2633333+00:00
Jiajing Hua-MFST 12,240 Reputation points Microsoft Vendor
1 answer

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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
asked 2024-12-20T10:17:15.4766667+00:00
Jose Luis Loperena 0 Reputation points
answered 2024-12-23T02:27:04.57+00:00
Emi Zhang-MSFT 26,606 Reputation points Microsoft Vendor
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…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
465 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,300 questions
asked 2024-12-18T19:59:10.02+00:00
Ted Rogers 0 Reputation points
commented 2024-12-23T01:04:11.75+00:00
Chandra Boorla 5,755 Reputation points Microsoft Vendor
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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
asked 2024-12-18T16:16:01.1566667+00:00
Orkit 40 Reputation points
accepted 2024-12-22T15:43:47.74+00:00
Orkit 40 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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
asked 2023-02-28T17:23:44.3766667+00:00
George Sugden 5 Reputation points
edited a comment 2024-12-21T20:15:36.5866667+00:00
Vinay Deo 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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
asked 2024-12-19T07:52:23.3066667+00:00
Craig Dickinson 0 Reputation points
answered 2024-12-20T07:16:11.8033333+00:00
Emi Zhang-MSFT 26,606 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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
asked 2023-10-31T00:43:54.4666667+00:00
Jansen, Randolph (CCI-RapidScale) 0 Reputation points
answered 2024-12-19T16:54:26.84+00:00
Paul 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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 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,740 questions
asked 2024-11-11T16:34:30.3333333+00:00
Rob Benson 5 Reputation points
commented 2024-12-18T17:30:56.5133333+00:00
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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,219 questions
asked 2024-12-17T13:08:26.34+00:00
Today0192134 0 Reputation points
commented 2024-12-18T07:56:43.6233333+00:00
Jiajing Hua-MFST 12,240 Reputation points Microsoft Vendor