JET has certain limitations that may be the reason for you not being able to connect with the excel sheet. These include a limit of 255 columns, as well as, 255 characters in length. Hope this provides some insight to your issue!
Thanks for the reply.
I am using a Trial version of Tableau.My excel sheet contain only 20 columns and 900000 rows.When I connect with this 250MB excel sheet I am getting an error message saying "check the server is running or you do not have permissions for accessing the server"
But when I connect with the same excel sheet deleting 80% of data and making 8MB,then tableau is able to connect to it.
Is it because of trial version that I am using? or the volume of data is constraint?