The 'Could not access the Excel cells. Make sure the range is valid.' error message is received when running the "Dataset To Cells" action.
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.
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:
Applies To: Automate 6, Automate BPA Server 7, Automate 7, Automate 8, Automate BPA Server 8
Still have questions? We can help. Submit a case to Technical Support.