Excel error msg when inserting new column

Giganews Newsgroups
Subject: Excel error msg when inserting new column
Posted by:  Frank Kabel (frank.kab…@freenet.de)
Date: Tue, 4 May 2004

Hi
you somehow have set the used range to the last column.
You may try the instructions on the following site:
http://www.contextures.com/xlfaqApp.html#Unused

to clear the used range. After this inserting columns
should work again

>-----Original Message-----
>I got following error msg when inserting a new column.
Does anyone
>know what the msg is about?
>
>"To prevent possible loss of data, microsoft excel can
not shift
>nonblank cells of the worksheet. Try to delete or clear
the cells to
>the right and below your data. Then select cell A1, and
save your
>workbook, to reset the last cell used. Or you can move
the data to a
>new location and try again"
>.

Replies

None

In response to

Excel error msg when inserting new column posted by ARV on 4 May 2004