ERROR: 'Could not access the Excel cells. Make sure the range is valid.'

Applies To: AutoMate 6, AutoMate BPA Server 7, AutoMate 7, AutoMate 8, AutoMate BPA Server 8
Published: 1/20/11 , modified January 26, 2011
SYMPTOMS
The 'Could not access the Excel cells. Make sure the range is valid.' error message is received when running the "Dataset To Cells" action.

CAUSE
The dataset is either empty or exceeds Microsoft Office Excel's limitations.

A Microsoft Office Excel worksheet contains 65,536 rows and 256 columns. You cannot increase the number of rows or columns beyond the maximum row and column limits. If the dataset exceeds the maximum limits, then the error message will occur.

RESOLUTION
Ensure that the dataset does not exceed Excel's maximum limitations AND contains at least one row of data. The dataset generates the following fields for reference:

datasetname.totalrows
datasetname.totalcolumns