Report from Excel Spreadsheet gives 10+ blank pages of details before...
I must be doing something stupid here but I just can't see it.
I've created a new connection to a simple Excel spreadsheet but when I display the data, I get about 10 pages of blank detail before I get the actual detail that I'm looking to display at the bottom.
Any ideas what I'm doing wrong??
Edit.....It's also telling me there are 2700 records when there are only actually 30? It seems to be picking up blanks from somewhere but I have no idea where as all rows and columns in the spreadsheet are consecutive.
Edited by: Graham W on May 28, 2011 1:54 PM