Hi All I was wondering what the best way was to distribute pivot tables? How do you do them/ Sometimes they get huge so email is not an option. I can connect via odbc but if I send it out the user hits refresh and they lose the data because they do not have a connection. I am assuming sharepioint would help but we do not have this. I can run a query in sql server management studion and cut out the results in the viewer and paste into the raw data sheet but often the size of the result set changes, the data types change and I have to change the datasource setting in the pivots.

Also is there a link to somewhere that shows the best way to ODBC connect. I can do it but not sure I am doing it right. I use the sql server connection then it asks for a table. Do I always have to select a table befor putting in my query? I tried the ms query connection but it hung up on me when it said I can't create graphically.

mahalo, for any help... Brew