There are no limits that you'd encounter with reasonable Excel usage.
Data size limits per sheet not cumulative.
Is this a test question or you hitting some issues in real life?
this is not for a test, I am hitting some issues in real life with data
When you say "and if it crosses this limit ", are you talking about rows?
If this is the situation i suggest you to upgrade Tableau to version 10 and union all sheets into one data source. If you can't upgrade, i suggest you to load them into an open source database to load in Tableau.
Thank you for your suggestion, Yes I am talking about the rows limit in the Tab. we are planning to upgrade to 10 soon, so I think it will resolve problem, hope the best.
thank you for your efforts.
Unfortunately version 9.3 is not good for your issues.
Once i needed something like that and the solution was to create a sheet with all keys and make left join of all other sheets on the key sheet.
This is not good but at least data blend was not necessary and this eliminated granularity problems.
You can build a xls with all sheets and few lines on desktop to build data source and after load all rows on server.