如何在Excel中即时刷新计算 [英] How to refresh calculation instantaneously in excel

问题描述

我在刷新单元格的计算时遇到问题.

I have a problem in refreshing the cell's calculation.

换句话说，我有很多列，每个列中都有一个公式或宏.

In other words, I have many columns where i have a formula or macro in each one of them.

但是问题是我应该绝对激活excel选项中的自动计算"选项，否则我应该保存然后出现新结果.

But the problem is that i should absolutely activate the option " automatic calculation" in the excel options or i should save then the new results appear.

现在，我将在宏中插入一些可以立即刷新结果的宏.

Now, I would insert something in the macro that can refresh me the results instantaneously.

谢谢

推荐答案

您只需按一下:

F9计算整个活动工作簿

Shift + F9计算活动工作表

无论如何，这是.Calculate的不同选项:

Anyway, here are the different options with .Calculate :

Sub Souma()

'Use this to calculate all the open workbooks
Application.Calculate

'Use this to calculate the whole sheet, called "Sheet1"
ThisWorkbook.Worksheets("Sheet1").Calculate


'Use this to calculate the cell A1 on the sheet called "Sheet1"
ThisWorkbook.Worksheets("Sheet1").Range("A1").Calculate
'Use this to calculate the range A1 to D10 on the sheet called "Sheet1"
ThisWorkbook.Worksheets("Sheet1").Range("A1:D10").Calculate
'Use this to calculate the column A on the sheet called "Sheet1"
ThisWorkbook.Worksheets("Sheet1").Columns(1).Calculate
'Use this to calculate the row 1 on the sheet called "Sheet1"
ThisWorkbook.Worksheets("Sheet1").Rows(1).Calculate

End Sub

这篇关于如何在Excel中即时刷新计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！