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. I have lokked at the OQY file, and
that is storing my username but not my password. Can
anyone help me with the password command so I can edit the
OQY manually?

OQY:
"UID=talien; APP=Microsoft Office"