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.

Try to reset the used range. Excel thinks that you have data in the last
rows/columns

http://www.contextures.com/xlfaqApp.html#Unused


--


Regards,


Peo Sjoblom


"Dave P" <Dave wrote in message
...
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.