if m having data in 5 excel sheets and each excel sheet consists of 10 different sheets then in qlikview is it possible to load all excells using single load statement?
This topic already has many discussions, you can do a search for it.
Please see these 2 threads. If you search you will find many other discussions also.
http://community.qlik.com/message/38563#38563Excel with multiple sheets
Retrieving data ...