Now the company is making a big change that could make the software much safer. According to a blog post, Excel will now disable macros by default. Consequently, Microsoft’s protection against macro-based malware will be enabled for everyone. This change may seem drastic at first, but Microsoft says that it is necessary in order to protect customers.

Useful but cumbersome

In Excel, a macro is a sequence of commands that can be recorded, sent to others and repeated without having to remember the details. It’s a valuable feature that allows people who aren’t programmers to automate repetitive tasks. However, malware often uses macros to run its own commands. The change addresses that risk by requiring users to enable the recording of macros in order for them to run. They can be used for good or evil. In a nutshell, whilst macros allow users to do helpful things such as fill out a spreadsheet automatically from a database of information, they also allow viruses and malware to spread from one computer to another.

The long history of abuse

Microsoft has been warning its users about the dangers of macro-based malware for years now, but the company has been taking a more proactive stance against such threats lately. For end-users, the most important aspect of this update is the fact that users can now manage this restriction with both cloud policies and ADMX policies. Besides, they can completely block all usage of XLM macros, including in new user-created files, by enabling the Group Policy. According to the information from the publication, Microsoft plans to block Excel users from opening untrusted Microsoft Query files with IQY, OQY, DQY and RQY extensions in an upcoming update. You can also visit our dedicated Excel hub if you are experiencing any related problems. Do you think the new update will enhance security while using Excel or make your work more tiring? Share your thoughts in the comment section below.

Name * Email * Commenting as . Not you? Save information for future comments
Comment

Δ