Copy and drag array formulas

[Mike Baker]

I have a very large spreadsheet that has a number of columns containing array formulas. I am extending the sheet by introducing more columns to the right of the existing spreadsheet. The problem is that when dragging the formulas down they will only copy so far and no further. I've checked the content of the empty cells and they are not locked. I've tried both automatic and manual saves to no avail. Any ideas will be gratefully received. Incidentally, I am running Excel 2000.

Thanks!

 

[Mike Baker]

No, the sheet is not protected nor the cells locked.