+ Reply to Thread
Results 1 to 8 of 8

Error Message when inserting row ????

  1. #1
    Forum Contributor
    Join Date
    04-10-2006
    Location
    Somerset
    MS-Off Ver
    MS Office 2007
    Posts
    103

    Error Message when inserting row ????

    Hi,

    Can't insert new rows as following error message appears ????

    Any way around this ?

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    You didn't attach your error message.

    Do you perhaps have all possible 65535 rows filled already?
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Contributor
    Join Date
    04-10-2006
    Location
    Somerset
    MS-Off Ver
    MS Office 2007
    Posts
    103
    No - rows go to 467 ?

  4. #4
    Forum Contributor
    Join Date
    04-10-2006
    Location
    Somerset
    MS-Off Ver
    MS Office 2007
    Posts
    103
    Image since attached !

    Thanks.

  5. #5
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Still no image...

    Make sure you click "upload" after you browse for the image.

  6. #6
    Forum Contributor
    Join Date
    04-10-2006
    Location
    Somerset
    MS-Off Ver
    MS Office 2007
    Posts
    103
    Sorry - uploaded under new post ?

    See:

    http://www.excelforum.com/showthread...74#post1955574

    Thanks.

  7. #7
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Have you tried what the message says... it seems there must be data somewhere in row 65535....

  8. #8
    Forum Contributor
    Join Date
    04-10-2006
    Location
    Somerset
    MS-Off Ver
    MS Office 2007
    Posts
    103
    Thank you very much - it worked.

    Yes, didn't realise that in another worksheet within book, had 65535 full up !

    Now able to insert rows!

    That's a relief !

    Thanks again.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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