>I have a worksheet with about 4000 lines of data.
> I am trying to insert lines into the worksheet but I get the following
> warning and I can't insert the line: "To prevent possible loss of data
> Microsoft Excel can not shift nonblank cells off the worksheet."  I have
> recently inserted a pivot table as a separate worksheet and I did not have
> this problem before then, but I don't know if this is just a coincidence.