Developer Scroll Bars Suddenly Became Erratic!
Hello, I have a very unusual problem related to developer form control Scroll Bars! I had previously enjoyed my highly reliable Scroll Bars and Spin Buttons that I had created for months (if not more than a year). Suddenly, (a few days ago) the Scroll Bars are simply no longer reliable, while only the upper button of Spin Buttons is highlighted, even if the lower one is clicked! This occurred without my tweaking! By unrealiable Scroll Bars I mean you can sometimes slide the scrolls and sometimes not. Usually, the first few work more reliably, while the later ones than freeze! It behaves erratically like that. It can help sliding previous bars and returning to the later ones, zooming in and out, and manually inserting the number and then re-fixing the Scroll Bar. Neither copy/pasting an upper working Scroll Bar, nor inserting a brand new one helps with the erratic behavior! The same applies to the Spin Buttons. Sometimes, you can click the lower button and the values will go low as expected. However, once the problem settles in, you can continue clicking the lower button, but the upper one will be selected and applied. The same temporary fixes as with the Scroll Bar (and copy/paste and recreation non-solutions) apply! I have the Excel file ready and wish to upload it here for you to see if you can produce the problem on your end! This has never happened to me before!Can anyone help me with this SWITCH function
Hello Everyone, This SWITCH function is used to produce a number that then I can use to sort workers and their functions. =SWITCH(TRUE, IF(AND(ISNUMBER(J2)=TRUE,M2="Working")=TRUE,5,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Working")=TRUE,500,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Special Project")=TRUE,15,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Special Project")=TRUE,515,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Stand By")=TRUE,20,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Stand By")=TRUE,520,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Special Project UFN")=TRUE,25,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Special Project UFN")=TRUE,525,0), 50 ) In Column J I have their Start Time, from the Kronos System, and in Column K I have their End Time. In Column M I have Tasks names that would indicate what each Team member is doing. Each component does evaluate correctly but the function always return 50? What am I missing here? Thanks in Advance! GiGi
Excel Macros Spreadsheets Not Loading
I've spent some time with Microsoft Support (almost 3 hours, including uninstalling my MS 365 and reinstalling it), but I'm having an issue with my Excel Macro spreadsheets not loading at all. This is what I get each time. Also having an issue with non-Macro spreadsheets that I'm unable to use the Bold, Italic, and Underline functions (get the spinning wheel and then Excel Not Responding), as well as not able to use the Format function (get the same spinning wheel and then Excel Not Responding). I've been using these same Excel Macro Spreadsheets for over 15 years. Please help!
Please allow this foundational concept for algorithms
Hello dear friends of Excel. Please let me begin by thanking you all for giving us the excellent tool that Ms Excel is. I've being working practically my whole Computer Engineer career (~18 years) with this awesome tool, and I cannot imagine doing my work without it. It really is excellent, and has been enhancing a lot in the last years. In this occasion I would like to ask you to consider including in Excel, native support for "empty arrays", that is, arrays that have "0" (zero) items. This feature would help a lot in the following type of algorithms: When you have to scan a range of cells that hold the items of a set named "S", and from that set you have to select only the items that satisfy a given condition { ALL i | such that CONDITION(i) = TRUE }, and with those selected items (i) you have to construct a new vector named "V" In this case you usually need to begin with an "empty array", that is the initial value before adding any selected item, and at some point as you process the algorithm, maybe you will find the 1st. item to add to the "empty array" Maybe you won't find any item that satisfy the condition, and at the end of the algorithm, you will end up with an "empty array" as a result. To illustrate this type of algorithm, let me put an example: =LET( vector; SEQUENCE(10); new_vector; REDUCE( 0; vector; LAMBDA(building_vector;vector_i; IF(RESIDUO(vector_i;2)=1; VSTACK(building_vector; vector_i); building_vector ) ) ); INDEX(new_vector;SEQUENCE(ROWS(new_vector) - 1) + 1) ) This "algorithm", scans a set S = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 } from S, it selects only the "odd numbers" { ALL i | such that "i is odd" }, it takes every odd number and adds it to the array named "building_vector", "building_vector" begins as a non-empty-array, holding "1 sentinel item" at the beginning of the algorithm (the number "0"), at the end of the algorithm, I have to do a work-around, to remove manually the 1st. sentinel item from the array The cons of this approach are: sometimes the resulting array will not have any selected item, that is, it will be an "empty array", and as such, Excel will generate an error showing #CALC! as Excel doesn't currently support empty arrays, I have to do this workaround to add an initial sentinel item at the beginning of the algorithm, and then I have to remember to remove it at the end of it Dear friends of Excel, I consider empty arrays to be a "foundational concept for algorithms". It's like the "zero" for numbers, but for arrays. It would be nice to be able to write this kind of algorithms with the aid of Excel, being able to natively support "empty arrays" without me having to do the extra work of handling a simulated situation of an empty array. I present you this request, and I ask you to please consider the importance of this feature. Thanks in advance!
Excel can't open file from hyperlink after upgrade windows11
Hello, I met a strang issue. After upgrade system from w10 to w11, my excel can't open linkage file which was working normal before. Tested file and folder which located on local and SMB was not working, after click the hyper-lnik nothing happen and no pop-up just turn to mouse to loading icon then nothing happen how can I check which part cause this issue? Also tested on word have same issue. Further, url was working normal.
Circular Reference Issues - A desperate woman needs help ASAP =(
I have an incredibly in-depth spreadsheet, with about 15 pages, and in-depth tables and calculations on most of those pages. Point being, I have a HUGE freaking file with tons of data collected over the years. Now, all of a sudden, I cannot input anything without the Microsoft Excel Warning popping up, stating: "There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly. Try removing or changing these references, or moving the formulas to different cells." I understand what this pop up is saying, but my file is so huge, and there is so much information, I cannot find the error anywhere!!!!! And I don't have the option to search for it. So I cannot correct this error on my own, and I cannot input anything into the spreadsheet without having to exit out of that **bleep** pop up!!! I am defeated, INCREDIBLY FRUSTRATED, and I cannot see a clear path to recovery. I have been working on this document for years now, and I cannot start fresh. HELP, HELP, HELP!!!!!!!!!!!!! SOS!! Anyone! I am desperate and beyond frustrated =(A new Excel Think Tank
After nearly 30 years of using Excel commercially, I am now coming to retirement. But before I finally hang up my Excel boots, I have setup a small Excel think tank. The idea being people can send me their issues and I will work with you to build your permanent solution in Excel. I have created a number of solutions from Email Validator, Automatic dashboard creators, Fraud analysis, Auto resume makes, Music Syns (All in Excel), so if give it try.
