Create your first project
Upload your first Excel to the platform, open the in-browser editor and save a version.
inventory_2
For day-to-day workflow
My functions library: edit, re-run, delete
How to manage your LAMBDAs and JS scripts from the Functions panel — the day-to-day workflow with your personal library.
schedule 4 minutes read
-
Step 1
Find the Functions panel
In the project editor, in the top-right toolbar there's a Functions button (formula icon). Clicking it opens a modal with two sections: LAMBDA functions (purple badge) and JS scripts (blue badge). If a section is empty, it doesn't show — the modal only displays what you have.
-
Step 2
Run a saved JS script
Each JS item has a ▶ Run button. Click it and the script runs against the current workbook with the defaults it was saved with (input range, output cell). If it modifies the file, a new version is automatically created in history — you can always roll back.
💡 Tip: Tip: if you want to re-run with a different input, edit it first (step 4) or create a new script with the right ranges. -
Step 3
Edit the code
Click the pencil icon ✏ Edit. An inline form appears where you can change name, description, code (LAMBDA or JS), and for JS the default ranges too. On save, LAMBDAs create a new file version (because they live IN the file); JS just updates the database row.
💡 Tip: If you rename a JS that another project of yours referenced by its old name, no impact — scripts are per-project. -
Step 4
Override without touching defaults
This is more advanced but useful: if you want to run the script against a different range than the one saved, ask the AI: "Run my_script but against C2:C50 instead of A2:A100". The assistant can call the tool with override args. The saved script doesn't change, only that single run uses the new ranges.
-
Step 5
Delete the obsolete
Click the trash icon 🗑 Delete. For LAMBDAs, this removes them from the workbook (a new version without them is created; rolling back to a previous version recovers them). For JS, deletes the database row permanently. Confirm to avoid accidental deletes.
-
Step 6
Create from the panel (no AI)
If you already know what JS you want, click + New script in the JS section. Fill the form: name, description, JS code, defaults. Useful when you're migrating a VBA macro piece by piece and the code is already in your head.
💡 Tip: LAMBDAs can't be created from here — only via the AI with <code>define_function</code>, because the Excel formula parser needs to validate the syntax. -
Step 7
Versioning: every Run = a new version
When you run a JS script or edit a LAMBDA in a way that modifies the workbook, a new file version is automatically created (with note "Scripts panel"). Go to History in the editor header to see the full chain. If you broke something, restore the previous version with one click.
Ready to apply it?
Open ExcelEmpowers and follow these steps on your own Excel.
Create free account ← Browse more tutorials