错误.另外,由于链接值出现错误,试图计算此值的函数可能会返回其他错误.原因打开工作簿时,如果上次保存它时所用的MicrosoftExcel的版本低于当前打开该文件所用的版本,则会出现此问题.原因是从起ExcelExcel2000,Excel会强制对所有已打开的以前在较低版本的中保存的所有工作簿彻底重新计算,而不管链接更新处于何种状态.为了...
We can't update some of the links in your workbook right now. You can continue without updating their values, or edit the links you think are wrong. 解决方法 若要解决此问题,请使用以下方法之一: 将工作簿 A 和工作簿 B 另存为 .xlsb 文件。
We can't update some of the links in your workbook right now. You can continue without updating their values, or edit the links you think are wrong. 解决方法 若要解决此问题,请使用以下方法之一: 将工作簿 A 和工作簿 B 另存为 .xlsb 文件。
When you open a workbook with links to other files for the first time, Excel shows a security warning informing you that the file contains links to external data. To allow the links to update, simply click theEnable Contentbutton. On subsequent openings of the same file, you will be presen...
Method 2 – Use the Edit Links Command to Find and Remove External Links in Excel Step 1: ➤ Go to theDatatab. ➤ Select theEdit Linksoption from theQueries & Connectionsgroup of commands. A dialog box namedEdit Linkswill open up. ...
How to Identify External Links in Excel Sheets To locate external links in your Excel sheets, you can use the following methods: Excel’s “Edit Links” feature: Go to the Data tab in the Ribbon menu, click the “Edit Links” button, which will display all external links in your spreadsh...
In the User Profiles and My Sites section, click Published links to Office client applications, as shown in the following figure. On the Published Links to Office Client Applications page, click New. Enter the URL to the data connection library. Note The URL must be directly to the data con...
Still Getting the External Links Prompt? Sometimes, you may find and remove all the external links, but still get a prompt as shown below: Don’t go crazy and start cursing Excel. So if you’re getting the update links prompt, also check the following for external links: ...
This behavior occurs even if you decide not to update those links when you are prompted. Excel updates the workbook calculation chain to the current version of Excel. If the values of the external link sources are not available in the external link table in the workbook, Excel ...
In Excel for the web, you can click the "Refresh" button or use the "Refresh All" option to update all the linked data in the workbook. Please note that the functionality and behavior of external links may vary depending on the specific version of Excel for the web and SharePoint being...