sorry hit wrong key ... here is rest of reply

after F9 you will see the array formula instead of the normal rang
notation.

The graph is frozen.

NB This does NOT toggle back with another F9

I think that you would have to redefine the source data to get back t
Square 1.

It may be OK for you to save the Frozen version with another name, an
then continue with the original ?


If you want this done in VBA you need another helper :)

best regards .. Roge

--
Message posted from http://www.ExcelForum.com