20,652 questions with Microsoft 365 and Office | Excel | For business | Windows tags

Sort by: Updated
3 answers

Excel 365 Desktop version crashes when opening files directly from Edge

Hi Team, Currently, on my organization's laptop, I am using the M365 application. I frequently use the Excel 365 application. I have observed that many a times the Excel 365 application crashes and only shows the blank screen without the cells and the…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-10T18:35:03.3733333+00:00
Mohit Bansal 0 Reputation points
commented 2026-06-12T22:06:54.0133333+00:00
Kristen-L 13,260 Reputation points Microsoft External Staff Moderator
2 answers

How To Copy / Paste Multiple Data "Blocks" Using Paste Special / Transpose - Need Advice

Hello, Excel Community... I've got a situation that hopefully someone can direct me on. The scenario: Column A represents 2 lines (in this test) from a 3rd-party program - hence, two "data blocks" for lack of a better term. For each line /…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-12T16:31:45.6366667+00:00
Infoman 0 Reputation points
edited a comment 2026-06-12T21:27:34.2333333+00:00
Kai-L 14,210 Reputation points Microsoft External Staff Moderator
2 answers

how can is stop security blocks from my excel

secu security risk is blocking me from doing some work so i work like to remove it or stop it

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-12T20:31:36.03+00:00
BATALA UMAR 0 Reputation points
edited the question 2026-06-12T21:23:05.3366667+00:00
Ian-Ng 13,690 Reputation points Microsoft External Staff Moderator
2 answers

Filter formula with address of range data

I want to link the address in of sheet by one cell in following filter formula =FILTER( 'Q:\Presentations\PE_31\O_Analysis and calculation\Fatigue[DB_Data_Collectives_1.xlsx]3365'!TABLE_S3365, (BYROW( 'Q:\Presentations\PE_31\O_Analysis and…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-12T18:07:37.0066667+00:00
Chaturvedi, Santosh 20 Reputation points
edited an answer 2026-06-12T19:59:18.9733333+00:00
Ian-Ng 13,690 Reputation points Microsoft External Staff Moderator
2 answers

Hyperlink the address from one work book tpo other in excel

Hello I have requirement as mentioned below.. I have one work book sheet with list of hyperlinked cell in one table. This hyperlinked table shown above is copied and pasted in separate work book excel sheet. shown below In this work book i have…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-12T17:12:40.5666667+00:00
Chaturvedi, Santosh 20 Reputation points
answered 2026-06-12T19:20:51.2866667+00:00
Kai-L 14,210 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Remove "Quick Access" Locations in Open

How do I remove "Quick Access" locations from the left pane of Excel's Open dialog box? I know how to pin locations, but my favorites only appear in 'Show More,' where pinning isn't an option.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-10T20:34:14.66+00:00
Al LaCroix 0 Reputation points
commented 2026-06-12T18:34:08.99+00:00
Ryan-N 13,740 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

How do I turn off speak cells in Excel?

The Speak Cell on Entry and Stop Speaking buttons will not turn it off.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-11T23:45:15.49+00:00
Reg 20 Reputation points
commented 2026-06-12T17:02:16.8233333+00:00
Reg 20 Reputation points
2 answers

VLOOKUP trolls me in work

Hi folks, I am doing data analysis (massive one) using VLOOKUP thru multiple files, the file was saved under company One Drive. I completed the analysis on 6:22pm and my superior access the file on 9:38pm later on her laptop. She feedback to me that the…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-09T06:05:59.2166667+00:00
Heyyooooooooooooo 0 Reputation points
edited a comment 2026-06-12T16:42:04.3366667+00:00
Alina Le 2,455 Reputation points Independent Advisor
1 answer

hyperlinks in excel

how do i enable hyperlinks in an excel spread sheet.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-12T16:08:06.4366667+00:00
Alan Poe 0 Reputation points
answered 2026-06-12T16:35:49.12+00:00
Ryan-N 13,740 Reputation points Microsoft External Staff Moderator
3 answers

every excel open read only

when some share me excel file then in my excel showing read only whenever sender already given access to me for edit. i reinstalled the office and repair the office. also i reinstall the os win 11 25 h2. however i facing same issue please guide how to…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-11T11:01:39.47+00:00
FMS Pune 0 Reputation points
edited an answer 2026-06-12T15:10:24.9833333+00:00
Senthil kumar 680 Reputation points
1 answer One of the answers was accepted by the question author.

#VALUE! error in excel when trying to find the difference between 2 date/time cells

Hello, I am trying to calculate the work duration (in mins) for a job. The following snippet shows selected rows for Cols K:M. The formula in Col K & L are using text and concat functions to create a date and time cell. Col M is simply calculating…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-10T21:11:27.8633333+00:00
Shams Mahmud 80 Reputation points
commented 2026-06-12T15:06:48.2166667+00:00
Shams Mahmud 80 Reputation points
2 answers

How to format data in a formula bar for Concatenate in MS Excel

How to format data in a formula bar for Concatenate in MS Excel E.g. ?

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-12T11:31:18.88+00:00
Mamiky Leolo 0 Reputation points
edited an answer 2026-06-12T12:07:16.64+00:00
Tamara-Hu 16,030 Reputation points Microsoft External Staff Moderator
3 answers

Excel does not copy images when moving sheet to another workbook

I spent some time today creating some annotated images in Excel. I was worried I would lose the work I had done so I dragged the sheet into an existing workbook to save it there. Once I had moved it, the images and annotations I had made on them using…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-05T10:36:58.2133333+00:00
Rob 25 Reputation points
commented 2026-06-12T10:31:11.85+00:00
Senthil kumar 680 Reputation points
1 answer

Matching index to populate value

I am having issues on my formula for Column A. I want the column to return yes if there is a value in the intersect of I2:H5, return no if there is no values (cell blank), and return N/A if the match doesn't exist. Cell A5 is returning yes, but the…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-11T13:59:02.42+00:00
Mel S 0 Reputation points
commented 2026-06-12T10:05:41.1966667+00:00
Rin-L 21,270 Reputation points Microsoft External Staff Moderator
2 answers

Microsoft blocking Excel macros

"Microsoft" has suddenly decided to block macros on all my Excel files -- files that I created! I've tried every fix suggested by the Microsoft website and Chat GPT. Nothing is working!

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-11T12:10:29.2333333+00:00
Bob Kobistek 0 Reputation points
commented 2026-06-12T10:02:41.1933333+00:00
Rin-L 21,270 Reputation points Microsoft External Staff Moderator
2 answers

How to Fix Issues with Sensitivity Labels Applied to Macro-Enabled Excel Files on Windows 11 After a Windows Update?

We applied sensitivity labels to macro-enabled Excel files in April, and they worked without issues initially. However, after a Windows update, some devices began freezing, causing users to experience problems while working with these files. Till now we…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-11T06:55:30.4933333+00:00
Rimple Kaul 0 Reputation points
commented 2026-06-12T09:57:57.38+00:00
Rin-L 21,270 Reputation points Microsoft External Staff Moderator
2 answers

Dupicate sheet with new name which is as per master list.

Hello -- There is one requirement that i have to duplicate this sheet 30 times criteria as shown below.. I have to duplicate this sheet S1....> 30 times. The content of S1 sheet shall remain same for all 30 sheet The name of the new sheet shall be…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-12T07:11:05.4766667+00:00
Chaturvedi, Santosh 20 Reputation points
edited an answer 2026-06-12T07:56:28.7666667+00:00
Henry-N 13,980 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Automatically making individual tables in Excel

Hi there, Below (Image 1) is a draft excel spreadsheet with random figures that I generate from the payroll system at work. Is there a way to automatically create a table for each employee that is formatting like 'Image 2'? Image 1: Image 2: …

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-12T01:29:21.21+00:00
Sam 40 Reputation points
edited the question 2026-06-12T05:55:22.22+00:00
Darren-Ng 11,100 Reputation points Microsoft External Staff Moderator
3 answers

Run-time error '1004': Application-defined or object-defined error

Open Excel and it said: Run-time error '1004': Application-defined or object-defined error Please help solve this.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-07T06:13:56.4833333+00:00
Chris Metrics 0 Reputation points
commented 2026-06-12T04:18:40.52+00:00
Vivian-HT 16,935 Reputation points Microsoft External Staff Moderator
3 answers

The "Total Row" within the "Table Design Options" box is greyed out and not clickable.

I am requesting urgent help with the table design tab for my work project. For the past several days, I have tried to go online, use so forth to figure out why the "Total Row" within the "Table Design Options" box is greyed out and…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-10T19:12:46.5466667+00:00
Ingrid Horbatenko 0 Reputation points
commented 2026-06-11T23:00:19.32+00:00
Hendrix-C 17,490 Reputation points Microsoft External Staff Moderator