Sorry for disappearing, but was too tied up. Thanks to royUK for clarifying my suggestion. You're right about the OPEN event - that's where the macro code needs to be. The setting for Not updating links also looks fine. Here's the code you asked for.
First, you'll need the names of all the files you are using - including full path names.
For each of these files you'll need to use the Workbooks.Open command
Eg, if you have a file
With the password
Then the command to open this file would be
Workbooks.Open FileName := "C:MypathFirstFile.xls", Password:= "abc"
And so on for each file.
This method will involve a lot of typing for 33 files. A better way would be to dump all your file names into Excel, and then use concatenation to build your Workbooks.Open commands. These can then be copy/pasted into the Visual Basic Editor to save on keyboarding.
Let me know if you need further help with this.
Video Tutorials / Excel Dashboards Reports