inserting rows

[Brian]

I have just developed a problem with my Excel. When I try
to insert a row I get a message "To prevent possible loss
of data,Microsoft Excel cannot shift Non blank cells off
the worksheet" this is a new message. What has changed?

 

[Mark Graesser]

Brian,
Excel is limited to 65536 rows. When you go to insert a row Excel needs to drop off the last row. The warning is coming up becuase you have data in the last row.

Regards,
Mark Graesser
(e-mail address removed)

 

[Nigel Graham]

You get the same error if you have hidden cells which contain data or
functions. Try unhiding all cells then insert rows.
--
Nigel Graham

Brian,
Excel is limited to 65536 rows. When you go to insert a row Excel needs

to drop off the last row. The warning is coming up becuase you have data in
the last row.

 

[Dave Peterson]

Here's another thread that you may want to read:

http://google.com/[email protected]

(posted by Debra Dalgleish)

 

[Gord Dibben]

Marla

Check out this thread from google search.

http://www.google.com/[email protected]

Gord Dibben Excel MVP