Thread
:
Warning while inserting lines in Excel 2000
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Peo Sjoblom
external usenet poster
Posts: 3,268
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.
Reply With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom