Error message using Data/Forms

T

Traveller

When I try to use Data/Forms to add records to an existing table, I get an
error message, "Cannot extend list or database." This worksheet is not
protected, and I can easily add records without using the Form feature. This
particular table has 1100 records, and this workbook is relative large at
about 5MB; is there a limit using Forms? I created a small test table and the
Form feature worked fine, but I still get the error message every time I try
to add a new record to my "real" table.

I've looked in all my Excel 2003 books, tried Microsoft Help, and seached
this forum, and I can't find anything to explain this error message.

Thanks.
 
D

Dave Peterson

Are the rows under the database completely empty?

No formulas that evaluate to "", no nothing???

I'd try selecting those rows and then edit|clearcontents--just to check.
 
T

Traveller

Thank you, Dave. Good call. A couple of columns in my table had lookup
formulas, and that appearantly was the problem. Strangely enough, even though
I deleted the formulas in those columns for all of the empty records, as I
create each new record using the Excel Form, it automatically copied the
formulas into those columns, just as if I had not cleared the contents of
those cells. Amazing!!

Are these things documented somewhere?

Thanks again, Dave!!!
 
D

Dave Peterson

Data|Form is pretty smart.

But on the other hand, if you had formulas in your table and added more records,
you'd be upset if those new records didn't behave like existing records (by
having formulas in those fields). Well, I'd be!
 
Top