+ Reply to Thread
Results 1 to 4 of 4

Prevent Loss of Data -- Error Message Pops Up

  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Prevent Loss of Data -- Error Message Pops Up

    What is this error message that is popping up when I try to insert a blank row of cells?

    "To prevent possible loss of data, Excel cannot shift nonblank cells off of the worksheet. Select another location in which to insert new cells, or delete data from the end of your worksheet.

    If you do not have data in cells that can be shifted off the worksheet, you can reset which cells Excel considers nonblank. To do this, press CTRL + End to locate the last nonblank cell on the worksheet. Delete this cell and all cells between it and the last row and column of your data then save."

    This excel document we have has LARGE amounts of data and we can't afford to lose any of it.

    -Brit

  2. #2
    Registered User
    Join Date
    09-11-2013
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Prevent Loss of Data -- Error Message Pops Up

    excel_error.png

    I have attached an image for reference.

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Prevent Loss of Data -- Error Message Pops Up

    Welcome to the Forum brit1sh!

    Excel seems to think that you are using all available rows (over a million) so it is warning you that there is no more room to insert. Did you follow the instructions in the error message?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Registered User
    Join Date
    09-11-2013
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Prevent Loss of Data -- Error Message Pops Up

    Ah I see. I'll give it a go! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. error message pops up
    By louise2613 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-21-2012, 12:36 PM
  2. If user types in a wrong value, then an error message pops up
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2012, 02:26 PM
  3. Error-the message 'Device I/O error' pops up.
    By lehainam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2006, 01:26 AM
  4. How to prevent error message during macro
    By excelnut1954 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2006, 10:10 AM
  5. Prevent Error Message
    By phil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2005, 03:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1