Excel Lists

[parksgirl]

A few months ago client requested I create an "Excel Database" by
which she meant an Excel list. Recently she sent it back for help
because the insert row (the one with the asterisk) at the bottom
disappeared. For the life of me I cannot figure out what the problem
is. I have not been successful in getting it to reappear either.
Anyone have any advice?

 

[Dave Peterson]

You need xl2003+.

Select your range
data|List

A few months ago client requested I create an "Excel Database" by
which she meant an Excel list. Recently she sent it back for help
because the insert row (the one with the asterisk) at the bottom
disappeared. For the life of me I cannot figure out what the problem
is. I have not been successful in getting it to reappear either.
Anyone have any advice?

 

[parksgirl]

I have already created the list months ago. I gave it to the client.
She returned it after adding data for a few weeks and now the insert
row function is not functioning.

 

[Dave Peterson]

Are you saying that the list is gone?

If yes, then just reapply it:
Select your range
Data|list.

If they recipient didn't have xl2003, then maybe the list was lost when the
workbook was opened and saved in a previous version. (I don't have a previous
version to test, though.)

 

[parksgirl]

No the list is still there. The the insert row (the one with the
asterisk) at the bottom
disappeared.

 

[Dave Peterson]

I don't use data|list very often, but I don't recall seeing anything that would
allow you to hide/delete that row with the asterisk--the totals row, yes--but
not the asterisk row.

Sorry.