Spreadsheets
QwenWorkSpreadsheets that still calculate
The failure mode of AI spreadsheets is a clean-looking file where the formulas have become numbers. This one keeps them alive — up to a size limit.
Formulas, not values
When it edits a workbook, existing formulas stay formulas. New summary columns are added as formulas referencing the original range, not as pasted results. That matters because the file will be edited again by someone who expects to drag a fill handle and see the numbers update.
Multi-file questions
The realistic use is not 「build me a dashboard」. It is 「these three exports disagree on the October total — find out why」. Point it at all three; it will match on keys, surface the rows that differ, and tell you which file has the extra entries. That is a two-hour task done in five minutes, and the output is a list you can verify.
Limits worth knowing before you start
| Dimension | Practical limit | What happens past it |
|---|---|---|
| Rows per sheet | ~50,000 comfortable | Preview lags; analysis still works but iteration gets slow |
| Files per task | A handful | More files mean more disambiguation errors |
| Formula complexity | Standard aggregation | Nested array formulas are preserved but not interpreted |
| Macros | Not executed | xlsm is read as data; VBA is ignored |
Working habits that reduce rework
- Name your sheets meaningfully. Sheet1, Sheet2 and Table1 are where cross-file confusion starts.
- Delete merged cells before uploading; they are the most common cause of misaligned rows.
- Ask for the exception list first, the summary second. The exceptions tell you whether the summary is trustworthy.