Skip navigation

Can't add rows to a table

681 Views 2 Replies Latest reply: Nov 11, 2012 8:34 PM by Mike Mesford RSS
LeonardJG Calculating status...
Currently Being Moderated
Apr 30, 2012 6:06 AM

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,760 points)
    Currently Being Moderated
    Apr 30, 2012 7:46 AM (in response to LeonardJG)

    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)
    Currently Being Moderated
    Nov 11, 2012 8:34 PM (in response to LeonardJG)

    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.

     

    Mike

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.