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

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