James, if the workbooks you want to update are not open, then Bob Phillips'
article on SUMPRODUCT might be useful to you.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
See the Advantages of SUMPRODUCT section. Note that SUMPRODUCT can refer to
a single cell, if desired. James

"James" wrote in message
ups.com...
On Aug 30, 10:06 am, BigPig wrote:
Hi James,

I'm sorry, just reread your post.

Yes, but you'd have to use vba.



"James" wrote:
Is it possible to update cell a1 in 7 different workbooks or files at
the same time? Thanks.- Hide quoted text -

- Show quoted text -

Thanks, do you happen to know how to write that code? Thanks.