Pivot table access - Connection
 

I've created a connection to a Analysis Server where my cube is. Then
created 6 pivot tables in one spreadsheet pointing to 'MyCube'. I have a
small macro to refresh the tables, but when I give the XLS to another user
they are prompted with user ID and passwords for each Pivot table.

How do I at least cut the prompts down to once or gather the users LAN ID
from their computer to correct the connection?

Thank you

Pivot table access - Connection
 

Hi Candyman,

You didn't tell us what version of Excel you are running and I don't work
with Analysis Server so this is just an idea:

Select a pivot table and choose PivotTable, Table Options, and turn on Save
Password.

--
Cheers,
Shane Devenshire


"Candyman" wrote:

I've created a connection to a Analysis Server where my cube is. Then
created 6 pivot tables in one spreadsheet pointing to 'MyCube'. I have a
small macro to refresh the tables, but when I give the XLS to another user
they are prompted with user ID and passwords for each Pivot table.

How do I at least cut the prompts down to once or gather the users LAN ID
from their computer to correct the connection?

Thank you