BDM throws error in excel if it has to read data more than 65000 rows
Since i am using system which is compatible of 64 bits , but some how excel understand as 32 bit system and uses only 65000 rows instead of 1 million rows .
The microsoft excel which i installed got 1 million rows , but while reading data through BDM it can accomodate to 65000 and throws error and it wont read data more than 65000 rows .
Is there any work around to read data more than 65000 rows .
Thnk you in advance