Arrow Storage Products EN106 Guia do Utilizador descarregar pdf (Página 116)

Figure 112 Retrieval on a Worksheet Containing the EssCell Function

Now update the EssCell functions to retrieve data for a different state.

4 Change the contents of cell A2 from Texas to Florida.

The values in cells B16 and B17 are updated as soon as you update the cell. The update occurs

because Excel has recalculated the worksheet (if you have configured Excel to calculate changes

automatically). The remaining data cells do not change. To completely update the worksheet,

you must retrieve data from the server.

Figure 113 Updating the EssCell Function

Tip:

If the worksheet contains many EssCell functions, change the spreadsheet to manual calculation

mode. This change prevents the cells that contain EssCell functions from calculating until you

retrieve data or calculate the worksheet manually. For more information on manual calculation

mode, see the Excel documentation .

5 Select Essbase > Retrieve to update the report.

Essbase returns an error message if EssCell is unsuccessful. Table 4 lists messages that Essbase

displays in the EssCell cell and explains the conditions that cause the messages:

116

Advanced Tutorial

1 2 ... 111 112 113 114 115 116 117 118 119 120 121 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 116