:Avoid data reference update tips: How to deal with common error pop-ups in other tables-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Avoid data reference update tips: How to deal with common error pop-ups in other tables

Avoid data reference update tips: How to deal with common error pop-ups in other tables

Author: daogeziyuan • • Table skills • Views 791
When we open the form, why does a yellow box pop up under the edit bar that says "Reference Update"? This is because a cell in the current workbook refers to data in another workbook, and the referenced data source has changed, so this prompt box pops up. So how to deal with it? First, we can check the referenced data source by clicking the "Edit Link" button under the "Formula" tab to confirm whether the data needs to be updated. If the data needs to be updated, click "Update". If no update is needed, click "Disconnect Link". ” or close the prompt directly. It should be noted that after disconnecting the link, the document will retain the previously referenced data. Even if the referenced data source document is changed, the current document data will not be updated, and no prompt will pop up thereafter. When this prompt box pops up after clicking the "Update" button in the prompt box, it means that the referenced workbook cannot be found. At this time, you can ignore this prompt by clicking Continue. Clicking the "Edit Link" button will jump to the "Edit Link" ” dialog box, you can also enter the dialog box by clicking the “Edit Link” button under the “Formula” tab. In the "Edit Link" dialog box, the left window is related information about the reference source. At this time, the status of the data source prompts an error. Click "Change Source" to find the location of the data source and confirm to update the data. At this time, the status also changes. as "ok". If there is no data update in the data source, no prompt box will appear when you open the current table again. "Open source file" does not respond when the data source is in an error state, but can open the data source when it is in a correct state. "Check Status" can quickly determine whether the reference source is correct. In the "Startup Prompt" at the bottom of the dialog box, you can set the "Update Startup Prompt for Referenced Data Source" as needed. Generally, the default is sufficient.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/bi-mian-shu-ju-yin-yong-geng-xin-ti-shi-chu-li-qi-ta-biao-ge-chang-jian-cuo-wu-tan-chuang-de-fang-fa.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 缘 Columnist
48 196
single-end

Related Suggestion