Getting excel to update links without opening the file..

Does anybody know if there is a way in which I can get excel to update my links in a spreadsheet without me having to open the file myself? i.e set it to update the links at certain time intervals or on a certain day? or am i simply asking too much of excel!

Excuse my simplicity... why do you need the links up to date if you don't open the file?

Because I have about 10 workbooks, all linked to various other workbooks, i then have a totals workbook which is in turn linked to these to summarise them. Instead of opening each of the 10 to update them it would be easier and quicker if there was a way in which they updated themselves.

So the workbooks would need to calculate based on their updates too?

I think you may need to open them for this, you can shell a hidden instance of Excel so it appears background, but I think you need the app to run for the formulae to update.

I may be wrong...

Put a BAT file with workbook drive:/path/name in your Windows Scheduled events to do it. It's Open event would open all the others, update the links and then close each. Lastly, it would do a ThisWorkbook.close.

Disable macros when you open it by security mode if you need to edit it again.

So let me see if I understand...
You are going to have a "main" workbook open. It needs to update 10 other sheets that are closed? I just recently used some code in my workbook that links to a closed workbook. I had some help here in the process but perhaps you could use it as well.

Sorry everyone, wasnt quite clear enough on that! Each week I will open the 'Totals' file and update that myself, this file is linked to my 10 raw data workbooks (lets call these Group A) which are in turn linked to other raw data workbooks (call these Group B)...

'Group A' need to automatically update themselves from 'Group B'. Then with these all up do date I can go and manually open the 'Totals' workbook and update those links to 'Group A' manually.

If that makes sense?...a bit long winded, i know!

Thanks.