Open multiple excel workbooks with external links at once

[tabbymulla]

Hello,

I want to open multiple excel workbooks linked together with one click or one shortcut or from one place instead of going to each folder and opening the excel files.

I dont want to place them in same folder to reduce clutter and do not want to combine workbooks in one workbook as it increases the save & autosave times to unacceptable levels.

Please help.

Kind regards,

Tabby

 

[daverunt]

Hi,

have a look and see if this is what you need.

How do I automatically open linked documents in Excel?

I am having to convert all files from Quattro Pro to Excel. When I open a document in Quattro Pro which has several other documents linked, the program will automatically open all the linked documents. How do I do this in Excel? As far as I have been able to figure out, Excel only opens...

www.excelforum.com