H
Hansje
I have a pivot table linked to an SQL database via a Cube
file. I would like to have automatic refresh on this file,
but I need to enter a password to get accsess to the SQL.
There is an option under Table options that should store
the pasword for the database (from Help):
"If your database prompts for a password every time you
refresh, you can have Excel save the password so you won't
have to enter it repeatedly. On the PivotTable toolbar,
click PivotTable or PivotChart, click Table Options or
Options, and then select the Save password check box. This
option saves the password as readable text, so if security
is a greater concern than convenience, you may not want to
use this option."
but this do not work. Any ideas about how I can get the password stored
automaticly?
file. I would like to have automatic refresh on this file,
but I need to enter a password to get accsess to the SQL.
There is an option under Table options that should store
the pasword for the database (from Help):
"If your database prompts for a password every time you
refresh, you can have Excel save the password so you won't
have to enter it repeatedly. On the PivotTable toolbar,
click PivotTable or PivotChart, click Table Options or
Options, and then select the Save password check box. This
option saves the password as readable text, so if security
is a greater concern than convenience, you may not want to
use this option."
but this do not work. Any ideas about how I can get the password stored
automaticly?