Warning while inserting lines in Excel 2000
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. |
Warning while inserting lines in Excel 2000
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. |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com