I've recently experienced the same problem. Searched the web for the solution without success. But, I found out the solution after I looked at the sheet carefully. The Fill Series function is disabled because of filtering the list with Filter function of Excel.

Hope that it helps.

Ahmet Saglam