I have been using the excel to create olap cubes.(.cub files)

If you go to the menu and select data , get External Data , New
database query and follow the mentioned steps, you end up creating a
..cub file , a .dqy file and a .oqy file

I have been fetching data from the oracle database using the excel
built in feature.

Uptil now the dataset was small,around 10,000 records, I have been
able to create the olap cube successfully.

But now when the dataset is very large ,say 80,000 or 1,00,000 records
the cube creation process fails at the last step of the wizard.

What I feel is that while creating the query , excel dumps the data
from the tables into the excelsheet.

If the data is small in size i.e 64000 records then there is no
problem.
But if the records are around 1 lakh or even 80,000 , excel's
limitation comes into play.

Now is there any way to overcome this limitation and continue building
the cube using excel's feature itself.