dragon_1973
New Member
- Joined
- Mar 26, 2009
- Messages
- 4
Hi All... I have an 2003 XLS file with a pivot table connected to a SQL server database. When the file was created the user created it with a normal un & pw. He has since left the company, and we would like to change this Excel to use Integrated Authentication.
In 2007, I can open the file, Click on data --> connections --> properties --> definition and edit the ADO for the connection... changing it to an SSPI connection. HOWEVER, I now cannot save this as Excel 97-2003 format or it gives a compatibility error with the pivot chart.
So, back on a machine running 2003, I want to do the same thing, but for the life of me I can't figure it out. What I can figure out how to do is create a new pivot chart creating a new connection, that is now integrated authentication... but doing this wipes out all the setup that has been done over the years to the existing pivot chart.
How can I update the connection for the data for the pivot chart? I can change the SQL, and everything else, but I can't seem to change the data connection! grrrrrr.
In 2007, I can open the file, Click on data --> connections --> properties --> definition and edit the ADO for the connection... changing it to an SSPI connection. HOWEVER, I now cannot save this as Excel 97-2003 format or it gives a compatibility error with the pivot chart.
So, back on a machine running 2003, I want to do the same thing, but for the life of me I can't figure it out. What I can figure out how to do is create a new pivot chart creating a new connection, that is now integrated authentication... but doing this wipes out all the setup that has been done over the years to the existing pivot chart.
How can I update the connection for the data for the pivot chart? I can change the SQL, and everything else, but I can't seem to change the data connection! grrrrrr.