2024年4月3日发(作者：)

公式引用其他表 关闭后乱码

英文回答：

When it comes to referencing formulas from other tables

and experiencing garbled characters after closing, there

could be a few potential reasons for this issue. Let me

explain them one by one.

1. External Reference: One possibility is that the

referenced table or workbook has been moved or renamed.

When you reference a formula from another table, it creates

a link between the two. If the referenced table is no

longer in the same location or has been renamed, the link

will be broken, resulting in garbled characters. To fix

this, ensure that the referenced table is in the correct

location and has the same name as when the formula was

created.

2. Encoding Issue: Another possibility is that the

encoding settings are not consistent between the tables.

Different encoding settings can cause characters to display

incorrectly. To resolve this, ensure that the encoding

settings for both tables are the same. You can usually find

the encoding settings in the file or workbook properties.

3. Compatibility Issue: It is also possible that there

is a compatibility issue between the software versions used

to create the tables. If the tables were created using

different versions of the software, it could lead to

garbled characters when referencing formulas. Updating the

software to the latest version or ensuring that both tables

are created using the same software version can help

resolve this issue.

Let me provide an example to illustrate these points.

Suppose I have two tables, Table A and Table B, in an Excel

workbook. Table A contains a formula that references a

value in Table B. If I move Table B to a different location

or rename it, the formula in Table A will display garbled

characters. To fix this, I need to update the formula in

Table A to reference the correct location or name of Table

B.

中文回答：

当涉及到从其他表格引用公式并在关闭后出现乱码的情况时，

可能会有几个潜在原因导致此问题。让我逐一解释一下。

1. 外部引用，一个可能性是被引用的表格或工作簿已经被移动

或重命名。当您从其他表格引用公式时，它会在两者之间创建一个

链接。如果被引用的表格不再位于相同位置或已更名，链接将被断

开，导致乱码。要解决这个问题，请确保被引用的表格位于正确的

位置，并且与创建公式时的名称相同。

2. 编码问题，另一个可能性是表格之间的编码设置不一致。不

同的编码设置可能导致字符显示不正确。要解决这个问题，请确保

两个表格的编码设置相同。您通常可以在文件或工作簿属性中找到

编码设置。

3. 兼容性问题，还有可能是创建表格时使用的软件版本之间存

在兼容性问题。如果使用不同版本的软件创建了这些表格，引用公

式时可能会出现乱码。更新软件到最新版本或确保两个表格都使用

相同的软件版本可以帮助解决此问题。

让我举个例子来说明这些观点。假设我在Excel工作簿中有两

个表格，表格A和表格B。表格A包含一个引用表格B中值的公式。

如果我将表格B移动到不同的位置或重命名，表格A中的公式将显

示乱码。为了解决这个问题，我需要更新表格A中的公式，以引用

表格B的正确位置或名称。