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

Sort by: Updated
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
answered 2026-10-05T16:23:41.2+00:00
Jay1 Tran 1,460 Reputation points Independent Advisor
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 an answer 2026-10-05T15:45:39.69+00:00
Lin v 1,545 Reputation points Independent Advisor
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-05T14:49:34.16+00:00
Julie Huynh 3,770 Reputation points Independent Advisor
2 answers

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 450 Reputation points
edited an answer 2026-10-05T14:44:18.9633333+00:00
Aetherin 2,505 Reputation points Independent Advisor
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 450 Reputation points
accepted 2026-10-05T13:25:45.46+00:00
Chaturvedi, Santosh 450 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 450 Reputation points
accepted 2026-10-05T09:19:42.58+00:00
Chaturvedi, Santosh 450 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,330 Reputation points Independent Advisor
3 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-05T08:37:27.3933333+00:00
Michelle Nguyen 1,835 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 450 Reputation points
commented 2026-10-05T07:59:48.84+00:00
Liora 2,080 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,460 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,505 Reputation points Independent Advisor
5 answers

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 40 Reputation points
answered 2026-10-04T06:52:15.2466667+00:00
IlirU 2,651 Reputation points Volunteer Moderator
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 1,890 Reputation points Independent Advisor
2 answers

When starting Excel, last a few seconds then docto disappear

Start a new Excel document; Excel opens a new doc for you; then it disappears in a few seconds (en empty doc is generated and stored in the default folder) Open a previous Excel document; Excel opens the already existing doc for you to edit; then it…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-02T18:55:41.9566667+00:00
Julian Martinez 0 Reputation points
commented 2026-10-03T22:50:36.5166667+00:00
Chris-D 1,690 Reputation points Independent Advisor
4 answers One of the answers was accepted by the question author.

Microsoft Forms 2.0 dll, download

Hi, can I ask you for to be able to download the Microsoft Forms 2.0 dll, pls? Thanks for your answer, János Kóti

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-07-14T11:01:22.26+00:00
Kóti János 25 Reputation points
edited an answer 2026-10-03T18:13:49.8+00:00
Hakan Yılmaz 0 Reputation points
2 answers

The copy feature stopped working in Excel

For the last two weeks, the copy feature has stopped working in Excel. I can't copy and paste anything, not even copy a sheet to a new sheet, nothing appears when it's supposed to copy. I can coy and paste special, but then I lose all the formatting. …

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-02T14:07:42.4733333+00:00
Maureen Hanson 0 Reputation points
commented 2026-10-03T12:48:35.5666667+00:00
Roebe Ta 1,545 Reputation points Independent Advisor
4 answers One of the answers was accepted by the question author.

Excel table (The table feature within excel) column headers, vs. Excel the product's column headings getting jumbled

This is a tricky question, not the usual "how to create an excel table", but an annoying problem I can't figure out. Look closely at the screenprint. Both are Excel tables, the second a copy paste of the first, into different tabs of the…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-09-25T15:08:27.51+00:00
J M 40 Reputation points
answered 2026-10-03T12:32:27.46+00:00
J M 40 Reputation points
3 answers

I have a cell with data that is named total with data in another cell and I need this data in this cell to move to another cell with a formula

Cell name TOTAL - Values are in cell j40 and I need to move it to cell k34. Can this be done for all cells that have a name called TOTAL.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-01T10:03:10.3966667+00:00
Jackie SOARES 0 Reputation points
answered 2026-10-02T22:50:50.7733333+00:00
Barry Schwarz 6,191 Reputation points
3 answers

If I cancel my Office 365 how do I retain my use of word, excel, etc?

I want to know how I can retain use of word, excel if I cancel my Office 365 monthly subscription.

Microsoft 365 and Office | Excel | For business | Windows
asked 2020-11-06T23:04:21.92+00:00
Darren Marks 1 Reputation point
commented 2026-10-02T20:04:51.02+00:00
Vivian Mueller 0 Reputation points
1 answer

Office Scripts loses workbook association despite remaining accessible and executable by owner

During failure periods, Office Scripts are removed from the workbook's associated script list and worksheet buttons cease functioning. The workbook reports that the script has been unshared. However, the script itself remains accessible under Recent…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-02T16:07:04.5066667+00:00
Monica Bell 0 Reputation points
answered 2026-10-02T17:22:02.86+00:00
Dante Vo 0 Reputation points Independent Advisor