EXPERION PKS To Set Up Microsoft Excel Data Exchange

1. Log on to the computer using a Windows account local administrator rights.
2. Choose Start and type msc in the search box.

The Local Security Policy window appears.

3. Expand the Local Policies item and then click on the User Rights Assignment
4. Double-click on the Deny log on locally

The Deny log on locally Properties window appears.

5. Click the Local Servers item and then click Remove.
6. Click OK.
7. Close the Local Security Policy
8. “Logoff and Logon as MNGR”
9. In Windows Explorer, browse to the C:\Program Files\Honeywell\Experion PKS\client\xldataex
10. Right-click on the excel reports.reg file, and choose Merge. If prompted, enter password for and run as Windows Admin
11. Close Windows Explorer
12. Choose Start > Run.

The Run dialog box appears.

13. In the Open box, type the following:

“C:\Program Files\Honeywell\Experion PKS\client\xldataex\activatemede.vbs”

Alternatively, double click on ‘activatemede.vbs’ in the location

C:\Program Files\Honeywell\Experion PKS\client\xldataex\

The Microsoft Office installation application may start.

Click OK – Enter MNGR password if prompted – (ignore any failure to write to log errors)

14. Start Microsoft Excel if not already started
15. Choose Start > Run.

The Run dialog box appears.

16. In the Open box, type the following:

runas /user:mngr “<folder_to_excel_executable>\excel.exe”

and then click OK.

For Office 2007, where the default installation folder is C:\Program Files\Microsoft Office\Office12\excel.exe, you would type:

runas /user:mngr “C:\Program Files\Microsoft Office\Office12\excel.exe”

17. If prompted, complete the details in any Microsoft Excel dialog boxes, such as typing the user name and initials, and selecting the help and Windows update options.
18. Choose Office Icon > Excel Options.

The Excel Options window appears.

19. ClickTrust Center.
20. ClickTrust Center Settings.

The Trust Center window appears.

21. Click Medium and click OK.
22. Click on the Disable all macros without notification option button.
23. Click OK to close the Trust Center
24. Click OK to close the Excel Options window
25. Click Add-Ins – Uncheck all possible check boxes
26. “Click ‘Add-ins’ and confirm that MEDE is listed under ‘Active Application Add-ins’; add if necessary under Manage Excel Add-ins, GO”
27. Logoff and Logon using Windows account local administrator rights.
28. Choose Start and type msc in the search box.
29. The Local Security Policy window appears.
30. Expand the Local Policies item and then click on the User Rights Assignment
31. Double-click on the Deny log on locally

The Deny log on locally Properties window appears.

32. Click Add User or Group.

The Select Users, Computers, Service Accounts, or Groups window appears.

33. Click Locations.

The Locations window appears.

34. In the Location list, select the computer name, and then click OK.
35. Click Object Types.

The Object Types window appears.

36. Select the Groups check box and click OK.
37. In the Enter the object names to select box, type Local Servers.
38. Click Check Names and ensure that the name can be resolved.
39. Click OK.
40. Click OK to close the Deny log on locally Properties
41. Close the Local Security Policy