Share via

Spreadsheet does not automatically update

Anonymous
2014-10-09T16:47:44+00:00

I have a master spreadsheet that links with other sheets. When I open this master sheet it does not update showing changes made on linked sheets. I must manually update the master sheet. This just happened (maybe after MS update applied) because prior when I opened the master sheet it automatically updated.

I have changed no settings. On File/Options/Formula it shows under Calculations the Automatic checked and under Manual (not checked) but faded “Recalculate workbook before saving” is.

Any idea’s?

Thanks,

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-10-09T18:20:49+00:00

    Yes, mine has the same as your example shown.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-10-09T17:35:31+00:00

    Have you checked this option?

    Was this answer helpful?

    0 comments