19,719 questions with Microsoft 365 and Office | Excel | For business | Windows tags

Sort by: Updated
2 answers

Copy data from cells on info sheet to cells on data sheet based on date.

20251128_141429.jpgSo, I have cycle counts on certain departments that need to be done on a weekly rotating schedule(52 weeks). I want to be able to type in "week 44" or an actual date would work, for example...and have it fill 5 rows on the…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-11-28T19:21:07.5166667+00:00
CASEY BRYANT 0 Reputation points
answered 2025-12-11T17:46:27.82+00:00
CASEY BRYANT 0 Reputation points
1 answer One of the answers was accepted by the question author.

Trying to Sort by two different columns while using the FILTER function.

I am currently sorting by one column (see below) and it is working as needed. =SORT(FILTER('Score Calculations'!B9:Q38,('Score Calculations'!E9:E38>44)*('Score Calculations'!F9:F38>44),""),16,-1) Here is the source sheet: Here is the…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T16:18:10.5166667+00:00
Wright, Paul@CHP 5 Reputation points
commented 2025-12-11T17:27:09.1666667+00:00
Hendrix-C 8,320 Reputation points Microsoft External Staff Moderator
1 answer

Editing in cell - Disable "Home" key closes cell when text first entered

This has been the default behavior forever, but my muscle memory from Word still has me struggling in Excel. I frequently use the Home key to move to the beginning of a line. In Word, it always performs that behavior the same. In Excel, if text if…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T17:14:39.0366667+00:00
Andrew Cecka 0 Reputation points
edited the question 2025-12-11T17:16:52.37+00:00
Andrew Cecka 0 Reputation points
2 answers

how to list names in a column in excel in a row

How can I take names listed in a column and paste them in a row?

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T16:19:53.3866667+00:00
Young, Kevin P 0 Reputation points
answered 2025-12-11T17:10:48.19+00:00
Hendrix-C 8,320 Reputation points Microsoft External Staff Moderator
2 answers

User intermittently can't open emailed Excel files on one specific computer

Good morning, I have a rather complicated issue that I'm try to fix without replacing the user's computer. This user receives emails with the same report in Excel a few times a week, but sometimes she gets the error "The operation failed". some…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-10T16:58:14.6566667+00:00
Chris Dalton 0 Reputation points
commented 2025-12-11T16:43:52.2+00:00
Ryan-N 8,245 Reputation points Microsoft External Staff Moderator
3 answers

How to record paste value in a macro without referencing a particular cell

I want to set up a macro that will add the current date/time to an already selected cell as a time stamp - the date or time will not update once it captures the current date and time. The macro should work on whatever cell has been selected.

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T12:48:06.79+00:00
Petrina O Donnell 0 Reputation points
answered 2025-12-11T16:26:08.08+00:00
Barry Schwarz 4,871 Reputation points
2 answers

Excel plugin - macro unblocking trouble

i'm using an excel plugin and trying to unblock a macro it created but when I go to Properties, General there is not "Security" option

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T15:51:27.78+00:00
Janet DeFrino 0 Reputation points
answered 2025-12-11T16:22:41.8633333+00:00
Hendrix-C 8,320 Reputation points Microsoft External Staff Moderator
0 answers

How to setup notifications for excel spreadsheet

Is there a way to setup to receive notifications when changes are made to an excel spreadsheet?

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T15:55:16.13+00:00
Moua, Vood 0 Reputation points
2 answers

“ERR_BLOCKED_BY_RESPONSE.NotSameOrigin / CORS Errors in Excel Online”

Hello, There seems to be a problem with pivot table in web excel. We're using Business Standard version of subscription. What errors we're getting in devconsole: Failed to load resource:…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-02T14:54:14.9166667+00:00
Mateusz Zajączek 0 Reputation points
commented 2025-12-11T15:41:37.8933333+00:00
Killian-N 6,720 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

I am trying to create a formula for if a cell is blank than do this but if not blank then do that.

This is what I have but it is not working, it comes up with a #VALUE. =IF(ISBLANK($O2), IF(ISBLANK($J2), "", TODAY()-$J2), IF(ISBLANK($J2), "", $O2-$J2)

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T15:29:23.58+00:00
Erin 0 Reputation points
accepted 2025-12-11T15:40:39.63+00:00
Erin 0 Reputation points
1 answer

How to create a Data Validation List that can be typed into

Hello all, I am looking for some support with creating Data Validation (combi Box). I am looking to understand how I can create a Drop Down List that allows me to type in and Auto-Fill. Then have the ability to select Enter or Tab and move to the…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T13:56:28.4266667+00:00
Chris Murray 0 Reputation points
commented 2025-12-11T15:01:43.42+00:00
Chris Murray 0 Reputation points
3 answers

Smart View is not downloading on my machine

I have tried multiple times to download Smartview and while the download works, its not showing up on excel. I look into add-ins and its not there either. Can you please help with a proper install?

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-09T14:25:03.77+00:00
Bodiwala, Nirali 0 Reputation points
answered 2025-12-11T14:52:47.5366667+00:00
Bodiwala, Nirali 0 Reputation points
2 answers

Issue Opening Embedded Excel Object in Word Document

Hello, I am experiencing an issue when trying to open or edit an embedded Excel object inside a Microsoft Word document. When I double-click the object, Word shows the following error: “The program used to create this object is Excel. This program is…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T12:57:25.5433333+00:00
Amrit Kaur 0 Reputation points
answered 2025-12-11T14:44:23.5866667+00:00
Nam-D 655 Reputation points Microsoft External Staff Moderator
2 answers

Spreadsheet Compare no longer is able to save results to exported Excel file

In our company we no longer can export results from "spreadsheet compare" to a new excel file or an existing excel file. No matter where the target file is located. Office: 2502 Build 18526.20660 (semi-annual channel) Windows 11 23H2 Build…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-05T12:27:25.63+00:00
Mokusch, Silvia 10 Reputation points
commented 2025-12-11T14:27:09.7833333+00:00
Phoebe-N 7,030 Reputation points Microsoft External Staff Moderator
2 answers

Recover Unsaved Data

I had autosave on the entire time I've had a file open. After I had my computer restarted, it deleted all of my data from today, 12/11, back to 11/12 and I wasn't aware of the change before I clicked off the recover tab when the file opened. Is there any…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T13:48:42.4166667+00:00
Humphreys, Nathan C 0 Reputation points
answered 2025-12-11T14:22:06.9733333+00:00
Phoebe-N 7,030 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

EXCEL IF Formula Error for graded Supplier Performance Incentive Payments

=IF($G16<$Q16,150,IF($G16>=$P16,IF($G16<=$O16,($G16-$O16)/($P16-$O16)*100,""),IF($G16>=$Q16,($G16-$P16)/($Q16-$P16)*50+100,"")))/100 In Cell V16, is the result multiplier of Contractor Performance. Either 0%, 100%, or up…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-10T08:49:54.54+00:00
Rino Quirante 0 Reputation points
commented 2025-12-11T13:17:40.21+00:00
Liora D 8,005 Reputation points Microsoft External Staff Moderator
2 answers

How to create a Multiselect Dropdown List in Excel Online

Is there a way to create a multi-select drop-down list in Excel Online? Need a feature similar to Google Sheets Smart Chips

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T09:35:57.99+00:00
Jerome Perumal 0 Reputation points
edited an answer 2025-12-11T12:02:05.9466667+00:00
Liora D 8,005 Reputation points Microsoft External Staff Moderator
1 answer

Microsoft Excel ODBC connection has stopped working

Since Microsoft rolled out the new Office 365 patch (19426.20186), the ODBC connection in Excel has stopped working. Neither existing queries nor new queries are functioning anymore. I kindly ask for your assistance.

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T09:49:00.04+00:00
Mario 0 Reputation points
edited an answer 2025-12-11T11:28:31.5266667+00:00
Phoebe-N 7,030 Reputation points Microsoft External Staff Moderator
1 answer

Scrolling Issue in Excel (Version 2408)

Multiple users in our department are experiencing scrolling issues in Excel (Version 2408 Build 17928.20654 – Semi Annual Enterprise Channel). This problem has appeared after recent update a couple of months ago. The issue occurs across various…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-10T09:25:17.8933333+00:00
Mohammed Suhail Ahamed 0 Reputation points
commented 2025-12-11T10:19:27.4666667+00:00
Tina L 8,745 Reputation points Microsoft External Staff Moderator
2 answers

error when downloading and open excel file that located on webdav

We are experiencing an issue with the current version of M365 in Excel regarding downloading documents via WebDAV. In Word, the documents are downloaded and opened, but in Excel an error message with the path is displayed. If the path is entered in Edge,…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T08:45:39.8166667+00:00
abdo elbarbary 0 Reputation points
commented 2025-12-11T10:12:34.23+00:00
abdo elbarbary 0 Reputation points