TOCOL/TOROW Treat Thunks as Errors
I just reported a bug to Excel in which the TOROW and TOCOL functions, if asked to delete errors, will also delete valid thunks. ISERROR returns FALSE when presented with a thunk, so, arguably, TOCOL shouldn't treat it as an error either. I'm running Office 365 on Windows 11 on a Samsung Yoga laptop. Steps to reproduce: Paste this into a single cell in a spreadsheet: =LET(th, VSTACK(LAMBDA(4)), (@TOCOL(th,2))()) Expected behavior: should return 4. (Delete the ",2" and it does exactly that.) Actual behavior: #CALC error Impact: Breaks workflows for SCAN, MAP, BYCOL, and BYROW Workaround: Use FILTER and ISERROR Details: An Excel "thunk" is a degenerate LAMBDA with no parameters. So if we used LET to make f equal to LAMBDA(4), then f() would always return 4. If a thunk is the final result of a function, it generates a #CALC error, but it's fine for intermediate results. This seems useless, but it's the only way to get functions like SCAN, MAP, and BYROW/COL to return anything but a scalar. For example, I have a piece of code where I need to repeatedly square a large matrix and save the values for further processing. If I get a zero value, I can save a lot of processing by "aborting" the operation. Since you can't abort a SCAN, I just return #NA. Then I'd like to use TOCOL(result, 2) to strip off the unnecessary values. But TOCOL discards everything. I can work around this by using a combination of ISERROR and FILTER, but I shouldn't have to.
Formula to retrieve data from several sheets and return values from given criteria.
I am trying to get data from each of our areas of the school staff timetables EY MY LY and summaries what days each staff member works where to another sheet, as staff move around. I would appreciate some help please. This is how far I got: =IFERROR(VLOOKUP(A10,EY!$C$3:$G$33, 2, FALSE), IFERROR(VLOOKUP(A10,MY!$C$3:$G$33, 2, FALSE), "Not Found")) This just returns; I tried to add in the same formula for LY but it is saying too many arguments, this is why Michelle is Not Found. Will I also be able to return the area they are in on each of the days ? Any assistance would be very much appreciated.Pivot Table Setting Won't Appear
This is Excel 365, the online version. When I create a pivot table the field table pane pops up so I can select what columns I want. When I go to "show settings" for the pivot table they don't show up and then cause the field table pane to also not show up. This happens on all my documents, new and old, multiple devices and web browsers. I've used the pivot table settings on other documents but on Wednesday 11/19/2025 is just stopped working. I didn't change any of my settings. This seems to be a Microsoft glitch but their tech support's only solution to me was to use the desktop version but the point of me using the online version is so that everyone in my Organization can use these shared docs. I'm having a ton of other issues with Microsoft but this one is preventing me from being able to the basic tasks of my job.
Office 365 - how do I fix a duplicate problem
I had Office 365 for my home office throuogh Go Daddy. I closed the business and cancelled GoDaddy - no more Office 365 So I signed up for Office 365 Personal and paid the yearly fee. Now I can't use Word because they have loaded all my ols business data and when I try to uses Word it says I need to sign up - when I already did Total frustration for the last 3 months trying to figure it out. Can anyone help? email address removed for privacy reasonsLong Date Format Text Wrapping
I need my dates to be in the long date format: Monday, December 8, 2025 However, I also want that text to wrap. I do not want an really wide column for that date. I would like it to wrap at whatever point it wrap at when I adjust the column width. Simply choosing "wrap text" in the alignment section does not work. Any column width shorter than the amount of space needed for the entire date turns the date in that cell to pound signs. Heck, I'd be happy if I could even just shorten the column width and see only the beginning of the date. Though I would prefer it just adjusting like it does in every other column. I have tried work arounds like a custom date format where you force the second line to be part of the date - which it will do but the column width still must be as long as if it were in one long line or it still goes to pound signs. Is there a workaround that I can't find? Is this something that Microsoft could work on fixing in an upcoming app update? Because I have been suffering through this problem for years and would love for it to be fixed. (Also - I do not want to change the column to "text" - I want to be able to type in 12/9 and have it automatically change to Tuesday, December 9, 2025 for me. I am often changing dates or inserting dates and need it to be dynamic and not manually entered each time. (Thus the whole point of having the date format to begin with.)
Word printing a random blank page before printing the document (booklet)
Ok I have a printing issue on a document (handbook), which is an 11x17 booklet. It has started printing a blank page before printing the actual handbook and we can't seem to locate the issue. Even if I try to print to a PDF, it first prints a blank page that must be saved as a separate document, then a second document which is the handbook. It does the same thing when we print to the printer. I have even created a new blank document, copied the content over to the new document and it still does the same thing. I have also tried saving to other versions, etc. No luck locating the issue on my end so far. I have attached a link to it to see if anyone else wants to take a moment to open it and print to see if they get the same issue or can find my issue. https://we.tl/t-aiOMkEGD5uSheet View Issues with Excel Web Browser
Hi, I have created a Excel document for my department to use, I tried Excel App but due to the size of the Spreadsheet it kept freezing, as a result I switched it to use Excel through Web Browser. The sheet no longer freezes which is good. I do have another issue though.....I wanted multiple users to be able to access, edit the sheet at the same time so I did some research and Sheet View seemed to be the way forward. I created a Sheet view for each employee to use so when you go to View, Sheet View and click on the relevant person their work is updated, saved etc and this shouldn't affect others view. This is working in terms of people editing. The main issue now though is that despite following advice sometimes when someone changes a filter on their own sheet view it seems to change others view. My understanding was you can hide, filter etc within your own Sheet view but this doesn't seem to be the case.......PLEASE HELP!!!! My excel and computer Skills aren't excellent to please any simple advise would be great.
