Performance becomes an issue with large datasets too. A poorly written macro can bog down Excel and take forever to complete, but well-designed formulas or other tools like Power Query often handle ...

After rolling back restrictions on internet macros in Office, Microsoft now says it is was a temporary change and that it will be bring back the ban on macros as the default for all users in future.