# Transaction Glitch in Excel Today (6/22/21) **URL:** \ **Category:** Ask Anything\ **Tags:** excel, bank-feed-issue\ **Created:** [June 22, 2021, 11:44am UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038 "2021-06-22T11:44:46Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![dminches](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dminches/32/723_2.png) [@dminches](https://community.tiller.com/u/dminches)\ **Post date:** [June 22, 2021, 11:44am UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/1 "2021-06-22T11:44:46Z")
When I pulled in my transactions this morning they were missing the date and, as a result, they did not populate in the correct columns. I don’t know if this is a system glitch or something else. Anyone else have this issue? ---
**Author:** ![dudeguyman](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dudeguyman/32/4690_2.png) [@dudeguyman](https://community.tiller.com/u/dudeguyman)\ **Post date:** [June 22, 2021, 5:41pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/2 "2021-06-22T17:41:12Z")
Yes, I am having the same issue. Pretty frustrating. I am not a complainer and understand technology breaks but given how critical this sheet is for me and I am paying for the product I am very disappointed. I always had my date located in column “B”. I am not sure why that would stop working. ---
**Author:** ![dminches](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dminches/32/723_2.png) [@dminches](https://community.tiller.com/u/dminches)\ **Post date:** [June 22, 2021, 5:57pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/3 "2021-06-22T17:57:26Z")
My guess is that they made a change to the code and it messed things up. If that is the case then this is the 2nd time in a couple months that code changes were not properly tested before being made live. Hopefully someone is monitoring the situation and trying to figure it out. @heather ---
**Author:** ![jpfieber](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jpfieber/32/4791_2.png) [@jpfieber](https://community.tiller.com/u/jpfieber)\ **Post date:** [June 22, 2021, 9:49pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/4 "2021-06-22T21:49:11Z")
For what it’s worth, I’ve been importing transactions throughout the day and haven’t had an issue, so it’s not an across the board issue, could be related to certain institutions maybe? ---
**Author:** ![richl](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/richl/32/888_2.png) [@richl](https://community.tiller.com/u/richl)\ **Post date:** [June 22, 2021, 9:52pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/5 "2021-06-22T21:52:37Z")
I also didn’t see any issues today. Sorry you are having issues. ---
**Author:** ![brasten](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brasten/32/19_2.png) [@brasten](https://community.tiller.com/u/brasten)\ **Post date:** [June 22, 2021, 10:46pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/6 "2021-06-22T22:46:40Z")
Hey @dminches @dudeguyman , any chance you are on the Excel product? ---
**Author:** ![dminches](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dminches/32/723_2.png) [@dminches](https://community.tiller.com/u/dminches)\ **Post date:** [June 22, 2021, 10:59pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/7 "2021-06-22T22:59:36Z")
Yes, I am using Excel. I mistakenly left that out of my first post. It was confirmed that they changed the template last night which likely caused the issue I am having. ---
**Author:** ![brasten](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brasten/32/19_2.png) [@brasten](https://community.tiller.com/u/brasten)\ **Post date:** [June 22, 2021, 11:46pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/8 "2021-06-22T23:46:26Z")
Yeah, I haven’t been able to reproduce that specific issue unfortunately. Ironically the changes we’re making to the Excel product right now are intended to improve stability. I’m hoping your problem is resolved by some of the patches going out today/tomorrow. ---
**Author:** ![dminches](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dminches/32/723_2.png) [@dminches](https://community.tiller.com/u/dminches)\ **Post date:** [June 23, 2021, 12:20am UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/9 "2021-06-23T00:20:10Z")
I have been spending a lot of time rewriting tons of formulas in the tiller helper and tiller balances worksheets to eliminate all the INDIRECT function calls. It really makes things faster. I do hope the Tiller team does its own work on the Excel template. It needs work and hasn’t been changed in a couple years. ---
**Author:** ![dudeguyman](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dudeguyman/32/4690_2.png) [@dudeguyman](https://community.tiller.com/u/dudeguyman)\ **Post date:** [June 23, 2021, 12:51am UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/10 "2021-06-23T00:51:53Z")
Yes - excel. Thanks for the information. Please let us know when the changes go out, and I’ll give it a try again. ---
**Author:** ![brasten](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brasten/32/19_2.png) [@brasten](https://community.tiller.com/u/brasten)\ **Post date:** [June 23, 2021, 4:10pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/11 "2021-06-23T16:10:25Z")
I’ve pushed out some changes late yesterday. I can’t make any promises as I’ve been unable to repo the original complaint so it’s hard to know if it’s been fixed. We are continuing to make some changes (improvements, we hope!) this week so if the problem persists we’ll still be looking for it. ---
**Author:** ![dminches](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dminches/32/723_2.png) [@dminches](https://community.tiller.com/u/dminches)\ **Post date:** [June 23, 2021, 4:27pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/12 "2021-06-23T16:27:06Z")
I pulled in new transactions and the issue has not been resolved. There are still no dates associated with the transactions and the other transactions are not sorting chronologically which it did before. I really hope this gets fixed quickly since it is making updating very difficult. ---
**Author:** ![dminches](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dminches/32/723_2.png) [@dminches](https://community.tiller.com/u/dminches)\ **Post date:** [June 23, 2021, 5:26pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/13 "2021-06-23T17:26:18Z")
Now I am getting 6 blank transaction rows at the top when I click on fill. ---
**Author:** ![dudeguyman](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dudeguyman/32/4690_2.png) [@dudeguyman](https://community.tiller.com/u/dudeguyman)\ **Post date:** [June 23, 2021, 8:46pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/14 "2021-06-23T20:46:00Z")
There is still an issue with the excel sheet… ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/c/ce07833003e699f39dc84cbdff09c0e7cde5afdb.png) When I sync the descriptions are loading in the date column, and everything is off by one. ---
**Author:** ![dminches](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dminches/32/723_2.png) [@dminches](https://community.tiller.com/u/dminches)\ **Post date:** [June 23, 2021, 9:04pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/15 "2021-06-23T21:04:45Z")
This is the same issue I am having. No dates are being pulled in which is messing everything else up. ---
**Author:** ![brasten](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brasten/32/19_2.png) [@brasten](https://community.tiller.com/u/brasten)\ **Post date:** [June 23, 2021, 9:08pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/16 "2021-06-23T21:08:45Z")
Thanks, still digging in to this. The screenshots help, thanks. I hope we’ll get to the bottom of it soon. ---
**Author:** ![dminches](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dminches/32/723_2.png) [@dminches](https://community.tiller.com/u/dminches)\ **Post date:** [June 23, 2021, 9:21pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/17 "2021-06-23T21:21:18Z")
Thanks for your attention to this. Any chance you can roll back the code to before the changes were made so we can use this without the errors? ---
**Author:** ![brasten](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brasten/32/19_2.png) [@brasten](https://community.tiller.com/u/brasten)\ **Post date:** [June 23, 2021, 9:29pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/18 "2021-06-23T21:29:37Z")
Fair question - normally we would have by now, yes, but in this situation I’ve been relying on some logging in the new code to help figure the issue out. The good news is I was just able to reproduce it for the first time, so if I can’t come up with a super-quick fix then I’ll look at rolling back. ---
**Author:** ![dminches](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dminches/32/723_2.png) [@dminches](https://community.tiller.com/u/dminches)\ **Post date:** [June 23, 2021, 9:31pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/19 "2021-06-23T21:31:01Z")
Excellent! Anything you want to share about what you found “under the hood” would be interesting to hear. ---
**Author:** ![brasten](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brasten/32/19_2.png) [@brasten](https://community.tiller.com/u/brasten)\ **Post date:** [June 23, 2021, 9:34pm UTC](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038/20 "2021-06-23T21:34:56Z")
Yeah, I was going to confirm it first (working on that now) but at the moment it appears to be related to the Tiller logo icon in Column A. I can’t quite yet explain WHY, the code has always taken that into account and I don’t believe we’ve changed anything there, but at least that’s the only difference between the repro case and all my other tests. If this ends up being the case, it does expose that none of my previous test cases required a sheet with a logo header. Either way, that’ll definitely be incorporated into future testing. [Next page](https://community.tiller.com/t/transaction-glitch-in-excel-today-6-22-21/9038.md?page=2)