Check by using CTRL + End and see where Excel takes you.

Could be Excel thinks you have data in the bottom row of the worlsheet so it
won't shify cells down for inserting a row.

If CTRL + End takes you to bottom of sheet, delete unused rows then save the
workbook.


Gord Dibben MS Excel MVP

On Tue, 13 Apr 2010 05:42:04 -0700, sree
wrote:

Hi,
I have a simple excel sheet which is saved in eencrypted format. I am unable
to insert rows in the same. Whenever I try, it says, 'To prevent possible
loss of data, Excel cannot shift non-blank cells off the document...'. Could
find what the real problem is.