Chat with Copilot popup on every Excel launch
An ad for Copilot shows up every single time I open Excel. Clicking Not Now closes it, only for it to reopen again when I open Excel later. Is there any way to disable this or remember my selection each time? It is frustrating to have to deal with it all day long. I do not have a Copilot tab in File > Options. Optional connected experiences is already disabled. Microsoft® Excel® for Microsoft 365 MSO (Version 2511 Build 16.0.19426.20218) 64-bit Windows 11 Pro 25H2
How to view all employees in Microsoft Places?
Now that the Favorites feature has been removed and Microsoft Places only shows frequently used people from Microsoft 365 apps, is there a way to see all employees of the company (65 people) in one overview? I’m looking for a way to search this list and ideally sort it alphabetically or by department. Is this functionality planned to return, or is there an alternative way to achieve this today?
Playing with conditional formatting
This formatting is something I used to restructure the way I wrote formulas between 2015 and 2018. In the original I used VBA but now, as often happens, worksheet formulas used within conditional formatting are sufficient. The formula defining the condition is = DIRECTREFλ(A1) //Function to test for the presence of direct cell references DIRECTREFλ = LAMBDA(cell, IF(ISFORMULA(cell), REGEXTEST(FORMULATEXT(cell), "\b[A-Z]{1,3}\${0,1}\d{1,6}\b")) ); The original was pretty effective as a training aid to avoid the practice of relative referencing and use defined names! That said, not many followed my lead! Mind you when I posted a discussion on Chandoo it didn't meet with overwhelming support, though subsequent events in the form of spilt ranges have made my life so much easier! The post did however stimulate more discussion than I had anticipated. The A1 notation is an abomination that has no place within serious spreadsheet design -- discuss? | Chandoo.org Excel Forums - Become Awesome in Excel
Is there an acceptable method to convert pub to docx?
Unfortunately Microsoft has decided to end Publisher. So users are forced to find methods both for archiving old files and converting current files to be able to continue working. For the first PDF will most likely be the easiest. For the second I've been trying to find a converter. This proves to be a challenge. And the results have been very unsatisfactory so far. My main publication is a brochure which is printed double-sided on A4 paper, stapled and then folded to A5 size. The publication contains 99% text boxes (with formatted text) and pictures. Here and there a shape like a horizontal line. All things that Word definitely supports. So converting it should be a no-brainer - at least I thought so. Of course Publisher can save as DOCX. Unfortunately the function only supports plain text. So the text boxes are removed, which means a lot of manual rework. Also the text isn't converted continuously. For exapmle the text that was on the first sheet in my Publisher file, ended up on page 5 in Word. Bottom line: not acceptable. Microsoft therefore don't even refer to that save function in their official communication to Publisher retirement. They suggest a workaround instead: save the file as a PDF and open it with Word. The suggestion is embarrassing enough, since it implies that Microsoft are unable to provide suitable conversion between their own formats. I tested it anyway. But the layout ends up in Word in a way that requires a lot of manual rework. Tab stops are partially removed, page margins are shifted. The pagination is also incorrect, so that some pages are half empty. Bottom line: not acceptable. Also tried some online converters. Unfortunately the results haven't been satisfying either. Most of them convert text boxes into shapes with integrated text boxes. And even worse: big text boxes are often split into several smaller boxes. In any case there still remains a lot of manual rework. Bottom line: halfway acceptable. Disappoiting Conclusion: At present, I consider it the best option to rebuild the file from scratch in Word using Copy-Paste. If someone knows a better method, would be happy to hear about it.
Worksheet tabs to include date from a cell
Hello , I have a worksheet with four tabs. Cell H1 in both tabs 1 and three contains a date. I would like to include that date in the tab name in the following format: for Tab 1 "AR - as of (the date in H1)" and for Tab 3 "AP - as of (the date in H1)". The dates in the tabs would update whenever the date in cell H1 is updated. I am using Microsoft 365 Apps for Enterprise, version 2510, Build 19328.20178. Thank you for your assistance.Formula/method to link the data/responses I get from my forms into a different table.
Hi everyone! I need help with a project that I'm creating. Im making use of Microsoft Forms in order to input certain information. I made use of branching since some answers depend on the previous choice. So moving on to my problem, I want my table2 to get the responses/data from the data table created by the forms. Table 2 Table of responses For reference for the spill error, here is the formula that I used. Any insights will help a lot. Thank you have a great day everyone.
name manager rejecting lambdas
I tried pasting a lambda in name manager but excel refused. I belive that it's because either it is too long (which it isnt) or it has too many optional parameters (8). Anyone knows why name manager will reject to paste my lambda? These are the parameters: =LAMBDA(array,slice1,[index1],[return_index_slice2],[index2],[return_index],[if_not_found],[logic],[headers],[function],LET(...))
