When I do these sort of things I create a (small) summary table in SQL
Server and then, using odbc black art, import it into Excel... or is the
question not based on size .i.e. security etc???

That's my tuppence worth... any use?

regards

andrew
www.jmdata.co.uk

wrote in message
oups.com...
Hello -

I'm building a pivot table and chart in Excel based on information from
SQL server. I'm noticing that the actual data is being included when I
save the spreadsheet, but I don't want to save the actual data with the
spreadsheet. I want just the table and chart definitions. How can I
link to the SQL server without actually importing the data?

Thanks