Thanks Bill,

That was my back-up plan. It's a bit unfortunate as I actually
underestimated the problem - there are actually 2 other linked files - one is
20MB the other is 10MB and both have some hefty calculations in them. This
means that calculating/saving whilst they are open takes ages.

Do you know what causes this issue? If it was a standard range reference
(rather than named range) would this happen? Or is is the fact that the named
range is calculated?

Thanks,

Basil

"Bill Manville" wrote:

I think the only solution is to have both workbooks open.
You could have a macro in B open A read-only and make it invisible if
that helped.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

.