View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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