Excel & VBA user guide

How to run an Excel macro

Check the result instructions first. Direct data edits are already applied; open the file to view them. Run a macro only when the result includes VBA automation.

Windows: open the .xlsm in desktop Microsoft Excel, choose Developer → Macros (or Alt + F8), select the procedure named in the result and click Run.

Mac: open the .xlsm in desktop Microsoft Excel and choose Tools → Macro → Macros or Developer → Macros. Menu locations vary by version.

Allow macros only when you understand their source and purpose. Follow your device security policy if Excel blocks them. This service checks file writeback but does not compile or run VBA in desktop Excel.

WPS, Mac and Excel for the web

Macro-free .xlsx results can be viewed in Excel or compatible spreadsheet software; formula and formatting support varies.

Mac WPS JS macros cannot run VBA. Excel for the web cannot run VBA either. Mac Excel supports VBA, but Windows COM, ActiveX and external components may not work.

What can this workspace do?

Describe a workbook to create a template, or upload .xlsx / .xlsm to explain data, diagnose VBA, edit cells, add basic formulas and formatting, combine, filter, sort, summarize or split data. Cross-sheet formulas within a workbook, whitespace trimming, numeric/date normalization, explicit blank filling, deduplication and column-mapped merging are supported. Cleaning creates new value-only sheets and preserves sources.

Direct table changes do not require generated macros. VBA is generated or modified for explicit VBA requests and macro repairs. Macro-free results use .xlsx; workbooks retaining or adding macros use .xlsm. Formulas such as SUMIFS, COUNTIFS, DATE, YEAR, MONTH, DAY and EOMONTH are kept and automatic recalculation is enabled. External workbook links, whole-column references, named ranges and array formulas are unsupported.

From request to download

1. Describe the expected result and optionally upload Excel. Example: Set Data!B2 to 123. No macro needed.

2. Send to see the workbook in the center and findings, progress and the plan on the right. Unsupported or ambiguous requests are explained before execution.

3. Confirm the plan, then download the result. Continue typing to request changes. Select a cell, drag across a range or Shift-click its endpoint, then click Reference to insert a card with the file name and address inline. Up to 8 references are supported.

Switch between Activity and User guide on the right without leaving the task or clearing your input.

Copy between two workbooks

After starting a task, Add workbook supplies a source or destination template. Specify which file provides content and which receives it. Check the destination before confirming. Upper tabs switch workbook previews, and lower tabs switch worksheets; previewing a file does not change the destination.

Example: Copy all values from the current Data sheet into a new Imported sheet in the attached workbook. No macro needed. The opposite direction works too.

Range or whole-sheet value copying and eligible standalone standard VBA modules are supported. Values do not carry source formulas, formatting, charts or controls. Existing target cells need explicit overwrite permission. Dependencies, dynamic sheet references and module name conflicts can prevent migration.

Current limits

Unencrypted .xlsx and .xlsm, up to two workbooks and approximately 4 MB combined upload. Up to 20,000 rows and 128 columns per sheet, with 200,000 cells overall.

.xls, .xlsb, locked projects, digital signatures, UserForms, pivot editing and arbitrary external integrations are unsupported. Only supported table operations and basic formulas can run.

Unsupported requests are explained on the right. An unrelated macro is not a substitute for an unfinished table edit; macros are not described as runtime-tested.

Where can I see credits and usage?

Your credit balance appears beside the avatar at the top right. Click it to see analysis allowance, monthly completions and credits debited or refunded. The same top-bar button is available on mobile.

Choose Usage & credit history, or your avatar → Credits, for transactions and top-ups. Usage refreshes after completion or failure; a manual refresh button is also available.

Analysis allowance and credits are separate: plan review and explanations use allowance but cost no credits. Free accounts get 10 lifetime analyses; Starter and credit-pack accounts get 150 per UTC calendar month, Pro gets 400. The reset date is shown. The 5-per-hour limit still applies. Existing analyses and failures after entering analysis count; invalid files rejected before task creation do not.

Are drafts saved automatically?

A second Excel attachment is saved as a task draft without pressing Send. Typed text and reference cards are also saved and restored when possible after refreshing or reopening the task. Replacing or removing attachments updates the draft; replacement clears references to the old attachment.

Autosave uses this browser, not permanent cloud storage: up to 20 tasks for 24 hours. Changing devices or clearing browser storage can prevent recovery. Keep important files yourself. If saving fails, a message asks you to avoid refreshing.

What does … mean in the preview?

The grid fills the workspace while loading or showing a snapshot. An ellipsis (…) means that cell has not been loaded; it does not mean file content is missing. Selection and references require the full file.

Activity follows new updates. Scrolling upward pauses it; Latest activity resumes it. Switching to User guide keeps the current task open.

Failures and credits

Plan review and explanations cost no credits but use analysis allowance: free accounts get 10 lifetime analyses, Starter/credit-pack accounts 150 per UTC calendar month, Pro 400. Existing analyses count. Up to 5 per hour. Confirmed execution costs 10 credits under the existing pricing rules; failed execution is refunded. The sidebar shows the failed step, reason and confirmed billing status.

A disconnected browser does not necessarily mean failure. Check task status before retrying. Pending refunds are clearly indicated; contact support if needed.

Files and history

Downloads are edited copies; originals on your device are not overwritten. Keep your source files. Results can be downloaded again within 24 hours. The sidebar shows a change count and up to 30 before/after examples. Open a completed task in history and choose Continue from this version to use it as a new starting point. Generated files are temporarily cached in this browser; recovery is not guaranteed after clearing browser storage.

History keeps plans and small previews; your browser temporarily retains originals. A different device, cleared browser storage or expired retention may require reattaching matching originals. Keep both sources for two-workbook tasks.

The AI receives requirements, sheet names, existing VBA and small data samples. Full-data copying and computation run on the backend.