Autofill Copy

Occasional Visitor

Hi there


Please can someone tell me why my autofill is no longer working properly?

It used to work perfectly well like this for years and years.






Last month it started doing the below. Not copying the files but making up numbers and adding what it likes.





I have spent so much time on the phone to several representatives in Customer Support and gotten nowhere. I've no idea what has gone wrong but I'm hoping it can be solved quickly. I copy and paste the numbers from another document, do you think there is some error or hidden formula on there that is going this?

1 Reply


Could you please instead of screenshot attach the file in question with only Sheet2, removing other sheets.