Only through VBA and opening one file at a time in turn.

See Ron de Bruin's site for assistance.

http://www.rondebruin.nl/copy4.htm


Gord Dibben MS Excel MVP

On Fri, 12 Sep 2008 14:05:01 -0700, MikeR-Oz
wrote:

Can this be done ?

I have several workbooks / xls files . They have the same format /setup so
I would like to make a change to a formulae in one on say cell B3 and have
the change be made across all the other workbooks/ files.

Your help appreciated

Mike