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