Cannot modify or delete arrays in shared workbook - Solution

[ivark143]

Hi,

I have previously posted some problem. I got solution too.

http://www.mrexcel.com/forum/showthread.php?p=1777407#post1777407

Now there is different issue. My workbook is shared workbook.

When I enable this option my array formula is working but I am not able over write the value which contains array formula in the workbook.
It is saying "Cannot modify or delete arrays in shared workbook".

Can anybody help me . You are life saver to me..