Excel: Settings Setup

Settings needed to make sure you are setup to use Excel with Valcre:

1. Within Excel, go to File -> Info

Excel Setup1

2. Then go to Trust Center -> Trust Center Settings

Excel Setup2

3. Then go to Trusted Locations

4. Select Allow Trusted Locations on my network

Excel Setup3

5. Then go to Trusted Documents

6. Select Allow documents on a network to be trusted

Excel Setup4

7. Then go to Add-ins and make sure no options are selected

Excel Setup5

8. Then go to ActiveX Settings

9. Select Enable all controls and Safe mode

Excel Setup6

10. Then go to Macro Settings

11. Select Enable all macros and Trust access to the VBA

Excel Setup7

12. Then go to Protected View and make sure no options are selected

Excel Setup8

13. Then go to External Content

14. Select Prompt user about Data Connections and Disable automatic update of Workbook Links

Excel Setup9

15. Then Select OK to save settings