Prerequisites for integrating Excel and Symphony

Excel version

  • Microsoft Office 2000

  • Microsoft Office 2002

  • Microsoft Office 2003 SP2

  • Microsoft Office 2007

Symphony version and platforms


Table 1. Symphony and Symphony DE version 5.1 on the following Windows operating systems:

Operating System

Windows Server 2003

Windows Server 2003 Standard Edition

Windows Server 2003 Enterprise Edition

Windows Server 2003 R2 Standard Edition

Windows Server 2003 R2 Enterprise Edition

Windows XP

Windows XP Professional

Windows 2000

Windows 2000 Server

Windows 2000 Professional

Windows Vista

Windows Vista Business

Windows Server 2008

Windows Server 2008 Standard Edition


Install Excel

  1. Install Excel on all compute hosts. Refer to Excel documentation for more details.
  2. Ensure that all Microsoft Office components are installed on each compute host. Do not use the "install on first use" option during installation. This option causes Excel to pop up dialogs that cannot be programmatically removed.
  3. Log onto all compute hosts at least once with the user account under which Symphony workload will be executed, to initialize the data associated with this user profile.
  4. Set Excel macro security to Low. This prevents security dialogs from displaying. For Excel 2000, 2002, and 2003, go to Tools > Macro > Security. For Excel 2007, on the Developer tab, in the Code group, click Macro Security.

Install Symphony

Install Symphony DE on the client host and Symphony on the compute and management hosts. The system environment variable SOAM_HOME should point to the Symphony DE installation directory.