如果excel文件引用了其它數(shù)據(jù)，甚至使用到系統(tǒng)的數(shù)據(jù)源時(shí)。每次啟動(dòng)這個(gè)excel文件就會(huì)提示你“此工作簿包含到其他數(shù)據(jù)源的鏈接”讓你選擇更不更新當(dāng)前數(shù)據(jù)，在確定不需要引用的文件數(shù)據(jù)時(shí)完全可以去掉這個(gè)提示。

在網(wǎng)上找了很多地方，大多都是"編輯"→“鏈接"→“查看鏈接源"（我的office2010及wps2010都沒(méi)有這項(xiàng)，office2003里有 囧）、CTRL+F查找"*.XLS"、"]"等都沒(méi)有作用，不能解決問(wèn)題。終于找到老外一個(gè)專門(mén)查找和發(fā)現(xiàn)鏈接數(shù)據(jù)源的小插件

FindLink.zip v9.2 (17 February 2009, 67k, 105622 downloads) - Updated
To look for links from a workbook, open or install the add-in FINDLINK.XLA, activate the workbook and use Tools / Find Links. It will ask you for a text string to look for. You can specify the name of a specific workbook (e.g. "SOURCE.XLS") or just ".XLS" to find references to any .XLS file. You can even enter "#REF" to find any names which refer to deleted ranges or a range name to find where that named range is used. Optionally the utility will list the occurrences, list and delete (replacing with values where appropriate), or ask you what to do with each occurrence. Version 9.2 fixes a few bugs and works with Vista.

把下載的文件解壓，里面是個(gè)xla宏加載文件，所以打開(kāi)時(shí)會(huì)彈出一個(gè)安全提示，點(diǎn)擊"啟用宏"，進(jìn)去后office2010就會(huì)多出一個(gè)"加載項(xiàng)"標(biāo)簽（其他版本可以在宏里查找FindLinks），再用常規(guī)方式打開(kāi)要去除更新提示的文件，點(diǎn)擊加載項(xiàng)里的"Find Links",按提示操作就行了。
還有一個(gè)不用插件的辦法就是把全表復(fù)制,選擇性粘貼為數(shù)值,但這樣會(huì)把表格里的公式也一起丟失。

去掉excel的“此工作簿包含到其他數(shù)據(jù)源的鏈接”提示