Updating Links from Password protected Workbooks

Hi all
I'm having a problem with a pivot table I am using and am hoping (praying!!) that someone can help!! There are two worksheets, one that contains the "Raw Data" and one that hosts the pivot table summarising the raw data. The raw data is a series of links from 9 seperate password protected workbooks. When the workbook opens and attempts to update the links it requests the password for each sheet. This cannot work as the passwords need to be unique to the users of each spreadsheet!!

I am hoping to use a command button to update the links embedding the passwords inside the code, unfortunately I am hitting a brick wall with all I've tried so far! I am using a macro assigned to the command button but my VB script is pretty basic. Any help would be greatly appreciated

There is no method I am aware of to provide the password when updating links in code, other than to actually open the workbooks themselves. Is that an option?

If you can't update the links when the source workbooks are open, then there is something seriously wrong with your Excel installation. What actually happens when you do that - an error, nothing or what?

What was the macro?

Do those source workbooks contain links to other files too?

You don't actually need to run UpdateLink if the source is open:

Please Login or Register  to view this content.

Thanks - the film career keeps me busy between posts...