Error exporting dataset to excel using foreach loop

Hello,
I am trying to export data set to excel using foreach loop in STATA 13.1. But the stata throws the error observations must be between 1 and 1048576
r(198);

I have changed the extension for excel from xls to xlsx. Still I am getting the above error.