You can cancel retrieval requests that take longer than expected or if you mistakenly double-click.
Because Essbase returns data so quickly to the spreadsheet, you may not be able to cancel a retrieval before the retrieval is complete. This feature is most useful when you must stop a large retrieval request.
You can cancel a retrieve only while Essbase is processing in Spreadsheet Add-in. You cannot cancel a retrieval when Essbase is processing from the server.
To cancel data retrievals, press Preserving Formulas when Retrieving Data
Retrieving Data Into Blank Worksheets
Retrieving Data Using Functions
Retrieving Dynamic Calc Members
Retrieving in Template Retrieve Mode
Retrieving Into Formatted Worksheets
Retrieving Substitution Variables
Specifying Latest Time Period for Dynamic Time Series
Updating Data on Essbase Server
Using Advanced Interpretation to Retrieve Generation and Level Names