is he highlighting a cell and right click and click insert

instead suppos if he/she uses menu insert-rows
what happens?


sphilip wrote in message
...
we have o2k pro with all updates............we have a very large excel
sheet
with loads of data.

now, when a user is trying to insert a row...he gets this error:

"To prevent possible loss of data, Microsoft Excel cannot shift non-blank
cells off the worksheet. Try to delete or clear cells to the right and
below
your data"

How do we overcome this error & still insert a row.

Please know the autofitter is OFF.

cheers