Every time if you open this excel file first will ask enable or disable option. If you should choose enable . After that every 3 minutes ones this file will update automatically.
(or)
Click Excel Left Top Corner menu ---> Select Excel Options --->Click Trust Center --->Trust Center Settings ---> Trusted Location ---> Click Add new Location ---> Browse and Select your Modified OAT file folder ---> Click Ok.
Now you won't enable Macros Everytime . Try this.
(or)
Click Excel Left Top Corner menu ---> Select Excel Options --->Click Trust Center --->Trust Center Settings ---> Trusted Location ---> Click Add new Location ---> Browse and Select your Modified OAT file folder ---> Click Ok.
Now you won't enable Macros Everytime . Try this.
Attachments
-
99.5 KB Views: 272