Autofill function with filter

[Sascha93]

Hello,

I applied a filter to my data, and thereafter the autofill function did not work anymore. Even when I unfilter my data again, the function does not work anymore. What can I do?

Thank you!

[Kagesen]

Use the Undo function located top left of the sheet.

If that doesn't work then you must have changed something else otherwise the unfilter should work and bring your data back.

[Sascha93]

If I use the unfilter my data is back again. However, the autofill function is still not working. If i use it, it copies just the same number as before again over and over.

I attached an example. In this document the function is just now working. Please check it out.

I you use the sum function for example for cells A1:A3 and then you try to use the autofill function for the other cells it does not work. It gives you the same number again.

[Kagesen]

Are you able to attach a copy of your excel sheet so I can look at it?

[Sascha93]

Oh yes, I edited my previous response and included a sheet. Thank you!

[Sascha93]

@Kagesen: I figures it out already! I had to change the formula options from manual to automatic! But thanks for your help

[Kagesen]

You are most welcome. Remember to change the post to Solved :-)