Excel 2002 : How to open all link files at one go ?
 

Dear Sir,

If I have file A link to file B, C, D and so on, can I open all the link
files by opening only file A ? If yes may I know how to do it ?

Currently I can see only two buttons for me to update or not to update the
data of the link cells in file A when I open it.

No other link files are opened automatically as I open file A.

I would be glad if you could advise me on this.

Thanks

Low

--
A36B58K641

Excel 2002 : How to open all link files at one go ?
 

Maybe place all those files in a workspace so they open together?


Gord Dibben MS Excel MVP

On Fri, 6 Jul 2007 08:36:00 -0700, Mr. Low
wrote:

Dear Sir,

If I have file A link to file B, C, D and so on, can I open all the link
files by opening only file A ? If yes may I know how to do it ?

Currently I can see only two buttons for me to update or not to update the
data of the link cells in file A when I open it.

No other link files are opened automatically as I open file A.

I would be glad if you could advise me on this.

Thanks

Low