+ Reply to Thread
Results 1 to 5 of 5

Excel Error: T prevent possible loss of data, Microsoft Excel cannot shift nonblank cells

  1. #1
    Registered User
    Join Date
    12-12-2017
    Location
    Qatar
    MS-Off Ver
    365
    Posts
    26

    Excel Error: T prevent possible loss of data, Microsoft Excel cannot shift nonblank cells

    I am working on a spreadsheet for quite some time and suddenly it is giving me an error - "To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet" whenever I try to insert a row.

    I tried all the possible solutions that I found online such as removing formatting, going to the end of the worksheet to clear the cells, amongst others, but none of them work so far.

    Is there any other solution to this error?

    TIA!

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Excel Error: T prevent possible loss of data, Microsoft Excel cannot shift nonblank ce

    Good morning mathematix

    The only time I have seen this error is when there is data (or formats) in the very last row of Excel's sheet (ie 1048576).

    You need to recheck and delete the entire row and try again. If you are trying to delete multiple rows, the data may not necessarily be in the very last row.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    12-12-2017
    Location
    Qatar
    MS-Off Ver
    365
    Posts
    26

    Re: Excel Error: T prevent possible loss of data, Microsoft Excel cannot shift nonblank ce

    Hi, thanks! I did try to go to the last row and last column but they are all empty.

    I even selected the row after the row where there is a data and did the same thing for columns but it still doesn't resolve the issue

  4. #4
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Excel Error: T prevent possible loss of data, Microsoft Excel cannot shift nonblank ce

    Hi mathematix

    Can you post the workbook. You can probably delete all the data - we don't need to see that, just the basic structure.

    HTH

    DominicB


    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitise the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  5. #5
    Registered User
    Join Date
    12-12-2017
    Location
    Qatar
    MS-Off Ver
    365
    Posts
    26

    Re: Excel Error: T prevent possible loss of data, Microsoft Excel cannot shift nonblank ce

    For some reason, it is now fixed! LOL

    I don't know what I did but the error just disappeared

    Thanks Dominicb

+ 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:1004 Prevent possible loss of data while running VBA Code
    By shiva_raj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2017, 06:34 PM
  2. Prevent Loss of Data -- Error Message Pops Up
    By brit1sh in forum Excel General
    Replies: 3
    Last Post: 09-11-2013, 01:30 PM
  3. cannot shift nonblank cells off worsheet
    By divi123 in forum Excel General
    Replies: 1
    Last Post: 06-11-2013, 07:54 AM
  4. error1004 cannot shift nonblank cells off worksheet
    By plato in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2012, 08:52 AM
  5. Replies: 3
    Last Post: 06-14-2011, 04:46 AM
  6. Run-time error 1004: Cannot shift nonblank cells off the worksheet
    By Bryan.Cook@gmail.com in forum Excel General
    Replies: 1
    Last Post: 04-10-2006, 01:15 PM
  7. Excel cannot shift nonblank cells
    By Mr. Maz. in forum Excel General
    Replies: 2
    Last Post: 03-17-2005, 08:06 PM

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