Im using SQL Srver 2005 Reporting Services and Office 2007 which allows 1048576 rows of data, is there a way of telling reporting services to allow me to create spreadsheets via subscriptions with more than the 65000 rows earlier versions of Excel limit me too.
Is there a way of making the outputted spreadsheets protected so that they cannot be updated by users without a password? If not can Integration Services do it?