@kbrown Try the following steps #1 thru #5 and #9 only and lets see if it resolves the issue:
Hi-So far that has worked, thank you! I was getting the error after my action which is selecting an account with the drop down.
Will I need to go in a clear the cache periodically to avoid getting this error again?
I appreciate your help!
Kymm
1 Like
That is good to hear that clearing the Excel cache has worked so far. Yes, you can clear the cache the same way manually or steps #6 and or #7 in the above post can be set to clear the cache automatically. I think #7 might be best to clear the cache every so many days.
I have had a variety of resurce type issues since March. While my file is quite large it should not be a limiting factor. I tried submitting tickets with Tiller but did not get any useful help. I have tested by creating a test sheet with fewer transactions but it did not solve the issue. Here is where I stand now. First back in March I learned enough about google sheets to create a parallel version. I recreated all of my customized transaction fields, pivot table and reports. I know update the sheets and excel versions daily which is suboptimal but it was cool learning google sheets. With Sheets, I have had zero resource issues. With Excel it is sporadic. At home on my windows desktop, I periodically get the ran out of resources error but there is no pattern that I can discern. About a mong ago, I purchased a MacBook Air. Using the Mac Excel Application, I have not encountered any issues so far. Next, I have tried the web version of excel. This is of huge importance to me because when I travel, I do not want to lug both my ipad and my laptop around. When I login in to tiller on Web Excel, I get a âtransaction limit exceededâ message. Clearly this comes from Tiller not Excel. But again Tiller can provide zero detail on the message. In the past, even with the error, I could still login, fill and run autocat. Today, I could still login and fill despite getting the error message but autocat does not work anymore. I will be traveling from end of July through November. (also traveling now) I hope to resolve this issues so that I can keep my backpack within European weight restrictions. Does anyone have any similar experiences or suggestions. I am a onedrive user.
Hi @buzzmaster1 Ken,
I can certainly see why you need these issues resolved before you travel.
I too ran a dual Excel and Sheets for awhile. It was fun learning Sheets and the Google side of things.
I canât speak to the web version of Excel as I donât have any experience with that. However, maybe the following will help:
Regarding the âout of resourcesâ error in Windows Excel, have you tried clearing the Excel cache solution that I posted about in this thread?
Regarding the large file size with your customized transactions fields, pivot tables and reports; I posted about an interesting Excel command I found last year called Check Performance. It has helped me reduce my Excel file size significantly and improve performance. I havenât run into any issues using it.
Clint
Hi,
Thanks for your response. Let me try those things. Between now and November Iâll be traveling all but 10 days. I did notice that I also have the resources issue on my MacBook Air if I do more than just update the file. I will see if the Excel performance tools are on the Mac version and I can play with that while traveling.
Really, at this point, I really need the web version to work because I just donât wanna carry a laptop and an iPad on the next trip starting at the end of July. But itâs always good to fix any problems with excel and improve it.
Here is a copy of the ticket I submitted to tiller. Please let me know if anyone has any insight:
Using the web version of excel, when I log on to tiller, I get âTransaction Sheet Size Limit Exceededâ. I am still able to login in and fill data but autocat fails. I removed 3 years of data. I still get the the same error message but can login, fill data and now autocat runs correctly. However add manual transaction says transaction added but nothing is added nor is the balance updated. My file is 3.8mb which is WELL under the maximum size supported by web excel.
Iâve been getting this since I installed Tiller a couple months ago and started copying in old downloaded data thatâs formatted to the Tiller columns.
That calc error happens when I mess with anything too much, autocat, deleting lines from the Transaction table, search and replace in Transactions.
Jury is still out on this one: Tried the Save options, going to 1 day and not saving cached files at all - so should actually have zero cached.
Sometimes it seems to be less prone (ie I work longer) if I donât have any other applications open on my PC.
Excel 365, updated.
About 6500 rows of transactions.
Added a couple sheets with pivot tables, but the problem started long before that.
Window 10 Pro
RAM 16 GB
Low end processor
You might give the Check Performance command a try.
It identified a table in my spreadsheet that had the max rows allocated.
The command displays the recommended results and you can choose to apply them one by one, all or none. Alternatively, you can run the command against a copy of your spreadsheet.
Fixed Monthly Budget tab of 1,077257 cells, then rest of workbook was 61,822 more.
Size on disk down from 8.99 MB to 3.65 MB. Nice saving.
Saved, closed, opened and weâll see if that fixed it. Even if not, sure did help with excessive wasted size chewing up some kind of system resources.
Great suggestion. Thank you! Iâve never had a spreadsheet anywhere near this size.
Resource error again. In general when I mess with the workbook much. This time I got if when messing around to do get a list of sheet name links that I scraped off the web.
Defined name"
âsheetnamesâ with this ref: =GET.WORKBOOK(1)&T(NOW())
Added:
âHelpâsâ sheet
Added formula:
=IF(ROW()=1,âClick the sheet name belowâ,IFERROR(INDEX(MID(Sheetnames,FIND(â]â,Sheetnames)+1,255),ROWS(A$1:A1)),ââ))
You might try option 5 to ensure the cache is deleted.
Awesome. That is some good file size reduction.
Iâm assuming there is something in your data (maybe the imported data) that the Tiller formulas donât like. Iâve had issues before with my imported data or manually added rows. You might look at ensuring date format is consistent for each column, any blanks before text " text", and any blank rows inbetween other rows. No blank row at the top of a table. Delete any blank rows after your last data row and the end of the table.
You might also try a new post related to your specific Excel formulas. Maybe there is something in them that is triggering the error.
I looked up the resource issue and it seems to just be the fact that the computer canât handle that much processing at the same time. I get it all the time using my MacBook Air m1 but when I use my Mac mini m2, I donât get the resource error.
1 Like