| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Affect a new connection to a pivot table | Excel Discussion (Misc queries) | |||
| Connection of Excel 07 pivot table to Access Query makes DB read o | Excel Discussion (Misc queries) | |||
| Pivot Table Data Connection | Excel Programming | |||
| Copy pivot table and get rid of connection | Excel Discussion (Misc queries) | |||
| Pivot Table Connection | Excel Programming | |||
Threaded Mode
