Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 13th 09, 05:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
Posts: 2
Default Error message "cannot shift nonblank cells off the worksheet"

- I "inherited" an Excel template at work, author unknown (v2003 SP3).
- I get a sporadic error message when I try to insert a row or copy/insert a
row.
- Suggested fix most often does not work. Sometimes it resolves by itself.
- I don't know what I am doing to cause the error, nor how to fix it when it
happens
- I am stuck and need help from someone familiar with this issue. Thanks.

Error message: "To prevent possible loss of data, Microsoft Office Excel
cannot shift nonblank cells off the worksheet. Try to locate the last
nonblank cell by pressing CTRL+END, and delete or clear all in cells between
the last cell and the end of 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."

  #2   Report Post  
Old June 13th 09, 06:10 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default Error message "cannot shift nonblank cells off the worksheet"

The "suggested fix" was??


Gord Dibben MS Excel MVP

On Sat, 13 Jun 2009 09:45:01 -0700, CDelphi
wrote:

- I "inherited" an Excel template at work, author unknown (v2003 SP3).
- I get a sporadic error message when I try to insert a row or copy/insert a
row.
- Suggested fix most often does not work. Sometimes it resolves by itself.
- I don't know what I am doing to cause the error, nor how to fix it when it
happens
- I am stuck and need help from someone familiar with this issue. Thanks.

Error message: "To prevent possible loss of data, Microsoft Office Excel
cannot shift nonblank cells off the worksheet. Try to locate the last
nonblank cell by pressing CTRL+END, and delete or clear all in cells between
the last cell and the end of 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."


  #3   Report Post  
Old June 15th 09, 06:24 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
Posts: 2
Default Error message "cannot shift nonblank cells off the worksheet"

From the error message: "Try to locate the last nonblank cell by pressing
CTRL+END, and delete or clear all in cells between the last cell and the end
of 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."

"Gord Dibben" wrote:

The "suggested fix" was??


Gord Dibben MS Excel MVP

On Sat, 13 Jun 2009 09:45:01 -0700, CDelphi
wrote:

- I "inherited" an Excel template at work, author unknown (v2003 SP3).
- I get a sporadic error message when I try to insert a row or copy/insert a
row.
- Suggested fix most often does not work. Sometimes it resolves by itself.
- I don't know what I am doing to cause the error, nor how to fix it when it
happens
- I am stuck and need help from someone familiar with this issue. Thanks.

Error message: "To prevent possible loss of data, Microsoft Office Excel
cannot shift nonblank cells off the worksheet. Try to locate the last
nonblank cell by pressing CTRL+END, and delete or clear all in cells between
the last cell and the end of 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."





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot insert rows -error message "cannot shift object off sheet" robwan Excel Discussion (Misc queries) 1 November 10th 07 03:01 PM
Error message: "cannot shift object off sheet" Peter Vickers Excel Worksheet Functions 4 December 8th 06 04:52 PM
Why I am getting Error Message: "Cannot shift objects off sheet"?? GreenInIowa Excel Worksheet Functions 0 March 23rd 06 06:05 PM
I get an error message that says "Cannot shift object off a page" JZygmun Excel Discussion (Misc queries) 1 March 7th 06 02:18 AM
Error Message: "Cannot shift objects off sheet." AndrewS Excel Discussion (Misc queries) 1 January 11th 06 04:09 PM


All times are GMT +1. The time now is 07:59 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017