19,719 questions with Microsoft 365 and Office | Excel | For business | Windows tags
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
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
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
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
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
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
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
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
“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
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
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
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
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
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
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
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
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
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
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
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,…