Hi ,

I am facing a problem in Using Drag & Drop formula in Excel 2003 recently.

While I put a formula in one cell Say B1 w.r.t. the refrenec in cell A1, I get the results. But when I drag the formula in B1 to successive cells in column B w.r.t. the corresponding refrences in column A, the formula does not work & the value in cell B1 is simply copied in each cell.

I have been using this from the past several months but now it is not working. I have checked the Options:Edit:Drag & Drop(Yes). But nothing is working.

Since I have a lot of data , this functionality is of great help to me.

What Should I do, Pl. help

Laxmi