21,053 questions with Microsoft 365 and Office | Excel | For business | Windows tags

Sort by: Updated
5 answers One of the answers was accepted by the question author.

totals for specific dates formula

Hello! I have been trying to figure out a way to pull specific dates for the month into a totals column but have not been able to figure out a formula that works. I keep getting a #value error. I've tried sumproducts, filter, etc. I want to add the…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-01T14:14:24.41+00:00
Megan F 60 Reputation points
edited an answer 2026-10-08T00:41:08.5966667+00:00
Dana D 100 Reputation points
2 answers

XLOOKUP help

I have a master data tab called “Master FOF” and then one tab for each month of the year. I would like the data from Master FOF to be pulled into the month tabs by matching the names in column A on both tabs (the names match) and the fiscal year month…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-07T21:06:59.61+00:00
Megan F 60 Reputation points
answered 2026-10-08T00:24:07.3033333+00:00
Barry Schwarz 6,191 Reputation points
2 answers

STOP READ ONLY ON ALL EXCEL FILES

SOME EXCEL FILES CHANGED TO READ ONLY. HOW CAN I MAKE THOSE FILES NOT READ ONLY AND HOW I DO I PREVENT FILES BEING CONVERTED TO READ ONLY

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-06T19:21:54.78+00:00
Alan Phillips 0 Reputation points
commented 2026-10-07T19:39:57.7966667+00:00
Ryan-N 16,105 Reputation points Microsoft External Staff Moderator
2 answers

excel saying i cant access file i created

trying to access a file i just created and excel saying i dont have access

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-07T18:37:30.3533333+00:00
SVDP FoodPantry 0 Reputation points
answered 2026-10-07T18:46:37.8166667+00:00
Lin v 1,550 Reputation points Independent Advisor
2 answers

Excel will not run

I launched Excel, but after the small "Starting" window appeared, it did not run normally. I am using Windows 11, MS 365 (Business license). The same symptoms occurred even when running in standard mode after disabling and deleting add-ons via…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-08-14T06:37:44.3233333+00:00
Carter Lena 0 Reputation points
commented 2026-10-07T13:32:31.9933333+00:00
sid risner 0 Reputation points
4 answers

COPY/PASTE not working on Excel 2016

Hi, Just informing you there's some bugs disabling copy/paste on Excel STD 2016 since last Office updates from today 09/09/26. It worked fine yesterday on all computers. Hoping some fix coming soon for Excel 2016 users. Have a nice day.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-09-09T11:34:18.2266667+00:00
Vincent CAZENAVE 25 Reputation points
edited a comment 2026-10-07T12:28:47.91+00:00
Choudhary Umar 0 Reputation points
1 answer One of the answers was accepted by the question author.

Excel Version 2508 Broke Pivot Table Filtering Functionality

Users are getting the following error when trying to filter on a pivot table after update, but was working fine before: "This PivotTable report is invalid. Try Refreshing the data (On the Analyze tab, click Refresh).". Is there a fix for this…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-09-02T21:25:59.2633333+00:00
Travis Mills 35 Reputation points
commented 2026-10-07T09:34:02.8133333+00:00
Gowthaman Vetrivel 0 Reputation points
5 answers

FREEZING SCREEN PROBLEM IN MICROSOFT EXCEL 2024 LSTC 17392.21000

Sometimes, when working in Excel 2024 LSTC , switching between sheets causes the colors and headers to disappear or no longer display correctly. Using the Filter tool can also make all open Excel files become unresponsive, leaving only the options to…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-05T07:21:16.5366667+00:00
Mohsen Safari 0 Reputation points
answered 2026-10-07T06:51:25.2333333+00:00
Mohsen Safari 0 Reputation points
2 answers

Excel closed on its own and my progress wasn't autorecovered

I turned away to talk to a coworker with several excel sheets open and my unsaved sheet I'd been working on for hours closed. Specific complaints: Excel randomly closed Can't access auto-recover sheets from Excel home, have to open a random sheet to…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-05T15:34:21.72+00:00
Dan Gilmour 0 Reputation points
commented 2026-10-06T22:57:01.0333333+00:00
Jay1 Tran 1,700 Reputation points Independent Advisor
3 answers One of the answers was accepted by the question author.

editing text in text box in web browser, not in desktop version

I cannot update/edit a textbox on a web browser version?  i tried to add a few morecharacters and i got the message to use the desktop version. 

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-06T06:55:46.7166667+00:00
Yoshimi Amos 20 Reputation points
accepted 2026-10-06T17:29:28.56+00:00
Yoshimi Amos 20 Reputation points
2 answers

How fix to copy and paste in excel

I am unable to copy and paste in excel and would like to know how to fix this.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-05T15:24:16.9733333+00:00
Allen Banner 0 Reputation points
edited a comment 2026-10-06T16:52:59.66+00:00
Lin v 1,550 Reputation points Independent Advisor
3 answers One of the answers was accepted by the question author.

Add addtional formulation in FILTER formula

I filter the data by this formula =FILTER('[Fatigue Assesment_as per 17949_Welded Joints.xlsm]S1'!$E$1466:$F$2065, (BYROW('[Fatigue Assesment_as per 17949_Welded Joints.xlsm]S1'!$E$1466:$E$2065, LAMBDA(r, SUM(r)>0))),"N") I want to delete…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-09-09T12:10:07.17+00:00
Chaturvedi, Santosh 610 Reputation points
edited an answer 2026-10-06T08:07:16.0833333+00:00
Daniel-Vo 6,695 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Macro modify

I want to change this macro so that the liste generted in Data File -- Cell F5 to end sall align in left Sub CopyAndListSheets() Dim wsData As Worksheet Dim wsTemplate As Worksheet Dim wsNew As Worksheet Dim copyAfter As Worksheet Dim cell As…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-05T14:18:24.9233333+00:00
Chaturvedi, Santosh 610 Reputation points
accepted 2026-10-06T07:25:01.7366667+00:00
Chaturvedi, Santosh 610 Reputation points
1 answer One of the answers was accepted by the question author.

Modify macro so that ithe liste contents shall reformated to its left side

Can u modify the below macro so that the final liste in F20 shall be placed at right side of the table.. Sub CopyAndRenameSheets() Dim wsDash As Worksheet Dim wsTemplate As Worksheet Dim wsNew As Worksheet Dim wsInsertAfter As Worksheet Dim lastRow…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-05T11:01:44.9033333+00:00
Chaturvedi, Santosh 610 Reputation points
accepted 2026-10-05T13:25:45.46+00:00
Chaturvedi, Santosh 610 Reputation points
2 answers One of the answers was accepted by the question author.

MAcro to calculate : (F6=(C6+E6)/2

I have req. I have one front sheet name "DB Collectives". This sheet have liste of hyperlinked sheet written from cell C4 to its end. The macro shall go to each sheets name mentioned in "DB Collectives" in step 1 Then, It should…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-05T08:42:04.4466667+00:00
Chaturvedi, Santosh 610 Reputation points
accepted 2026-10-05T09:19:42.58+00:00
Chaturvedi, Santosh 610 Reputation points
2 answers

The Excel application is crashing frequently while using or running macros written in VBA and Power Query.

The Excel application is crashing frequently, and we have not yet been able to determine the cause. Event Viewer does not capture logs for every crash. However, we were able to collect the Event Viewer details below for some of the crash incidents.…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-09-30T11:54:48.1466667+00:00
Kumar, Shiva 0 Reputation points
commented 2026-10-05T09:14:36.1533333+00:00
Demi Nguyen 2,495 Reputation points Independent Advisor
2 answers

how to load the power query table into existing work cell without adding any columns

how to load the power query table into existing work cell without adding any new columns

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-02T12:19:46.1666667+00:00
Chaturvedi, Santosh 610 Reputation points
commented 2026-10-05T07:59:48.84+00:00
Liora 2,090 Reputation points Independent Advisor
2 answers One of the answers was accepted by the question author.

Issue with Excel links to .doc format Word documents

Hey all. I came across an issue where I have a user that is on Office 2019 16.0.10417.20208, and we have an Excel spreadsheet that contains links to Word documents. During testing, I found that if those Word documents had just text, the links would…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-09-30T16:00:55.1066667+00:00
J. Stephen 20 Reputation points
commented 2026-10-04T21:39:17.6466667+00:00
Jay1 Tran 1,700 Reputation points Independent Advisor
2 answers

Microsoft Visual Basic, Run Time Error '-2146697211 (800c0005), The system cannot locate the resource specified.

Respected Microsoft Team, I have been facing an error while upgrading the Automatex license key in Excel 365. The Error is "Microsoft Visual Basic, Run Time Error '-2146697211 (800c0005), The system cannot locate the resource specified." This…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-02T14:42:07.4566667+00:00
Chandra Sekhar Barik 0 Reputation points
commented 2026-10-04T07:20:19.2566667+00:00
Aetherin 2,910 Reputation points Independent Advisor
2 answers

We couldn't find a work or school account with that email address

Had work office installed at one time. Have moved on from that job. I have uninstalled office and restarted then logged in with my personal office 365 account and installed office from that page. It always says, "We couldn't find a work or…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-02T16:00:10.28+00:00
Matt Mills 0 Reputation points
commented 2026-10-04T03:10:19.68+00:00
Elena-VH 2,130 Reputation points Independent Advisor