CLEARALLDATA

Purpose:

Clears the data from every Window in the Worksheet without removing the Window formulae.

Syntax:

CLEARALLDATA

Example:

clearalldata

 

clears the data only from each Window in the Worksheet without removing the Window formulae.

 

Save this Worksheet as a compact template. When loaded, use UPDATE to recalculate the Worksheet.

Remarks:

CLEARALLDATA is useful for creating compact Worksheet templates by preserving the formulae but not saving the Window data.

See Also:

CLEAR

CLEARALL

CLEARDATA

UPDATE