On a shared doccuments why is it that sometimes excel always recognizes my
data range has header rows and other times i've got to tell it i do
everytime. every doccument has a clearly defined header row. what am i
missing here?

thanks in advance for your knowledge.