服务器文件已更新可用较新版本(OneDrive) [英] Server File Updated A newer version is available (OneDrive)

问题描述

我拥有一个在OneDrive上共享的电子表格，该电子表格包含VBA代码，因此必须在桌面版本中打开.进行更新后，只要我直接打开它(而不是通过OneDrive)，就会收到"服务器文件已更新，有新版本可用"消息.

I have a spreadsheet shared on OneDrive that I maintain, which contains VBA code so it must be opened in the Desktop version. Whenever I open it directly (not through OneDrive) after updates have been made, I get the "Server File Updated A newer version is available" message.

此电子表格的许多用户连续几天都无法打开该电子表格，因此只有在关闭并重新打开后才能看到更新.

Many of the users of this spreadsheet have it open for days on end, and therefore do not see the updates until they close and re-open it.

我想知道是否可以实现一些代码来定期检查OneDrive是否有新版本并触发"服务器文件更新有新版本"弹出窗口，或在至少强制关闭并重新加载电子表格.

I am wondering if it is possible to implement some code that periodically checks OneDrive whether a newer version is available and trigger the "Server File Updated A newer version is available" pop-up, or at least force a close and reload of the spreadsheet.

由于许多原因，这将是一个很大的帮助.当我打开文件时，Excel当然可以做得很好，但是我找不到任何重新触发此检查的方法.

This would be a great help for many reasons. Excel certainly does it well enough when I open the file, but I cannot find any way of re-triggering this check.

我希望这很有意义，并且有一个简单的解决方案.

I hope that makes sense and a simple solution is available.

Darren:)

推荐答案

解决方案

打开Windows应用程序Office Upload Center(您可以在Windows 10搜索中键入此内容以找到它.选择设置选中标记关闭"时，从Office文档缓存中删除文件.这将阻止将来发生此错误.单击删除缓存的文件"以更正当前实例的错误.

Open the windows application Office Upload Center (you can type this in the Windows 10 search to locate it. Select Settings Check mark Delete files from the Office Document Cache when they are closed. This will stop this error happening in the future. Click Delete cached files to correct the error for the current instance.

1)在Windows 7中搜索上传中心"

1) Search "Upload Center" in Windows 7

2)上传中心=>设置=>选中关闭时从Office文档缓存中删除的文件"框，然后单击删除缓存的文件

2) Upload Center => Settings => Check the box "Deleted files from office document cache when they are closed" and click "Delete Cached files

这篇关于服务器文件已更新可用较新版本(OneDrive)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！