Specifications

Using Microsoft Excel Data Exchange
PlantScape Server and Client Configuration Guide 457
To select a function:
a) From the Function Category list, click User Defined.
b) Select a function from the Function Name list.
c) Enter any required details for the function.
For a more detailed explanation of each Microsoft Excel Data Exchange function,
see “Microsoft Excel Data Exchange Functions” on page 461.
Changing the Data Updating Rate
Dynamic data on the worksheet is data retrieved by formulas. It includes data
retrieved using the Microsoft Excel Data Exchange Wizard when the Paste values
checkbox is unchecked (refer to “Using the Microsoft Excel Data Exchange
Wizard” on page 454).
To check or to change the data update rate, select Tools
⇒
Microsoft Excel
Data Exchange. The current setting for the active user account is selected. To
change it, select the setting you want.
For best performance, the update rate should be greater than 5 seconds. The
more formulas used in a worksheet, the more work has to be performed every
time the worksheet is updated. With a large number of formulas, the time taken
to update a worksheet might exceed the specified update rate.
Enabling Microsoft Excel Data Exchange under Different User Accounts
Microsoft Excel Data Exchange can only be installed for the current user account.
If you log in under a different account, for example mngr, engr, or oper, you
cannot see Microsoft Excel Data Exchange in Excel.
The following instructions show you how to enable Microsoft Excel to recognize
a range of different user accounts. They assume that Microsoft Excel has been
installed and Microsoft Excel Data Exchange has been installed to
\CLIENT\XLDATAEX.
1 Start Microsoft Excel.
2 Check to see if the Microsoft Excel Data Exchange choice is in the Tools
menu.
Caution
Do not use the Function Wizard for any PUT functions, as this may
write undesired values to the server. See the Caution in “Microsoft
Excel Data Exchange Functions” on page 461 for more details.
plscpcg.book Page 457 Monday, May 28, 2001 10:11 AM