Refresh Multiple Pivots but only type username and password once?

[kenny789]

Hi, hopefully I'm posting in the correct section! I have a spreadsheet which has multiple pivots. The pivots pull in data from an external data source/database. The issue I have is when I hit the refresh all button, I'm prompted for the same username and password for each pivot. In all there is something like 35 pivots so that's 35 times I need to enter the same data.

I'm wondering if anyone has a way where I can just pass the username and password in once and then it filters out to the other pivots? I'd imagine there must be a better way of doing this than what I have built!

I'm using excel 2003.

Thanks in advance, any help would be appreciated.

[kenny789]

Has anyone done this before?

[Domski]

Please take a moment to read the forum rules.

If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

Wait a day before bumping your thread in future please.

Dom

[Domski]

What you are asking requires VBA. If you upload a sample workbook I'll have a look tomorrow if nobody else has picked this up before.

Dom

[Domski]

Cross posted here: http://www.mrexcel.com/forum/showthread.php?t=622221

Kenny789 please read this: http://www.excelguru.ca/content.php?184

Dom