User Profile
Steve1330
Brass Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Downloading Microsoft 365 and Office Updates-Not Completing!
For the first time, my roughly weeklyMicrosoft 365 and Office Updates download, for my Microsoft 365 Insider Current Channel (Preview), attempting to be executed from the Excel-Account screen, is not completing after multiple attempts, the last one waiting an entire hour. I received the attached error message. Please advise ASAP! Thanks. Steve2.4KViews0likes9CommentsNew Excel VBA Tool File Crashes Related to Use of "On Error Resume Next" Code Lines
All of a sudden, I've been noticing and having reported new Tool file crash events, both on my and other end-user PCs, that had not occurred for years of use of these Tool files. Digging deeper into them, it appears to me that VBA code lines using "On Error Resume Next" error handlers are now triggering errors that were not previously triggered, many completely crashing the file, making it virtually impossible to diagnose and resolve the issue. I actually learned something new that I was completely unaware of for debugging: Apparently, I had always been using, in the VBA Editor, Tools-Options-General-Error Trapping setting of "Break on Unhandled Errors" instead of periodically using the alternative setting of"Break on All Errors", that would have quickly alerted me to these potential"On Error Resume Next" issues. What has the Microsoft Excel team been doing that might explain all these new Excel VBA Tool issues? Thanks.756Views0likes0CommentsFor Insider, When Will Python in Excel & New GROUPBY & PIVOTBY Functions Appear?
My latest build version (downloaded and installed this week) is: Microsoft® Excel® for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20028) 64-bit Why have I not yet gained access to either Python in Excel or the new GROUPBY & PIVOTBY Functions? Thank you. SteveSolved4.7KViews0likes31CommentsYEAR(TODAY()) Function Triggering Circular Reference Error Starting 1/1/2023-Why?
All of a sudden every formula I have in a worksheet with the sub formula "YEAR(TODAY())" is triggering a "Circular Reference" error message whereas no such error message for this worksheet was triggered prior to 2023.2.2KViews0likes2CommentsProgrammatic & Manual Copy & Paste No Longer Working For Format, Just Values
I've just discovered that a VBA program I wrote years ago has stopped working when copying and pasting a range of cells, with only the values being copied, the cell fill and font colors no longer being copied. Here is the line of code I've successfully used for years that's stopped working. 'Copy Columns I-J wboWBO.Sheets("SheetName").Range("I6:J29").Copy .Range("I6:J29") Previous to last week, this worked without fail, now only copies values, not formatting. Please advise ASAP and fix. Steve650Views0likes2CommentsNew Quick Access Toolbar Hide & Unhide Rows & Columns Icons Appeared, Then Disappeared
This is a very minor complaint, but I use about 35 Quick Access Toolbar commands, most of which have icons. However, a few, most notably the Hide & Unhide Rows and Columns commands, had never previously had icons, until they appeared for the first time briefly this past weekend, which I thought were pretty cool, and then they disappeared when I got back from out-of-town on Wednesday. Anyone from MS know what's going on with these? Again, not a big deal, but very strange. Thanks.500Views0likes0CommentsHovering Over Notes No Longer Working
Sometime over the past week or so, none of my Excel 365 Notes will display when I hover my mouse over a cell with a Note. This issue occurs in every workbook I open or create. My guess is that it's due to one of my recent updates for the Office Insider program. Please advise.Solved27KViews0likes23CommentsLET and Nested Dynamic Array FILTER Function
I'm looking for a way to reference a FILTERED dynamic array column, nested inside the LET functions, e.g.: LET(A,FILTER(A:F,(A:A="X")*(B:B<=DATEVALUE("12/31/2021"))), A_____) How would I reference the first column of the A LET range variable at the end of the LET function, or is this not possible?7.9KViews0likes8CommentsAvailability of Dynamic Array Formulas In Temporary Hybrid MS 365 Online and Office 2016 Desktop
My employer is migrating everyone to MS 365 Online and desktop in a 2-step process, implementing the online version in January 2021 and then the desktop version in June 2021. My question is that I'm anxious to have access to Excel's great new Dynamic Array formulas in the interim once we have the online version available. Will I be able to do that with files in Excel 2016 and Excel 365 online available?Solved950Views0likes2Comments