The data overflowed the table, instead of it expanding automatically. Unfortunately, things didn’t go well on his computer. When you click the “Add this part” button, the new record is added at the end of the existing rows.Įverything worked well on my computer, so I sent the file to my client, for testing. The file contains a UserForm for data entry, similar to the one shown below, that you can download from my Contextures site. Usually, tables behave quite nicely, unless, of course, you try to add a Custom View to the workbook, or do something with a group of sheets that contain tables. They make it easy to add, sort, and filter your data.
Tables are a great feature in newer versions of Excel.
Instead of expanding to include the rows, the table just ignored them.įortunately, the problem is easy to fix, if you know how, and if you have the patience to do lots of clicking. This week, while working on a client’s Excel project, I ran into some trouble with Excel tables, while adding new data.
