Excel不计算公式 [英] Excel is not calculating formulas

问题描述

我有一个Excel模板，其中的基础值是通过SAS更新的.模板中有预定义的公式，这些公式在数据更改时不会更新.

I have an Excel template where the underlying values are updated via SAS. There are predefined formulas in the template that do not update when the data changes.

工作簿被设置为自动计算.F9或键和F9的任意组合不会更新单元格.更新它们的唯一方法是在公式框中单击并单击Enter.单元格未设置为文本格式.

The workbook is set to automatic calculation. F9, or any combination of keys and F9, does not update the cells. The only way to update them is to click inside the formula box and hit enter. The cells are not formatted as text.

这些是简单的公式，例如

These are simple formulas such as

=Data!A1

没有错误消息.单元格显示的值根本不会更新.

There are no error messages. The cell displayed values simply do not update.

推荐答案

刷新数据后，触摸:

Ctrl + Alt + Shift + F9

Ctrl+Alt+Shift+F9

这等效于发出VBA命令:

This is equivalent to issuing the VBA command:

Application.CalculateFullRebuild

这篇关于Excel不计算公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！