Specifications

20 – Using PlantScape Data in Other Applications
458 R400
• If it is not there, then continue with the following steps.
• If it is there, then you need go no further, as Microsoft Excel Data
Exchange has been successfully installed for the current account.
3 Go to the Tools menu and select Add-Ins.
4 Click Browse.
5 Navigate to the Microsoft Excel Data Exchange folder (in this case
C:\CLIENT\XLDATAEX).
6 Select MEDE.XLA
7 Click OK.
8 In response to the prompt Replace Existing ...? click Yes.
9 Click OK.
10 The Microsoft Excel Data Exchange choice should now be available in the
Tools menu.
You need to install Microsoft Excel Data Exchange for all user accounts that need
to use it.
If you want to use .xls files that have been created by other users, you need to:
1 Open the workbook
2 Click Tools
⇒
Microsoft Excel Data Exchange
⇒
Update Formulas in
Workbook
3 Save the workbook.
Interpreting Microsoft Excel Data Exchange Errors
When reading and writing data from/to a PlantScape server an error may be
encountered when a formula is executed in a cell such as:
An unknown Parameter error was encountered (-32215) with
server “matchbox” and point “29471” : matchbox : 29471 : 3
To determine the cause of the error, double-click the Error Viewer icon in the
PlantScape Diagnostic Tools group/folder.
An error message, such as the following is displayed.
Example
Enter argument(s) for display.exe (<ENTER> for none): -32215
08229 CONTROL - illegal mode for control of parameter
plscpcg.book Page 458 Monday, May 28, 2001 10:11 AM