hi all, wants to ask for some help... i have an excel pivot report, this pivot based on an external data source (sql server via odbc). i want to make this pivot to refresh everytime i open the report, so i choose the save password option for external data. and because i save the password, everybody can change the query for this pivot, is there any way that i can get automatically refresh pivot and also secure pivot?


plss helpp..

tx