Use the table of contents to the right to review troubleshooting tips for common issues and questions for the Tiller Money Feeds add-in and the Tiller Foundation Template for Microsoft Excel.
Tiller Money Feeds add-in Troubleshooting
I'm having issues getting the Excel add-in installed and opening in Excel
If you're having trouble installing the Excel add-in here are some things to check or keep in mind
If you're using Windows the the Add-ins button has moved to the Home ribbon (from the Insert ribbon) in the latest Windows and Excel updates.
The add-in only works in the Excel application installed via a Microsoft 365 subscription. If you're using a standalone install version of Excel this may be why you're unable to install the add-in. You can subscribe to Microsoft 365, uninstall the old version, and install the new version.
If you're using Excel downloaded via a work/school Microsoft 365 subscription your administrator may have blocked the ability to install add-ins. If you don't see the "Store" option in the Excel My Add-ins window this is likely the case.
You're signed in to a different account in Excel than is licensed for the Microsoft 365 subscription. Make sure that the two accounts depicted in this screenshot below are the same. They should be the Microsoft account associated with your Microsoft 365 subscription.
You haven't installed the most recent Windows and Office updates. Be sure to run Windows and Office updates and then try again.
To access your account information and confirm you're logged in to the correct accounts.
On Windows
Open the File menu
Choose Account at the bottom of the File menu
On a Mac:
Open the File menu and choose "New from template"
Review the email address signed in at the top after clicking the profile icon in the upper left.
I see a "We can't find that account" error when trying to sign in to Tiller via the Add-in
If you're seeing an error indicating that your account can't be found when you try to sign in to Tiller from the Excel add-in sidebar:
Confirm that you're using the correct provider (Google vs Microsoft)
Confirm that you're trying to sign in with the correct email address
Try re-signing in by choosing "Sign in to another account" and sign in again even if this account appears to already be signed in
I'm prompted to link a workbook that is already linked
If you're being prompted to link a workbook you've already linked mostly likely you created a copy (or did a "Save as") of the workbook so it doesn't recognize that it's linked.
To fix this issue:
Locate and open your original workbook
If that is the not the case and you're seeing a "it looks like this workbook might already be linked" message try clicking the "logging out" link in the message and log in to the appropriate Tiller account.
I get an error when I click "Fill Available Updates" in the sidebar
If you're seeing an error in the sidebar when you click the "Fill Available Updates" button here are some tips:
Try quitting the Excel application and restarting it
Try installing the latest Windows and Office updates then try again
Too few transactions rows were added
When you see this error make sure you don't have any filters enabled that are filtering data out of view in the Transactions sheet. If a filter is enabled this can cause the fill to not work properly.
This operation is not permitted for the current object
If you're using Excel Online browser based version of Excel with Tiller (not the Desktop application), make sure that the Filter is enabled in your Transactions sheet otherwise you may get the error below:
If none of those help, reach out to our support team using the chat tool in the lower right corner of this page or via email at support@tillerhq.com with a screenshot of the error.
Too few transactions rows were added
Make sure your Transactions sheet is formatted as an Excel Table and the table name is Transactions. More in this guide.
PayloadSizeLimitExceeded error
This error happens in Excel Online when you're trying to fill more data than the add-on can handle.
Use the Excel Desktop version to fill your sheet
Try filling your accounts in batches by toggling some off
The add-in fills balances but not transactions
Double check that there is not a frozen column in your Transactions sheet. E.g. if the Date column is frozen the add-in can't fill in the Transactions. The add-in will indicate fill is complete but only balances will be filled, and no new transactions will be filled.
Getting a "cannot access the file" error when trying to install the Excel add-in
Often times this error is presented, but the add-in was successfully installed. After seeing this error you can confirm that the add-in was installed by going to the Insert ribbon, then choose "My Add-ins" and then add the Automated Bank Feeds add-in to your Excel application.
One workaround is to follow the steps for using Excel Online. You can use Excel Online to install the add-in and load it with your data. You'll need to use the Excel Online add-in to update it each time, but then you can open it with the Excel application to make changes.
Javascript error when trying to sign in
You receive an error message when trying to sign in to Tiller Money Feeds add-in from Excel "The browser you're using doesn't support JavaScript, or has JavaScript turned off."
To fix (known steps only for Microsoft Excel for Mac OS)
Click the "info" icon in the Excel add-in
Click "Clear web cache"
Click "reload"
âSomething went wrongâ error after logging in via Excel Online
After signing in to Tiller via the Tiller Money Feeds add-in from Excel Online you see a âsomething went wrongâ error in the task pane.
Close the task pane and relaunch the Tiller Money Feeds add-in for Excel
You should be signed in and able to use the add-in
Browser or app may not be secure error when I try to sign in
We believe this issue is fixed. If you run into this error, please reach out to support@tillerhq.com to let us know you're seeing this error.
"Failed to read the 'localStorage' property from 'Window' error
This error happens when you try to sign in to Tiller Money Feeds add-in via Excel Online (browser/cloud based Excel) and you are blocking 3rd party cookies.
To fix:
Enable 3rd party cookies in your browser for https://onedrive.live.com/login/ as depicted in the screenshot below.
Unexpected token < in JSON at position 0 error during a fill
This error happens when too much data is trying to be filled at one time. Generally this only happens if you have several years of data in Tiller's databases, many accounts (more than 20) and you're trying to fill all that data into a workbook for the first time.
To address this error and get your data successfully filled into the sheet, try filling the sheet in batches. Configure the linked accounts and toggle most of them off then fill the sheet for a few accounts at a time until you get all the accounts' data filled into the sheet. Subsequent fills should work fine.
Add-in unresponsive when I click "Sign in to Tiller"
You're clicking the Sign in to Tiller button in the add-in task pane and nothing is happening. This likely means that you need to install Windows or Office updates. Run Windows Update and Office Update to install all available updates until it indicates that there are no more updates to install.
Sidebar is blank after clicking Tiller Money Feeds icon
You're clicking the Sign in to Tiller button in the add-in task pane and nothing is happening. This likely means that you need to install Windows or Office updates. Run Windows Update and Office Update to install all available updates until it indicates that there are no more updates to install.
The add-in disappears from the Data ribbon
Usually we find that the add-in will not persist on the Data ribbon when you're signed in to more than one Microsoft account in the Excel application.
Try clicking the profile icon in the upper right of the Excel client on Windows or choose the Sign out option from the File menu on a Mac and sign out of extra accounts. Be sure to stay signed in to the account associated with your Microsoft 365 subscription. You may also need to search the Excel application for add-ins if they are inaccessible from your Data ribbon.
I'm getting Cannot read properties of null (reading 'map') error
You may see this error when you try to click the "Fill Available Updates" button when there are many (possibly several hundred or thousand) extra blank columns in the Transactions table range out to the right of the last Tiller filled column.
This can happen when you paste in the entire worksheet from another workbook rather than just the range with data in it.
You can just delete all the extra rows out to the right of the last column that has a header keyword (it's usually the Date Added column). You can easily select all these columns by clicking the first empty one, holding CMD (or CTRL) + shift key and use the right arrow to select the very last one. Then while still holding down shift + CMD (CTRL) right click and choose to delete the columns.
After that you should be able to resume filling your workbook per normal.
Foundation Template Troubleshooting
Why aren't my budget amounts cascading across to the right?
Sometimes if you insert a row into the Categories sheet or accidentally edit the default rows this can break the "cascading budgets" feature. You can read more about this feature and how to reset it here.
Why are my actuals doubled for my income on the Yearly Budget?
You might see the actuals amount for your income doubled on your Yearly Budget sheet if you're using a group called "Income" for your Income type categories. Try changing your group name from "Income" to "Primary Income" or something else to correct the issue. The actuals formula doesn't work properly because the group name is the same as the income type.
Why aren't my category spending totals showing up on the Categories sheet?
The monthly budget columns on the Categories sheet are where you set budget amounts. Review the Yearly Budget tab for actuals per month.
Why don't I see my budget or actual amounts on my dashboard?
If youâre not seeing budget or actual amounts on your Monthly Budget or Yearly dashboards
Ensure that your Transactions sheet is populated in order to have the Yearly Budget sheet figures generated
Double check the appropriate month/year is selected in the upper right of the Monthly Budget. On the Yearly Budget confirm the correct year is selected.
Double check that youâve entered budgets on the Categories sheet starting in Column E.
If youâve entered budgets into Column E on your Categories sheet, double check that the word âCategoryâ is present in row 1 on the Categories sheet at the top of the Category column and that the words âCategoryâ âDateâ and âAmountâ are present in row 1 on the Transactions sheet for those columns in that order. If these header keywords are missing the dashboardsâ formulas canât find the correct columns in the referenced sheets to pull the data in.
Make sure you didn't change the name of the tab from Transactions and/or Categories. Those tabs need to be named appropriately in order for the dashboards to work.
Make sure that you have a Group and Type assigned to all categories on the Categories sheet and that you're only using one Type per group. E.g. you can't have both income and expense categories in the same group.
If you inserted columns into your Categories sheet this can also break other dashboards "downstream" of the Categories sheet. Try deleting those columns to see it if helps.
If those don't help, make sure that none of your categories in the Transactions sheet Category column are #N/A (use the built in filters to check for this).
If you're seeing a #NAME? error on the Monthly and Yearly Budget sheets review this information.
My Category is missing from the dropdown on the Transactions sheet
Sometimes if you insert rows above row 2 in the Categories sheet or skip rows at the bottom of the Categories sheet the dropdown doesn't include your new categories.
#NAME error on my monthly/yearly budget sheet
Click in the cell where you see the #NAME error and review the formula.
If the formula has _xlfn. in it that means that the version of Microsoft Excel you're using does not support the features and formulas of the Tiller Foundation Template for Microsoft Excel.
To fix
The template expects that you're using Microsoft Excel installed from a Microsoft 365 subscription. If you purchased a standalone license to Excel these versions are not supported so you will need to upgrade your version of Microsoft Excel by subscribing to Microsoft 365.
If you are using a version of Excel installed using a Microsoft 365 subscription try running Office update until you've installed all updates for Excel.
Confirm the version of office running by opening the File ribbon and choosing "Account" near the bottom left. You should see something like "Microsoft 365" under the "Subscription Product for [email address] heading.
If you subscribe to Microsoft 365 but your version of Excel doesn't reflect that it's from a M365 subscription you may need to uninstall Excel and re-install it from your Microsoft account portal.
#SPILL error on my monthly/yearly budget sheet
You will need to clear out whatever was manually typed into the columns where you are seeing #SPILL. Make sure you scroll all the way down and clear out all the manual entries you've added.
The Yearly and Monthly budget sheets are view only sheets except changing month and year in top left, so any edits to the sheet directly will break it.
Why are my Transaction dates not formatted as dates?
If you link a blank workbook to the Tiller Money Feeds add-in for Excel the date formatted columns will not be automatically formatted as dates.
First try formatting the column as a Date using the formatting tools on the Home ribbon in Excel.
If that doesn't help, move to the next section below for more tips.
If you're seeing your transaction dates showing up as numeric values (.e.g 44563 instead of 1/2/2022) in the Date column on the Transactions sheet, but they do show up as dates in the formula bar you need to turn off the "Show formulas" option under the
Formulas ribbon.
