本文介绍了EXCEL公式无法自动更新!帮助!的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个excel公式,可以在excel中提取文件名并将其放入字段中.问题是,当我打开多个已经完成的文件时,它将重新命名文件名并将其更新为最后打开的文件.因此,如果我先打开MFULTON,然后再打开JADAM,则JADAM的文件名单元将为MFULTON.如果我手动双击并按Enter,它将自动更正为JADAM,但是我的同事们不知道该怎么做.发生什么事了?

I have an excel formula to pull the name of the file in excel and put it into a field. The problem is, when I open multiple files I've already done, it repulls the file name and updates it to the LAST file opened. So if I opened MFULTON and then JADAM, the file name cell for JADAM would real MFULTON. If I manually double click and press enter, it will auto correct back to JADAM, but my colleagues won't know how to do this. What is happening?

推荐答案

您可以尝试一下.转到 File-> options-> Formulas-><工作簿计算>选择自动".并选中"公式自动完成"复选框.

You can try this. Go to File->options->Formulas-> Workbook Calculation-> Select Automatic. And also Check the check box Formula Auto Complete.

这篇关于EXCEL公式无法自动更新!帮助!的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-27 12:52