Fix Money in Excel Transactions Not Updating After Bank Sync
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.

- 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.
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.
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.
Click the 'Sync' button in the Money in Excel side pane and allow several minutes for background processing to complete.
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'.
If the issue persists, remove the affected bank account entirely from the pane, then click 'Add an account' to connect it from scratch.
Verify Import Settings and Template Integrity
Check if the account is properly configured to import transactions or if the Excel template itself has become corrupted.
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. Install WPS Office: Download and install WPS Office, then open the WPS Spreadsheet application.
- 2. Download bank data: Log into your online banking portal and download your recent transaction history as a CSV file.
- 3. Import to WPS: Open the downloaded CSV file in WPS Spreadsheet to instantly view and format your financial data.
- 4. Apply a template: Browse the WPS Template library for 'Budget' or 'Finance' to easily categorize, format, and analyze your transactions.

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.




