Share via

Cell data transfer to another sheet failure

Nathan Zehr 0 Reputation points
2026-06-18T00:31:42.17+00:00

I have data transferring from one sheet to another in the same Excel workbook. The transfer works with the initial data input. Since upgrading from Windows 10 to Windows 11 and also upgrading to MS Office Home & Student 2021, if I have to adjust some of the data sometimes, it does not resend and refresh the page where it was send to the first time. I don't understand why it doesn't work. It used to on the old equipment and programs.

Microsoft 365 and Office | Excel | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sophie N 16,060 Reputation points Microsoft External Staff Moderator
    2026-06-18T01:47:11.19+00:00

    Dear @Nathan Zehr,

    I understand how frustrating it is when a reliable workflow suddenly stops updating after a system and software upgrade.

    Based on your description, the core issue is that your cross-sheet formulas or links are no longer calculating automatically when you modify the source data. This is a common behavior change after a fresh installation or upgrade, and it is almost always caused by a change in Excel's calculation settings or security blocks.

    Here are the most effective solutions to resolve this issue:

    Step 1: Check the Calculation Options

    Often, a new Office installation defaults to "Manual" calculation mode, which prevents formulas from updating automatically when data changes.

    • Open your Excel workbook.
    • Go to the Formulas tab in the ribbon.
    • Click on Calculation Options and ensure that Automatic is selected. User's image

    Alternative Shortcut: Press F9 on your keyboard. If your data updates immediately after pressing F9, your workbook is definitely set to manual calculation.

    Step 2: Verify Workbook Links and Security Settings

    Windows 11 and Office 2021 introduce stricter security protocols that might be blocking the background data transfer.

    • Go to File > Options > Trust Center > Trust Center Settings.
    • Select External Content.
    • Ensure that enable automatic update for all Workbook Links is checked (or set to "Prompt user" if you prefer a warning).
    • Additionally, if a yellow security warning bar appears at the top of your screen when you open the file, you must click Enable Content for the real-time data sync to work. User's image

    Step 3: Safe mode option

    Sometimes, the upgrade process leaves behind corrupted cache files that interfere with Excel's background processes.

    • Close Excel completely.
    • Press Windows Key + R to open the Run dialog box.
    • Type excel /safe and press Enter to launch Excel in Safe Mode.
    • Open your file and see if the data transfers upon modification. If it works, a corrupted add-in or cache is causing the block. You can clear your temporary files or disable recent add-ins via File > Options > Add-ins.

    Step 4: Repair office

    Repair Office: Sometimes a quick repair of your Microsoft 365 installation can fix underlying issues that cause settings to become stuck. You can do this by going to Windows Settings > Apps > Microsoft 365 > Modify and choosing "Quick Repair".

    Please refer to this document: Repair an Office application - Microsoft Support and Move or copy worksheets or worksheet data

    Please try changing the Calculation Option to Automatic first, as this resolves this specific issue in the vast majority of cases. Let me know if the issue persists.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.