Warning while inserting lines in Excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top