Query ID:
20160708-01

Query:
Excel Report gives error code 3021, no current data

Date:
08 July 2016 11:30:00

Related Products:
UltraSoftBIS Excel Reports/Analysis

Solution:
This Excel VBA (Visual Basic for Application) Error Code 3021 means that there are no data for the report selected. This is not a bug in Excel or in the Excel VBA code for the report.

If you believe that you have data for the report you are running, please try the following:

• Select the parameter e.g. Centre Name, User, Cluster, etc. and try again.
• Try selecting the parameter using the mouse, e.g. clicking on dropdown item
• If you need date range or parameter, make sure that these are valid.

 

This should resolve your query.