Go to Qiita Advent Calendar 2024 Top
LoginSignup
5
4

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

@oceantip

F9で再計算されないExcelのセルを更新する

Posted at

計算方法の設定「自動」で、セルの数式が更新されない場合の対処法を見つけたのでメモ。

問題

セルの数式の更新がされず、「再計算実行」も効かない。
image.png
対象のセルを選択し、Enterで更新できるが複数の数式を一括で更新できない。

解決

Ctrl+Alt+F9
※「開いているすべてのブックのツリーの再構築と計算の強制」を行うので、再計算のコストに注意する

補足

VBAの場合
Application.CalculateFull

Excel の再計算
https://docs.microsoft.com/ja-jp/office/client-developer/excel/excel-recalculation

5
4
1

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
5
4

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?