I’m not certain what I did but I noticed today that my Descriptions prior to a certain date (12/21/2024) were not matching up with my Full Descriptions. Example:
Description: Martin’s
Full Description: McDonalds
Everything from current to 12/21/2024 was OK but everything prior to 12/21 was not matched. It wasn’t like things shifted and I could easily fix it by shifting up or down. The order has canged.
I’m not sure what I did but maybe some things I do are not good practice.
- I do a lot of filtering. I notice that sometimes the filter does not include all the data so I have to clear the filters and reapply. Sometimes I forget but I can’t really see how this could cause the issue.
- I also noticed that not all the columns had a filter on them. I need to check but do hidden columns have the filter applied? This makes more sense that maybe I did a sort on 12/21 but didn’t include all the columns.
I’m not sure what else I could have done wrong. I kept the latest file and made a copy (not restore) of the last known good file after reviewing all the revision history. I connected that copy and will disconnect the original (broke) file from Tiller. I’ve got a lot of verification work as Tiller filled in 731 transactions when I reconnected.
I will need to be a lot more careful when using filters. I suspect my problem came from being careless with them. Tables (range of filters) are tied to the last row and column when turned on. When a new transaction is added, oldest transactions fall outside the filter. The columns and rows have to be reselected and the filters turned off and on to apply to all data.
I wonder if others might have had this problem, what they think might have caused it and how they recovered.
Finally… thank goodness for Google’s revision history. I was able to find the last good file and connect it to Tiller.