Excel如何知道文件“在最后一次保存之前没有重新计算".我可以欺骗Excel进行相反的思考吗? [英] How does Excel know that a file "was not recalculated before it was last saved". Can I trick Excel into thinking the opposite?

问题描述

在Excel中链接工作簿时，经常会出现类似以下错误:

When linking workbooks in Excel, I often get an error like:

xxxx.xlsx 的链接未更新，因为 xxxx.xlsx 在上次保存之前未重新计算

Links to xxxx.xlsx were not updated because xxxx.xlsx was not recalculated before it was last saved

此错误对于每个链接的值都会弹出一次，这意味着在我的情况下，我需要按OK大约100条警报.神秘地，即使 xxxx.xlsx 不包含任何公式，因此也根本没有重新计算，该警报也会出现:它完全充满了值.

This error pops up once for every linked value, which means in my case about 100 alerts I need to press OK for. Mysteriously, this alert comes even if xxxx.xlsx contains no formulas and hence no recalculation at all: it's completely full of values only.

那么Excel如何知道在保存之前尚未重新计算文件?它是否在查看我可以篡改的ZIP文件(xlsx)中的特定xml值?是在查看我可以使用 touch linux命令规避的开放日期还是修改日期?我想要一个解决方案，如果可能的话，请使用命令行ubuntu(我运行Windows WSL)，以便可以使用脚本.

So how does Excel know that a file has not been recalculated before saving? Is it looking at a particular xml value inside the ZIP file (xlsx) which I could tamper with? Is it looking at open date vs modified date that I could circumvent with the touch linux command? I'd like a solution Using the command line ubuntu if possible (I run windows WSL), so that I can use a script.

此外， xxxx.xlsx 确实很大，在家中通过网络(感谢COVID)打开/重新计算/保存的速度很慢.所以我真的不想在Excel中打开此文件.

And what's more, xxxx.xlsx is really big, which over network (thanks COVID) at home is slow to open / recalc / save. So I really don't want to ever open this file in Excel.

有什么想法吗?

推荐答案

您可以尝试将此宏添加到PERSONAL.XLSB文件中，然后运行它.它将要求您选择一个文件，然后在不允许链接更新的情况下将其打开.

You could try adding this macro to your PERSONAL.XLSB file and then running it. It will ask you to select a file and then open it without allowing links to update.

Sub OpenWithoutUpdatingLinks()

    Dim strFileName As String

    strFileName = Application.GetOpenFilename
    If strFileName <> "" Then Workbooks.Open FileName:=strFileName, UpdateLinks:=False

End Sub

这将使您可以打开正在处理的文件，而不会收到有关更新链接的消息.

This will allow you to open the file you're working on without getting the message about updating links.

但是，如果您实际上需要更新链接或需要创建更多链接，则需要重新计算链接文件.

However, if you actually need the links to update or need to create more links, then you need the linked file to be recalculated.

让我们知道您是否需要有关将宏添加到个人文件并运行它的说明.

Let us know if you need instructions on adding a macro to your personal file and running it.

这篇关于Excel如何知道文件“在最后一次保存之前没有重新计算".我可以欺骗Excel进行相反的思考吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！