3 Replies Latest reply: Aug 15, 2014 1:36 AM by Phil 1960
LeonardJG Level 1 Level 1 (0 points)

I use Numbers for my business accounts. However, upon opening the password protected spreadsheet today, I am unable to add rows to one of the tables in the spreadsheet.


The table contains 257 rows and 10 columns, a mixture of text, numbers and currency formats, and some formulas. Has been working fine up until now.


I am able to add columns. Right clicking, the 'Add Row Above/Below' options are greyed out. Dragging the table from the bottom corners does not work. When I hit return from the bottom right cell I get the error chime.


I have dragged the .plist preference file out on to the desktop as advised in a different questioners thread, but still no joy.


Anyone have any ideas?

Mac Pro (Early 2008), Mac OS X (10.6.8)
  • Level 8 Level 8 (41,790 points)

    May you copy then paste the table in a new document ?

    With a bit of luck it will behave correctly.

    If it doesn't, change the private values then send the modified document to my maibox (click my blue name to get my address).


    Of course, you may also try to open the document from an alternate user account.


    Yvan KOENIG (VALLAURIS, France) lundi 30 avril 2012

    iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3

    My Box account  is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

  • Mike Mesford Level 1 Level 1 (25 points)

    I was having the same problem.  That's how I ended up here.  But then it occured to me that I had filtered the table on a certain value.  I reset the filter and all is well.  It makes sense: you can't add to afiltered view because the new row wouldn't have the filtered value yet.  And if it allowed a blank row you might enter a value contrary to the filter.



  • Phil 1960 Level 1 Level 1 (0 points)



    You reminded me that I had filters on. - It is obvious - Now !

    Thank you