Hi there,
I have got a webi report that, when run, produces over 65000 records. When I try to save the output as an excel spreadsheet it defaults to Excel 97 - 2003 even though I've got 97-2003 and 2007 versions on my machine. If I use this option it only saves the first 65000 records and discards the rest.
Is there any way of saving the output as a 2007 excel spreadsheet so that I get all of the records.
The version of webi I'm using is 11.0.0.1952
Many thanks for any help.