1,533 questions with Excel tags

Sort by: Updated
1 answer

how do I change the language on my Microsoft apps?

My Microsoft word and excel changed to Spanish - how can I fix that?

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
692 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 questions
asked 2024-05-22T18:21:27.08+00:00
HelenLopez-0830 0 Reputation points
answered 2024-05-23T07:40:34.12+00:00
Jiajing Hua-MFST 5,710 Reputation points Microsoft Vendor
0 answers

Excel crashes when opening a macro enabled excel file intermittently

I have an issue with a macro enabled excel file crashing intermittently. The file starts as a blank template for users to add data, sheets and images to. They can make copies of the template file. But every so often we run into an issue with certain…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 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.
3,578 questions
asked 2024-05-22T17:58:37.35+00:00
Patrick 0 Reputation points
edited the question 2024-05-23T07:24:04.6+00:00
Emi Zhang-MSFT 22,396 Reputation points Microsoft Vendor
2 answers

Why is my multiplication formula in Excel giving me a time and not a ?

I'm working through Project 1 of the Excel training linked here within the Course Materials. I'm on section "4.1.1 Insert relative, absolute, and mixed references" Within the Educator Materials, it provides instructions on how to complete the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 questions
asked 2023-08-02T00:44:48.6466667+00:00
Preston Williams 0 Reputation points
answered 2024-05-23T05:11:21.5333333+00:00
Ayomide Rilwan 0 Reputation points
1 answer

Why are my Ctrl - and Ctrl + shortcuts (delete and insert cells) not behaving properly

I have multiple versions of the same file. I thought that the latest ones got corrupt at some point and Ctrl - wasn't working. All it did was delete the cell contents instead of deleting the cells. So i started testing for the latest non corrupt file and…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 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,657 questions
asked 2024-05-20T06:00:19.39+00:00
Abhinav Jain 0 Reputation points
commented 2024-05-23T04:49:55.31+00:00
Abhinav Jain 0 Reputation points
1 answer

Practice tests for MO-110 and MO-210

Hello, I plan on studying for the certification exams MO-110 and MO-210. Where can I find free practice exams for these? Also, I have already practiced for MO-110 using the practice files by Microsoft but could not find anything for the Excel exam…

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.
3,949 questions
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
692 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,353 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 questions
asked 2024-05-22T11:24:52.9966667+00:00
Aparajita Mahajan 0 Reputation points
answered 2024-05-23T02:12:13.9666667+00:00
Emi Zhang-MSFT 22,396 Reputation points Microsoft Vendor
0 answers

How do I resolve vba error 1004 when trying to autofill using a variable for dynamic range?

I get error 1004 on this line of Excel vba code and don't know how to resolve. Selection.AutoFill Destination:=Range("R2:R" & lastRow) Dim wb As Workbook Dim ws As Worksheet Set wb = ActiveWorkbook Set ws =…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 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.
3,578 questions
asked 2024-05-22T20:00:40.64+00:00
Alley, Ann 0 Reputation points
edited the question 2024-05-23T01:06:02.09+00:00
Jiajing Hua-MFST 5,710 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

Excel document in shared server folder, opened by another user

Good morning, I wanted to ask if any of you have ever encountered the following problem. If a colleague opens an excel document, which is on a shared folder on a file server, the following error appears: File in use Open Read Only or click Notify to…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,353 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,274 questions
asked 2024-05-21T11:30:01.57+00:00
Gilbert Mani 0 Reputation points
commented 2024-05-23T00:21:14.17+00:00
Emi Zhang-MSFT 22,396 Reputation points Microsoft Vendor
0 answers

Programmatically read restricted excel file

I have a series of Excel's that are protected by the business. I have the required permissions to view the file manually however I would like to create a programmatic way to extract the data from these excels. I have tried using Python to read and…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 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.
3,578 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,657 questions
asked 2024-04-05T11:44:17.3133333+00:00
Rando 5 Reputation points
commented 2024-05-22T15:18:53.94+00:00
DANIEL COHEN 0 Reputation points
2 answers One of the answers was accepted by the question author.

In Excel, my developer tab is missing from my bar

The Developer tab where I go to my macros is missing. It was there yesterday and now it's gone. How do I get that back?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 questions
asked 2024-05-21T13:14:39.3333333+00:00
Michelle Chambers 20 Reputation points
accepted 2024-05-22T14:33:01.8833333+00:00
Michelle Chambers 20 Reputation points
2 answers

Error 53 - how to fix

Brand new Mac mini purchased today - installed Office 365 with my work credentials and met with this on start-up

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
692 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,353 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 questions
asked 2024-03-25T07:25:05.7533333+00:00
MS 0 Reputation points
commented 2024-05-22T09:16:58.7666667+00:00
Priyanshu Agarwal 0 Reputation points
1 answer

Files that are encrypted through the sensitivity label.

Hello    Please i need your help on this issue.    The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files   I've opened the Excel file on my MAC that is in my downloads folder. This issue looks to be on all files…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 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,657 questions
asked 2024-05-16T18:58:07.4566667+00:00
Iniobong Nkanga 1,681 Reputation points
commented 2024-05-22T08:31:07.1366667+00:00
Jiajing Hua-MFST 5,710 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Bad Request - Request Too Long, when inserting image in header

When I try to insert an image in header o footer, in Excel, the folloing image pops Up: "Bad Request - Request Too Long HTTP Error 400. The size of the request headers is too long."

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 questions
asked 2024-03-29T17:18:45.4266667+00:00
Fernando Gonçalves 20 Reputation points
commented 2024-05-22T07:38:37.94+00:00
Maja Pesrl 0 Reputation points
1 answer

How do I prevent emf, dat and tmp files creation when printing out excel files?

I made a program that runs multiple printers and print out a lot of materials a day - more than 3,000 sheets. As long as I know, the emf, dat and tmp files are all the temporary files that should be deleted after the task is over but somehow, these…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 questions
Windows Server Printing
Windows Server Printing
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Printing: Printer centralized deployment and management, scan and fax resources management, and document services
646 questions
asked 2024-05-21T09:03:29.4666667+00:00
moxnox63 0 Reputation points
answered 2024-05-22T06:31:03.3033333+00:00
Emi Zhang-MSFT 22,396 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

some questions about Microsoft Barcode Control 16.0 in excel

Is the QR codes made by Microsoft Barcode Control 16.0 always valid or is there a time limit?Can QR codes be scanned unlimitedly? Or does it become invalid after a few scans?

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.
3,949 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 questions
asked 2024-05-21T08:10:40.2666667+00:00
Meng, Biyan (B.) 20 Reputation points
accepted 2024-05-22T02:37:27.9566667+00:00
Meng, Biyan (B.) 20 Reputation points
2 answers

Sharepoint Validation for Multiple Actions and Multiple Target Dates

I have a list that comprising of 6 Action columns that when they have a text entry a corresponding Target column then requires a mandatory Target date. These work for the Action and Target but I can't get the formula for more than once action. …

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,842 questions
asked 2024-05-21T12:14:47.6533333+00:00
Dancer 0 Reputation points
answered 2024-05-22T01:46:19.7+00:00
AllenXu-MSFT 16,721 Reputation points Microsoft Vendor
0 answers

Excel script executable by button in workbook once only once, but fails with an error "the button cannot run since the script was unshared. Contact the owner to share it again" when clicked twice.

Created an excel script, and added a button to the excel workbook. This script is owned by and linked to my account. But since the workbook is accessible to my whole organisation, people are able to execute this script by using the button added. While…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,353 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 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.
3,578 questions
asked 2024-05-07T08:47:24.0733333+00:00
Anshal Mukesh Lad 5 Reputation points
commented 2024-05-21T14:37:25.8866667+00:00
Anshal Mukesh Lad 5 Reputation points
1 answer 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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 questions
asked 2024-05-17T12:10:10.9733333+00:00
Kirsten Affleck 25 Reputation points
commented 2024-05-21T13:55:55.0833333+00:00
Kirsten Affleck 25 Reputation points
4 answers

How to fix error AADSTS500200: User account is a personal Microsoft account. Personal Microsoft accounts are not supported for this application

Sorry, but we’re having trouble signing you in. AADSTS500200: User account 'su*****sk@gmail.com' is a personal Microsoft account. Personal Microsoft accounts are not supported for this application unless explicitly invited to an organization. Try signing…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,353 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,818 questions
asked 2024-01-03T10:26:38.1066667+00:00
sumit 10 Reputation points
answered 2024-05-21T12:16:08.1766667+00:00
Aleksej Skuza 16 Reputation points
0 answers

Formula for highlighting overdue date (or days from due date) from varying due dates

Hi I am trying to creadte a spreadsheet to monitor document reviews and to highlight when a document review is overdue. However documents are reviewed at different dates and I don't have the review dates for each document as yet as this will vary across…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 questions
asked 2024-05-20T23:49:06.3333333+00:00
Madelyn Ridgway 0 Reputation points
commented 2024-05-21T08:20:51+00:00
Emi Zhang-MSFT 22,396 Reputation points Microsoft Vendor
0 answers

Excel 16.85 is having permission issues

Hello  Please i need your help on this issue.  The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files I am able to open the file while on 16.84 then when I update to the latest update 16.85 I would get the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,533 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,657 questions
asked 2024-05-20T20:32:55.65+00:00
IBN 0 Reputation points
commented 2024-05-21T08:15:06.4633333+00:00
Emi Zhang-MSFT 22,396 Reputation points Microsoft Vendor