Perhaps the wrong spot, as the topic is in the foundations template, but I guess someone will move it if so.
Anyone every had this error:
transactions sheet size limit exceeded
It is interesting I actually get it twice on the same popup.
Only 8900 lines on my transactions sheet. Its a lot, but not huge.
What say ye?
Thanks
How frustrating to receive this error message, and twice at that. Iâve only read about one member @buzzmaster1 who received the same message. This was back in June 2025. He was using the web-based Excel. At that time I donât believe the cause was identified.
I donât believe there is a simple answer to what could be causing this error message all of a sudden. A couple of things we can check on: Do you have a large number of blank rows in the Transaction table beyond the end of your last data row? Do you have a lot of community add-ins or Pivot tables?
It definitely isnât related to the actual limits of the spreadsheet, each sheet can contain 1,048,576 rows! Beyond @Clint.C âs questions, can you post a screen capture of the pop-up? You mention âtransactions sheet size limitâ, which doesnât sound like a generic Excel error, Iâm thinking maybe one of the Tiller tools?
It is for sure a tiller error and not an excel error.
I am going to try the process of elimination by saving a temporary version and deleting rows until I find the problem children. In the end I also think it has nothing to do with the amount of data in the sheet. Probably something where it should not be:(
I think youâre right. Let us know how your tests go, if you can find a way to reproduce it, I bet a Tiller engineer could weed out the bug.
@FerrellFamilyLife Are you using Excel online or the Office 365 desktop version?
I have confirmed that the error message you received is a Tiller error message and a known bug with the Excel web online. To date, it has only occurred once in that environment. It would be helpful to know which environment (web or desktop) you were using.
Hi Together,
I am using the online version of Excel.
Now the full story⌠A couple of months (and a few thousand transactions ago) I started getting a different error message than this one. It looked the same but said something about formatting. Everything was still working fine, so after trying some debugging (deleting rows 10-100 at a time to find the offending row) and seeing nothing different in the offending row, I just gave up and said âoh well it works stillâ
Everything was working fine when these two new errors appeared some three months and 3000 additional rows later, but I decided to try the debugging with the same results⌠The offending line had nothing different about it and when I deleted only the offending row the error warning moved to another line⌠ughâŚ
So I started deleting columns (there are less of those). I had added a column that captured the autocat line number which categorized that row a long time ago based on a hint in the forums here⌠That column was the offenderâŚ
Long story short if you add something to the transactions sheet, even if it works for others, may want to remove it if things get fishyâŚ
It is likely the offender.
Problem solved⌠mostly:)
Shawn
Thank you @FerrellFamilyLife for you detailed explanation and debugging analysis. This may help the Tiller team pinpoint what the actual bug is.
Yes, this is a Tiller issue and is ultimately the reason I abandoned my Excel sheet and switched to Google Sheets. My preference would have been to stay with Excel.
