Too many fields in data form.

[Pam]

I created new database in Excel and when I click Data, Form I get an error
code that says I have too many fields in data form. I only have 13 columns,
or fields! How many is too much?

 

[Nick Hodge]

Pam

Just check that Excel doesn't think you have more columns than you do, check
here under 'Resetting Excel's UsedRange'

http://www.nickhodge.co.uk/tipstrick.htm

You can have up to 32 fields in a data form.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Pam]

That worked! Thank you Nick.

Pam

Just check that Excel doesn't think you have more columns than you do, check
here under 'Resetting Excel's UsedRange'

http://www.nickhodge.co.uk/tipstrick.htm

You can have up to 32 fields in a data form.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)