Skip to main content

Automation for Excels

Excel automation is making repeated work run by itself. A macro records actions or is written in VBA, Excel's built-in programming language, and can be attached to a button, while workbook sharing, protection and co-authoring control who can view or change a file.

Stage: Automation · Part of the Excel roadmap · Last reviewed 19 November 2026

What to learn in Automation

Automation interview questions

Why must a workbook with macros be saved as .xlsm?

The standard .xlsx format cannot contain VBA code, so Excel strips macros when saving in it. The .xlsm macro-enabled format preserves them. Macros can also run harmful code, so Excel blocks them by default until the user trusts the file.

What are the limitations of a recorded macro?

A recorded macro repeats exact clicks and cell addresses, so it breaks when the data layout changes and includes unnecessary steps. Editing the VBA to use ranges, variables and loops makes it flexible and faster.

Where Automation fits in the Excel roadmap

Automation belongs to the Automation stage (intermediate level). Save time.

Back to the full Excel roadmap