Tags: cells, column, excel, excel97, insert, loss, message, microsoft, msdn, nonblank, prevent, shift, software, worksheet

Cannot insert column

On Microsoft » Microsoft Excel

2,892 words with 2 Comments; publish: Fri, 23 May 2008 20:12:00 GMT; (306265.63, « »)

Trying to insert a column in Excel97 getting message:

To prevent possible loss of data, Microsoft Excel cannot

shift nonblank cells of the worksheet. Try to delete or

clear the cells to the right and below yor data. Then

selectcell A1, and save your workbook to reset the last

cell used. Or, you can move the data to a new location

and try again.

Nothing seems to work and I need to insert another

column. Anyone ever run into this?

All Comments

Leave a comment...

  • 2 Comments
    • Sandra,

      Can you post the code'

      My guess is that it is not just inserting a column.

      >--Original Message--

      >Trying to insert a column in Excel97 getting message:

      >To prevent possible loss of data, Microsoft Excel cannot

      >shift nonblank cells of the worksheet. Try to delete or

      >clear the cells to the right and below yor data. Then

      >selectcell A1, and save your workbook to reset the last

      >cell used. Or, you can move the data to a new location

      >and try again.

      >Nothing seems to work and I need to insert another

      >column. Anyone ever run into this?

      >.

      >

      #1; Fri, 23 May 2008 20:14:00 GMT
    • The following MSKB article may help:

      XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns

      http://support.microsoft.com/default.aspx?id=211769

      Also, Dave Peterson posted this a couple of days ago:

      '================Someone with the same problem posted back that their comments were

      getting resized causing the trouble.

      Maybe enabling: Tools|Options|View|Comment and indicator

      (at least for a little bit will help.)

      '========================

      Or, perhaps William's suggestion in the following posting will help:

      http://groups.google.com/groups?hl=en&selm=%23SyiwlGICHA.2580%40tkmsftngp09

      He advised the following:

      '======================="if you have a button on your worksheet, right click on the button,

      select "Format Control", select "Properties" and then select "Move and

      Size with cells"

      '========================

      sandra wrote:

      > Trying to insert a column in Excel97 getting message:

      > To prevent possible loss of data, Microsoft Excel cannot

      > shift nonblank cells of the worksheet. Try to delete or

      > clear the cells to the right and below yor data. Then

      > selectcell A1, and save your workbook to reset the last

      > cell used. Or, you can move the data to a new location

      > and try again.

      > Nothing seems to work and I need to insert another

      > column. Anyone ever run into this?

      Debra Dalgleish

      Excel FAQ, Tips & Book List

      http://www.contextures.com/tiptech.html

      #2; Fri, 23 May 2008 20:15:00 GMT