Excel 2010 VBA源链接错误消息 [英] Excel 2010 VBA source link error message

问题描述

在xlsm工作簿中，我有一个自动打开的宏，它打开一个工作簿，该工作簿具有一个用户表单，其中有多个按钮链接到主工作簿。用户表单没有宏，只有指向我所有VBA代码的链接。这是从一个非常古老的Excel项目更新的。

In a xlsm workbook I have an auto open macro that opens a workbook that has a user form with multiple buttons linked to the master workbook. The user form book has no macros, only links to all my VBA code. This was updated from a very old Excel project.

当用户表单打开时，它会显示错误消息："此工作簿包含一个或多个链接无法更新的"。如果您点击"继续"按钮按钮一切都很好。如果您点击"修改链接"，按钮，你看到
主工作簿，并在状态下显示"未知"按钮即使这本书虽然是隐藏的，但仍是开放的（这在旧版Excel中不是问题。）

When the user form book opens it gives the error message: "This workbook contains one or more links that cannot be updated". If you click the "Continue" button everything is fine. If you click the "Edit Links" button you see the master workbook and under status it says "Unknown" even though the book is open though hidden. (This was not an issue in older Excel).

如果您点击"检查状态"，状态更新并说"打开"然后你继续所以没有出错，但我不希望我的客户每次启动程序时都必须单击继续。

If you click "Check Status" the status updates and says "Open" and you continue. So nothing goes wrong but I don't want my clients to have to click continue every time they start the program.

我已将AskToUpdateLinks - DisplayAlerts设置为false。用于错误恢复接下来但没有什么能阻止虚假错误。

I have set AskToUpdateLinks - DisplayAlerts to false. Used On Error Resume Next but nothing stops the bogus error.

欢迎所有建议！

推荐答案

Hi,

您能否分享更多关于如何设置链接的信息？

Could you please share more information how you set the link?

 

>>当用户表单打开时，它会显示错误消息："此工作簿包含一个或多个无法更新的链接"。

>>When the user form book opens it gives the error message: "This workbook contains one or more links that cannot be updated".

通常情况下，如果工作簿中有链接，我想我们会收到提示更新或不在工作簿打开时更新，同时，"要求更新自动链接"在
中，应选择Excel选项。

Normally, if there are links in the workbook, I think we would receive prompt to Update or Don’t Update when the workbook opened and at the same time, "Ask to update automatic links" in the Excel Options should be selected.

如果它警告"此工作簿包含一个或多个无法更新的链接"，则表示您更新链接且链接无效。

If it alert that "This workbook contains one or more links that cannot be updated", It indicates that you Update the links and the links are invalid.

 

对于您的情况，您是否更新宏中的链接？

For your case, do you update the link in your macro?

我建议您检查代码并删除句子以更新链接。

I suggest you check the code and remove the sentence to update the link.

问候，

Celeste

这篇关于Excel 2010 VBA源链接错误消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！