×
英文
很抱歉,此文章目前沒有您所使用語言的版本。

How to correct a #CONNECT! error

#CONNECT errors occur when a formula can’t connect to a required resource. See the following:

General

  • The path is incorrect, or the file was deleted or moved.

  • You don't have permission to access the file.

  • The linked workbook couldn't be read and may be corrupt.

Can't access a required service because there is a problem connecting to the internet. Check the internet connection on your device and try again. For more information, see Fix network connection issues in Windows 10.

Workbook links

Refreshing of locally saved workbooks are not supported in Excel for Web. To refresh these workbook links, open the the workbook in Excel Desktop or Excel Mac on the device with the linked workbook.  

The workbook cannot be read and may be corrupt.

The linked workbook couldn't be accessed. This file may have been moved or you may no longer have permission to access it.

A required service is not responding or may be undergoing maintenance. 

The linked workbook is on another internet domain and can't be refreshed. A domain has a unique URL address that points to services, web sites, data centers, or personal computers.

The linked workbook could not be read because you are not logged in.

This workbook has exceeded the limit for linked workbooks.

The workbook you are referencing exceeds the maximum supported workbook size.

Image

Can't access resources required for an image.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Create, edit, and manage connections to external data

External links in Excel for the web

增進您的 Office 技巧
探索訓練
優先取得新功能
加入 Office 測試人員

這項資訊有幫助嗎?

感謝您的意見反應!

感謝您的意見反應! 我們將協助您與我們的其中一個 Office 支援專員連絡以深入了解您的意見。

×