Data Import & Export

Fix Money in Excel Transactions Not Updating After Bank Sync

Amos GikundaAmos Gikunda Nov 4, 2026 868 views

Question details

Money in Excel connects to the user's bank account and displays balances, but the actual transaction data does not populate in the worksheet after running a sync.

Fix Money in Excel Transactions Not Updating After Bank Sync
Product
Microsoft Excel
Device & OS
not provided
Scenario
Attempting to automatically import and update recent bank transactions into a personal finance spreadsheet.
Observed behavior
The bank connection remains active and merchant information updates in the 'For You' tab, but new transactions fail to appear in the worksheet after selecting the Update or Sync button.
Before you start

Ensure your internet connection is stable and verify that your financial institution's servers are not currently experiencing downtime, which can disrupt the data handoff to Excel.

Solution 1Recommended

Refresh and Reconnect Your Financial Account

Refreshing the authentication token or entirely reconnecting your bank account often resolves frozen transaction syncs.

Bank connections rely on strict security protocols that frequently expire or disconnect silently in the background. Refreshing the connection forces the service to re-authenticate and fetch the missing transaction data.

1
Run a manual sync

Click the 'Sync' button in the Money in Excel side pane and allow several minutes for background processing to complete.

2
Update credentials

If transactions still do not appear, go to the 'Accounts' tab within the Money in Excel pane, select your bank, and click 'Update credentials' or 'Refresh'.

3
Reconnect the account

If the issue persists, remove the affected bank account entirely from the pane, then click 'Add an account' to connect it from scratch.

Processing Delays: Some banks experience delays in sending cleared transaction data. Allow up to 24 hours for pending transactions to fully clear your bank and sync to the worksheet.
Free Microsoft Office alternative

Manage Your Finances Easily with WPS Office

Microsoft officially discontinued the Money in Excel feature, which is why bank syncs frequently fail or stop working altogether. Switch to WPS Office for a lightweight, stable, and completely free alternative. You can easily import your bank CSV files and use built-in personal finance templates to track your expenses securely without relying on third-party sync services.

  1. 1. Install WPS Office: Download and install WPS Office, then open the WPS Spreadsheet application.
  2. 2. Download bank data: Log into your online banking portal and download your recent transaction history as a CSV file.
  3. 3. Import to WPS: Open the downloaded CSV file in WPS Spreadsheet to instantly view and format your financial data.
  4. 4. Apply a template: Browse the WPS Template library for 'Budget' or 'Finance' to easily categorize, format, and analyze your transactions.
Fully compatible with Microsoft Excel formats (.xlsx, .xls) and standard CSV bank exports.Access hundreds of free, ready-to-use personal budget and expense tracking templates.Lightweight software that runs smoothly on Windows, Mac, Linux, and mobile devices.Completely free to use with a familiar, easy-to-navigate interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why do I only see a 'Sync' button but no 'Update' button in Money in Excel?

The interface was updated so that a single 'Sync' button handles both fetching new transactions and updating account balances simultaneously. Clicking Sync should pull in all available data from your connected financial institutions.

Is Money in Excel still officially supported by Microsoft?

No. Microsoft officially discontinued the Money in Excel premium template and its underlying Plaid integration on June 30, 2023. Users are no longer able to sync new transactions, which is the most common reason why your data is no longer updating.

How can I manually import bank transactions into my spreadsheet?

You can manually manage your finances by logging into your bank's website, downloading your transaction history as a CSV or Excel file, and then opening or copying that data directly into your personal finance spreadsheet.