3,867 questions with Excel-related tags

Sort by: Updated
Updated Created Answers
0 answers

Stop Excel files from being opened in browser

I need to run a macro on excel opening to find the username to display only required data. This wont work if the file is opened in a browser. a. Is there anyway of completely stopping a file from being opened in a browser? b. If not, is there anyway…

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,931 questions
asked 2025-06-16T16:21:20.98+00:00
Adam Baker 0 Reputation points
4 answers

I want to use office script to copy data from one workbook to other

My problem statement is a little complicated, so please bear with me. I am going to explain the process as much as I can - Step 1: Let's say every week, I receive a client sheet called 'Main sheet' that has certain data against each client. …

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,931 questions
asked 2025-06-10T11:55:59.2566667+00:00
Oshin Jawharkar 25 Reputation points
commented 2025-06-16T07:30:11.0066667+00:00
Gabriel-N 1,015 Reputation points Microsoft External Staff Moderator
1 answer

Microsoft office documents customization

************** Exception Text ************** Microsoft.VisualStudio.Tools.Applications.Runtime.CannotCreateCustomizationDomainException: This document contains custom code that cannot be loaded because the location is not in your trusted locations list:…

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,931 questions
asked 2025-06-16T02:20:11.6333333+00:00
Cheok 0 Reputation points
answered 2025-06-16T05:00:38.6033333+00:00
Dora-T 850 Reputation points Microsoft External Staff Moderator
1 answer

How to export updated data from a Forms Excel to a new Excel using VBA

Hello, I'm looking to use a Form to submit task requests in my company, and then be able to analyse the data received to look at things like time taken to complete tasks, what's coming up this week etc. To do this, I need to be able to pull data live…

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,931 questions
asked 2025-06-10T08:54:34.73+00:00
Alex Tyler 5 Reputation points
commented 2025-06-15T23:35:50.54+00:00
TiNo-T 620 Reputation points Microsoft External Staff Moderator
1 answer

How to get AutoSave to save to the correct file path rather than a default file location on OneDrive.

AutoSave had been working fine until recently. Now when I open an Excel document, AutoSave is turned off. When I turn on AutoSave, it saves a duplicate to the "default local file location" which is [OneDrive/Documents]. When I change the…

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,770 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,176 questions
asked 2024-07-16T16:55:21.8+00:00
Joe Studer 0 Reputation points
commented 2025-06-13T17:34:51.84+00:00
Marley Newell 0 Reputation points
1 answer One of the answers was accepted by the question author.

Help with Solver through Excel for a test about profit

I am trying to use the Solver extension in my Excel to run through a test to gain the best profit but it isn't working. I've included a picture that shows the info I needed to include on the right, what I had put into the solver in the middle, and the…

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,931 questions
asked 2025-06-12T21:12:41.16+00:00
Emrsn 20 Reputation points
accepted 2025-06-13T13:39:16.5+00:00
Emrsn 20 Reputation points
1 answer

I have been chased for payment but this was paid in April, unable to access Excel etc

I had paid my Microsoft standing order by PayPal in August this year and unable to access Excel, as it is saying that my payment is still outstanding therefore unable to access any of the Microsoft modules. Admittedly I rarely use Microsoft products.

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,931 questions
asked 2025-06-11T07:49:02.93+00:00
Philip Cunnington 5 Reputation points
commented 2025-06-12T23:19:15.36+00:00
Gabriel-N 1,015 Reputation points Microsoft External Staff Moderator
1 answer

How to add vba to my team from excel?

Sub CapNhatCotI() Dim wsTongHop As Worksheet Dim wsWebChinh As Worksheet Dim lastRowTongHop As Long Dim lastRowWebChinh As Long Dim i As Long Dim dictI As Object Dim key As String Dim valueHTML As String ' Xác d?nh các sheet Set wsTongHop =…

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,931 questions
asked 2025-06-09T09:48:40.2333333+00:00
Khánh Hoà Nguyễn Lê 5 Reputation points
commented 2025-06-12T23:10:55.1566667+00:00
Gabriel-N 1,015 Reputation points Microsoft External Staff Moderator
0 answers

Worksheet id changed after save excel on desktop

Problem Statement : We are working on Microsoft add-in AM365. In this Add-in we have consolidated data of all the sheets and user can manipulate the data (update , delete , insert) in grid format. When we save the data in excel we store worksheetId at…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,176 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,366 questions
asked 2024-01-30T15:12:55.91+00:00
Vipin Bhandari 0 Reputation points
commented 2025-06-12T14:03:23.8566667+00:00
Amanda 0 Reputation points
1 answer

Exporting Test Questions from Excel to Microsoft Forms

Hi everyone, I'm currently working on creating a set of test questions for a course, and I've compiled them in an Excel spreadsheet. I'd like to know if there's a way to efficiently export these questions from Excel to Microsoft Forms. Is there a…

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,770 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,176 questions
asked 2023-08-10T17:04:05.4566667+00:00
Michael Soto 5 Reputation points
commented 2025-06-12T06:29:23.4533333+00:00
SambitMishra-5107 0 Reputation points
13 answers

Error Another account from your organization is already signed in on this device. Try again with a different account.

Hello, I keep getting the error - "Error Another account from your organization is already signed in on this device. Try again with a different account." I've been trying to use all of the tips, tricks, and fixes available online, but nothing…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
960 questions
OneNote
OneNote
A family of Microsoft products that enable users to capture, organize, and reuse notes electronically.
231 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,894 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,176 questions
asked 2023-02-17T17:42:05.4166667+00:00
Sarah Nelson 85 Reputation points
commented 2025-06-11T07:23:23.72+00:00
sanjay b 0 Reputation points
1 answer

comparing two sheets

I need to compare data in two sheets for differences. If any value in Sheet "Drive" column C is not found in sheet "daily" column a, I want it to highlight yellow. And if any value in sheet "daily" column A is not found in…

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,931 questions
asked 2025-05-30T11:52:56.73+00:00
JH 0 Reputation points
commented 2025-06-11T03:54:08.3566667+00:00
Dora-T 850 Reputation points Microsoft External Staff Moderator
2 answers

How to set up conditional formatting for 30 days, 60 days and 1 year before expiry?

Hi. I am trying to set conditional formatting for two separate columns in Excel. Hopefully I explain this well enough. The first is for vehicle tag expiration dates and I need to set the formatting for the following Turn yellow 60 days before…

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,931 questions
asked 2025-06-05T17:51:53.8766667+00:00
HI34 5 Reputation points
commented 2025-06-11T03:40:37.03+00:00
Dora-T 850 Reputation points Microsoft External Staff Moderator
1 answer

HOW TO CONVERT JSON TO EXCEL

I need to convert data from Json to excel . I have noticed that there is no option of convertion of Json to excel in my window 11 . I had a chat support with the team and he was not able to solve my issue and said to esclate to the Tech. team . …

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,931 questions
asked 2025-06-04T14:21:36.49+00:00
kedar bvb 5 Reputation points
commented 2025-06-11T03:39:16.43+00:00
Dora-T 850 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Excel office script to work with pivot table connecting to tabular olap cube?

I have a vba script to update all pivot table filters at once. All pivot tables in the Excel file are connecting to azure tabular olap cube. The vba script is working fine. I am trying to use the office script to do the same tasks with no luck. Even try…

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,931 questions
asked 2025-06-06T12:20:37.6066667+00:00
Wang, Wenchi 20 Reputation points
accepted 2025-06-09T12:04:10.0533333+00:00
Wang, Wenchi 20 Reputation points
1 answer

Can I have a dropdown list and original data in the same cell?

I have a dropdown list in a cell to choose the frequency of an action. My dropdown has Weekly, Bi-Weekly, Monthly, Quarterly, Semi-Annually, and Annually. Some users want to be able to add their own frequency. Can I have a dropdown with choices, but…

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,931 questions
asked 2025-06-01T19:45:00.55+00:00
Tugboat Business Solutions 0 Reputation points
commented 2025-06-09T02:16:46.6333333+00:00
Dora-T 850 Reputation points Microsoft External Staff Moderator
0 answers

windows 8 den windows 10 a geçerken hata veriyor nasıl düzeltebilirim

windows 8 den windows 10 a geçerken hata veriyor nasıl düzeltebilirim

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,931 questions
asked 2025-06-08T08:19:03.0233333+00:00
berat aydın 0 Reputation points
2 answers One of the answers was accepted by the question author.

How to fix copy and cut features to clipboard

, when I copy or cut in excel a pop up appears saying (We could not copy the content to the clipboard, it is in use by another application. You can still paste your content within this workbook but it will not be available in other applications). Then…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,918 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,176 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
11,803 questions
asked 2023-10-08T15:38:25.2833333+00:00
andrea france 45 Reputation points
answered 2025-06-08T07:37:15.0666667+00:00
Phynix 0 Reputation points
1 answer

Additional Rankif

Hello, Additional formula of Rankif in excel. Thank you…

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,931 questions
asked 2025-06-07T18:45:23.7066667+00:00
DAISY ROSE ORDONEZ 0 Reputation points
answered 2025-06-08T03:11:52.9866667+00:00
Barry Schwarz 3,746 Reputation points
1 answer

Ratings and Reviews Not Visible Inside Excel Store

Hello, We have published a new add-in, AI Agent for Excel. We noticed that the ratings and reviews submitted by users are visible on the AppSource web page: https://appsource.microsoft.com/en-us/product/office/WA200008627?tab=Overview However, they do…

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,931 questions
asked 2025-06-01T20:35:49.98+00:00
Tie CHENG 16 Reputation points
commented 2025-06-06T04:51:26.35+00:00
Dora-T 850 Reputation points Microsoft External Staff Moderator