Getting started in Excel Labs Custom Modules (missing "publish" step)
First-time poster — please be gentle! Context Excel for Mac I have a large library of LAMBDA formulas and wanted to manage them using Excel Labs In particular, I wanted to organise formulas into custom Modules Issue How to actually activate functions defined in custom Modules in Excel Labs I recently discovered Excel Labs and was very excited to use it to manage and structure a large library of LAMBDA formulas. My goal was straightforward: create custom Modules to organise formulas by purpose, and then use those formulas in the workbook. However, it took several hours of experimentation and debugging — even to get a trivial example like: ABC() = 12 to work when defined in a custom Module. The missing piece (which Copilot, Google searches, and the README all missed) is this: Functions defined in custom Excel Labs Modules are inert until the module is imported into the special Workbook module. Until that import step occurs, functions in custom Modules: do not appear in Excel Labs → Names do not appear in Formulas → Name Manager are not callable from the grid According to Copilot this behaviour is not currently documented, and the UI strongly suggests that custom Modules are “active” by default — which they are not. Working workflow (for others who hit the same issue) This is the workflow that finally made things work for me (possibly sub‑optimal, but reliable): Create and maintain functions in custom modules (e.g. Transformations) Explicitly import the required functions into the Workbook module, e.g.: TransformAtoB = Transformations.TransformAtoB Workbook module now publishes to: Excel Labs → Names Formulas → Name Manager This makes conceptual sense — maintain a large structured library of formulas (or import libraries from GitHub), only activate the formulas required by a particular workbook. But without documentation, it’s very easy to assume custom Modules are active by default. Why I’m posting this When I finally asked Copilot “Why didn’t you say this up front?”, the answer was essentially: This publish step is not documented in the README or the UI, and users are easily led to assume Modules are active by default. So I’m posting here to save others from repeating the same debugging journey. Documentation request It would help enormously if the documentation (README / FAQ) stated explicitly that: Custom Modules are source-only Importing into the Workbook module is the publish step Only the Workbook module is wired to Name Manager and the Excel grid Even a short note would remove a major stumbling block for new users. I’m not a GitHub user, otherwise I would also raise this there — if someone from the community is able to mirror this feedback on GitHub, that would be much appreciated.
Creating weekly calendar template that has overlapping positions
Hi, I have a software for individuals to sign up for shifts, but it is visually hard to see where there are open areas that need to be filled. I need help creating a calendar from this software download that I can update each week. It would have to be much like an hourly scheduler view to easily see when someone is coming on and off shift. But also laid out from Sun-Saturday. There is 3-4 "slots" for each day. It would be great if they could be color coded as well. Slot 1 needs to be anyone that is "AEMT" in the position column, Slot 2 can be anyone listed as "EMT" or "EMR" (caveat to this would be that slot 2 could also be AEMT if there is already an AEMT in slot 1 for the same time slot. Slot 3 is for driver or ride along (or the other 3 positions if there is one listed in the other slots), and possibly 4th slot would just be overflow in case there were 4 people signed up which does not happen very often. Is there anyone who can help me with designing this? Below is what the software generates when converting to excelHelp with Excel pop out window
I found a free spreadsheet online that I wanted to use. I am able to manipulated it for my use case. But the original creator added these call out fields that I cannot seem to find out how to delete or change the syntax. I can't even find out what they are called. Any suggestions?? In the attachment, I select a filed and a little yellow box pops up. How do I change or delete these??
Excel formulas starting to include current sheet name
Hi I recently noticed that formulas in excel starting to automatically include the "current" sheet name after leaving and coming back to the sheet (example below). I don't remember this used to be the case but I could be wrong. Does anyone have a similar experience or can confirm if this is correct? Is there a setting somewhere I can turn this on and off? Example: I have 2 tables (1 per sheet). After clicking on Sheet2 to select the cell I want to sum, coming back to Sheet1 and referencing any cells will include "Sheet1!" in my formula. I believe previously the formula omits "Sheet1!". Both ways are useful in different scenarios but wondering if I have missed a trick to "turn on and off" how it behaves. Thanks!
Why can’t an Advanced Filter be re‑applied like an AutoFilter in Excel?
Hello everyone, I’m trying to clarify a technical question about how Excel handles Advanced Filters versus normal AutoFilters. In my course, I was asked to use an Advanced Filter to display only specific records in a dataset. I applied the Advanced Filter correctly, and the results were displayed as expected. However, when my instructor tried to “remove the filter and apply it again,” Excel did not behave like it does with a normal AutoFilter. Because of this, the instructor assumed the filter was not done correctly. From what I understand, this is actually normal behavior, because: Advanced Filters are not dynamic They do not remain active after being applied They do not have the “Reapply” option that AutoFilters have To use the filter again, you must run the Advanced Filter command manually each time The result is static and does not update automatically Microsoft’s documentation confirms this behavior. For example: “The Advanced Filter command is not an interactive filter. To change the criteria or reapply the filter, you must run the command again.” Source: https://support.microsoft.com/es-es/office/filtrar-por-criterios-avanzados-4c9222fe-8529-4cd7-a898-3f16abdff32b So my question is: Is this the expected behavior of Advanced Filters in Excel, and is it correct that they cannot be re‑applied automatically like AutoFilters? I want to make sure I fully understand the intended functionality so I can explain it properly. Thank you in advance for your help.Problems to move cursor / Problèmes pour bouger mon curseur
Hi everybody, English and French below. I'm strangely unable to move cursor with my arrows or other means. On my keyboard, the 3 lights over the numbers (and Verr num, /, * and -) are illuminated. Can somebody help me? Salut à tous. Je suis bizarrement incapable de bouger mon curseur autrement qu'avec ma souris. Pas très pratique pour passer d'une cellule à l'autre. Sur mon clavier, les trois lumières situées au-dessus de mes chiffres (et Verr num, /, * et -) sont allumées. Quelqu'un pourrait m'aider?
