Unable to open macro enabled Excel (.xlsm) file and it consumes high resources of the VDA

book

Article ID: CTX233898

calendar_today

Updated On:

Description

Unable to open macro enabled Excel (.xlsm) file and it consumes high resources of the VDA

Resolution

Open Excel
Click on File -> Options - > Trust Center -> Trust Center Settings… -> Macro Settings -> Enable all macros.
Same can be configured using Group policy.

Problem Cause

By default Excel macro setting is not enabled to execute macros