Creating tables in my spreadsheet wont let me insert a new row!!!

[Antligen]

sample worksheet Antligen.xls

I have a spreadsheet that I need to add new rows everytime I have a new client. I a formula in the N column and a formula in the F column that I would like to automatically insert itself into the new rows.

The problem is this: I have arranged my table so that I can look at clients alphabetically, and according to other date... BUT now it wont let me insert a new row when I have a new client!!!

Is there anyway of keeping it so that I can insert a new row into my table, but preserve all of the formulas that I want automatically put into both the F and N column?

Attached is the sample spreadsheet.

Regards,

Antligen

[Antligen]

Solved

Removed previous table, which was only in one column, highlighted whole of table and was able to insert new rows.

:D