1. Check to see if your data source is connected properly.

2. Check your formulas. Does each cell contain the proper formula for the data you are trying to populate?

3. Check your data range. Does the range you have selected contain any extra cells, or has data been removed from the source?
4. Check the cell types. Are the cells you’re attempting to autofill formatted as a Number, Date, or Text?
5. Verify your calculations. Have any of your calculations been changed in the data source?