An XLSX download is a conversion result, not proof that every Sheets feature works identically in Excel. Keep the source workbook until the target file is verified.
Identify the failing feature
Inspect whether the issue involves a function, structured reference, chart, external connection, or automation. Record the exact target Excel version and error rather than assuming all editions support the same feature set.
Compare a known working source value and its formula with the exported cell. Cached-looking results can hide a formula that fails when recalculated.
Review compatibility deliberately
Google documents differences between Sheets and Excel, including their automation environments. Apps Script is not automatically converted into an equivalent VBA project by downloading an XLSX file.
External-data formulas and application-specific functions need particular attention. Do not replace formulas with values throughout the workbook unless a static snapshot is the agreed output; that changes future behavior even if today’s numbers match.
Verify in the receiving application
Open an isolated export in the intended Excel environment and recalculate a small known example. Check totals, key lookups, dates, identifiers, tables, and charts relevant to the workbook.
If a formula needs adaptation, retain both versions and document the target-specific change. Avoid editing the only source copy until the revised workflow is checked. Review permissions and external connections before enabling content in a downloaded file, and do not disable security merely to make it run. Distribute the verified format with a clear statement of whether it is a live model, a compatible working workbook, or a static report with intentional limitations.
References
- Use both Excel & Sheets: Best practices
- Differences between Excel and Sheets
- Add formulas & functions
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.