Results 1 to 5 of 5

Thread: Insert new row issue in excel 2000

Threaded View

  1. Feb 3rd, 2006, 09:04 PM #1
    erickwidya
    erickwidya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Insert new row issue in excel 2000

    i got issue in excel, can't insert new row
    the error said
    to prevent possible lost of data, MS Excel cannot 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, u can move the data to a new location then try again
    what is it means?

    first it can insert 4 rows, after that the error comes up..but if i delete 1 row then insert another..it's ok..

    thx
    Last edited by erickwidya; Feb 5th, 2006 at 08:50 PM.

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -

    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width