This story captures a frustration we hear constantly: you're not an Excel expert, you just need a report cleaned up, and the built-in automation tools punish you for trying. The macro you recorded worked perfectly, until it didn't. It started rewriting other workbooks, because Excel macros are global by default unless you explicitly anchor them to the current file. You hit record, made your changes, and assumed the software would contain the logic. Instead, it leaked everywhere.
Our take is that this isn't your fault. It's a design failure. The tools marketed as "automation for everyone" still assume you think like a developer. Recording a macro should be as safe as saving a formula in a single cell. Instead, it behaves like a script that runs on every open document unless you know to add a "ThisWorkbook" reference or store the macro in a personal workbook. That's not accessible. That's a trap for anyone who just wants to rename four columns and delete three others.
What this means in practical terms: you have two choices, and neither is great. You can learn VBA well enough to scope your macro correctly, which takes time, and you said you're not an expert. Or you can switch to a tool that treats automation as a first-class, contained action. AI-native spreadsheets, for example, let you describe your transformation in plain language: "Rename Column A to 'Date,' delete Columns C and D, sort by date descending." The system handles the rest, and it never touches your other files. That's the shift we're watching, from recording opaque scripts to describing outcomes in natural language.
The deeper issue here is trust. You tried to save time, and instead you got a mess. That erodes confidence, and it makes people avoid automation altogether. The solution isn't for you to become a part-time programmer. It's for spreadsheet tools to meet you where you are: give you a repeatable, shareable way to clean up that report without collateral damage. Until then, the most reliable path is to use a tool that understands your intent, not just your clicks.