Excel

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…

asked

Utkarsha 0

answered

Mohsin M Khan 0

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…

asked

DeepakCONVERGYSCORPORATION-2792 5

commented

DeepakCONVERGYSCORPORATION-2792 5

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

asked

Stefan Verheggen 0

commented

Stefan Verheggen 0

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?

asked

Orkit 40

commented

Jiajing Hua-MFST 12,240 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:…

asked

Sangtani, Payal (CSW) 0

commented

Jiachen Li-MSFT 32,961 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…

asked

J 0

commented

Erland Sommarskog 114.6K 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. …

asked

N. Manganaro 0

commented

N. Manganaro 0

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

asked

Austin 0

answered

Jiajing Hua-MFST 12,240 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,…

asked

Drew H 15

answered

AllenXu-MSFT 22,156 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,…

asked

Jose Luis Loperena 0

answered

Jiajing Hua-MFST 12,240 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

asked

sunil sachdeva 0

answered

Emi Zhang-MSFT 26,606 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…

asked

Tommy Martin 0

commented

Jiajing Hua-MFST 12,240 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…

asked

Jose Luis Loperena 0

answered

Emi Zhang-MSFT 26,606 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…

asked

Ted Rogers 0

commented

Chandra Boorla 5,755 Microsoft Vendor

1 answer

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…

asked

Orkit 40

accepted

Orkit 40

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

George Sugden 5

edited a comment

Vinay Deo 0

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

Craig Dickinson 0

answered

Emi Zhang-MSFT 26,606 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

Jansen, Randolph (CCI-RapidScale) 0

answered

Paul 0

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

Rob Benson 5

commented

Jeanette 0

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

Today0192134 0

commented

Jiajing Hua-MFST 12,240 Microsoft Vendor

Filter

Content

2,048 questions with Excel tags

Regarding Mapping of the excel file to another excel file

Unable to find excel content in file explorer search

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

Hide workbook tabs in Excel online

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

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

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

Why won't ChartSeries.getPoints() work in Excel for web?

A co-worker's My Files under Recent in Sharepoint keep asking to "Open this file?" instead of opening in Microsoft Excel

How to keep Excel Sheets and protected workbooks protected when opening in Numbers or Google Sheet

Unique and sort function not woring in my excel 2019 home and student

How to transfer office apps over to new computer (Office16OneNoteFreeR_Bypass edition and Office16O365HomePremR_Grace edition)

How to Maintain Excel Sheet Protections When Opening in Numbers or Google Sheets

Excel pivot connected to SSAS tabular model locking up when filtered on record that no longer exists and also has another large filter

Data protection, security and validation in excel

How to exactly enable Office Script in excel?

Excel 'Get Data From Web' loses Authorization header

Using TODAY() to Date Stamp text changes

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

Issue with OneDrive Embedding Feature