Urgent - Excel worksheet 的兩個連結問題)

%3CLINGO-SUB%20id%3D%22lingo-sub-1545331%22%20slang%3D%22en-US%22%3EUrgent%20-%20Excel%20worksheet%20%E7%9A%84%E5%85%A9%E5%80%8B%E9%80%A3%E7%B5%90%E5%95%8F%E9%A1%8C)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1545331%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%E6%82%A8%E5%A5%BD%EF%BC%8C%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%E6%9C%89%E4%BB%A5%E4%B8%8B%E5%85%A9%E5%80%8B%E5%95%8F%E9%A1%8C%E6%80%A5%E9%9C%80%E5%B0%8B%E6%B1%82%E5%8D%94%E5%8A%A9%E5%8F%8A%E6%8F%90%E4%BE%9B%E8%A7%A3%E6%B1%BA%E6%96%B9%E6%A1%88%EF%BC%9A-%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E(1)%20Excel%20worksheet%20%E7%9A%84%E9%80%A3%E7%B5%90%E8%A2%AB%E8%87%AA%E5%8B%95%E9%8C%AF%E8%AA%A4%E5%9C%B0%E6%9B%B4%E6%94%B9%E8%80%8C%E5%B0%8E%E8%87%B4%E4%B8%8D%E8%83%BD%E9%80%A3%E7%B5%90%E4%B8%8A%E5%85%B6%E4%BB%96Excel%20file%E7%9A%84%E8%B3%87%E6%96%99%E4%BE%86%E6%BA%90%26nbsp%3B(%E8%A6%8B%E9%99%84%E4%BB%B6%E6%88%AA%E5%9C%96%E4%B8%80)%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%E9%80%A3%E7%B5%90%E7%94%B1%26nbsp%3B%26nbsp%3B%20%3CSPAN%3E%3D'%3CA%20href%3D%22https%3A%2F%2Fnrcl.sharepoint.com%2Fsites%2FNRG%2Ffolder%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fnrcl.sharepoint.com%2Fsites%2FNRG%2Ffolder%3C%2FA%3E%201%2FSecurities%2F%E8%82%A1%E7%A5%A8%2F8536%2F%5B8536.xlsx%5D%E4%BB%93%E4%BD%8D%E5%90%8C%E6%AD%A5'!%24D%2432%20%E8%A2%AB%E8%87%AA%E5%8B%95%E6%94%B9%E8%AE%8A%E7%82%BA%3D'%3CA%20href%3D%22https%3A%2F%2Fnrcl.sharepoint.com%2FTempUserProfiles%2FNetworkService%2FAppData%2FLocal%2FPackages%2Foice_16_974fa576_32c1d314_3b00%2FAC%2FTemp%2F%E8%82%A1%E7%A5%A8%2F8536%2F%5B8536.xlsx%5D%E4%BB%93%E4%BD%8D%E5%90%8C%E6%AD%A5'!%24D%2432%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fnrcl.sharepoint.com%2FTempUserProfiles%2FNetworkService%2FAppData%2FLocal%2FPackages%2Foice_16_974fa576_32c1d314_3b00%2FAC%2FTemp%2F%E8%82%A1%E7%A5%A8%2F8536%2F%5B8536.xlsx%5D%E4%BB%93%E4%BD%8D%E5%90%8C%E6%AD%A5'!%24D%2432%3C%2FA%3E%20%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%E8%AB%8B%E5%95%8F%E6%98%AF%E7%99%BC%E7%94%9F%E4%BA%86%E4%BB%80%E9%BA%BC%E5%95%8F%E9%A1%8C%EF%BC%8C%E5%B0%8E%E8%87%B4%20Excel%20worksheet%20%E7%9A%84%E9%80%A3%E7%B5%90%E8%A2%AB%E8%87%AA%E5%8B%95%E9%8C%AF%E8%AA%A4%E5%9C%B0%E6%9B%B4%E6%94%B9%EF%BC%8C%E8%88%87%E5%8F%8A%E5%A6%82%E4%BD%95%E8%A7%A3%E6%B1%BA%E6%89%8D%E4%B8%8D%E6%9C%83%E7%94%A2%E7%94%9F%E4%B8%8A%E8%BF%B0%E7%9A%84%E6%83%85%E6%B3%81%EF%BC%9F%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%3E(2)%20Excel%20worksheet%20%E7%9A%84%E9%80%A3%E7%B5%90%E6%9C%AA%E8%83%BD%E8%87%AA%E5%8B%95%E6%93%B7%E5%8F%96%E6%9B%B4%E6%96%B0%3CFONT%20size%3D%222%22%3E%E5%85%B6%E4%BB%96Excel%20file%E7%9A%84%E8%B3%87%E6%96%99%E4%BE%86%E6%BA%90%3C%2FFONT%3E%E6%95%B8%E5%80%BC%E8%80%8C%E9%9C%80%E8%A6%81%E6%89%8B%E5%8B%95%E5%8E%BB%E6%9B%B4%E6%96%B0%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%E9%96%8B%E5%95%93%20Excel%20worksheet%20%E5%8F%8A%E9%80%8F%E9%81%8E%E9%80%A3%E7%B5%90%E6%93%B7%E5%8F%96%E5%85%B6%E4%BB%96%20Excel%20file%E7%9A%84%E6%9C%80%E6%96%B0%E6%95%B8%E5%80%BC%E6%99%82%20(%E8%A6%8B%E9%99%84%E4%BB%B6%E6%88%AA%E5%9C%96%E4%BA%8C)%EF%BC%8C%E5%B0%8D%E8%A9%B1%E5%8C%A3%E9%A1%AF%E7%A4%BA%E3%80%8C%E8%AD%A6%E5%91%8A%EF%BC%9A%E6%9C%AA%E9%87%8D%E6%96%B0%E8%A8%88%E7%AE%97%E4%BE%86%E6%BA%90%E3%80%8D%26nbsp%3B(%E8%A6%8B%E9%99%84%E4%BB%B6%E6%88%AA%E5%9C%96%E4%B8%89)%EF%BC%8C%E5%86%8D%E6%8C%89%E3%80%8C%E6%9B%B4%E6%96%B0%E6%95%B8%E5%80%BC%E3%80%8D%E5%BE%8C%EF%BC%8C%E5%B0%8D%E8%A9%B1%E5%8C%A3%E9%A1%AF%E7%A4%BA%E3%80%8C%E7%84%A1%E6%B3%95%E6%9B%B4%E6%96%B0%E8%87%B3%E9%80%A3%E7%B5%90%E3%80%8D%20(%E8%A6%8B%E9%99%84%E4%BB%B6%E6%88%AA%E5%9C%96%E5%9B%9B)%EF%BC%8C%E9%A0%88%E5%86%8D%E6%8C%89%E3%80%8C%E7%A2%BA%E5%AE%9A%E3%80%8D%E6%89%8D%E8%83%BD%E6%9B%B4%E6%96%B0%EF%BC%8C%E8%AB%8B%E5%95%8F%E6%98%AF%E7%99%BC%E7%94%9F%E4%BA%86%E4%BB%80%E9%BA%BC%E5%95%8F%E9%A1%8C%EF%BC%8C%E6%87%89%E5%A6%82%E4%BD%95%E8%A7%A3%E6%B1%BA%E6%89%8D%E5%8F%AF%E8%87%AA%E5%8B%95%E9%80%8F%E9%81%8E%E9%80%A3%E7%B5%90%E6%93%B7%E5%8F%96%E5%85%B6%E4%BB%96%20Excel%20file%E4%BE%86%E6%BA%90%E7%9A%84%E6%9C%80%E6%96%B0%E6%95%B8%E5%80%BC%EF%BC%9F%3CBR%20%2F%3E%3CBR%20%2F%3E%E8%AC%9D%E8%AC%9D%EF%BC%81%3CBR%20%2F%3EStephen%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1545331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

您好,

有以下兩個問題急需尋求協助及提供解決方案:-

(1) Excel worksheet 的連結被自動錯誤地更改而導致不能連結上其他Excel file的資料來源 (見附件截圖一)

    連結由   ='https://nrcl.sharepoint.com/sites/NRG/folder 1/Securities/股票/8536/[8536.xlsx]仓位同步'!$D$32 被自動改變為='https://nrcl.sharepoint.com/TempUserProfiles/NetworkService/AppData/Local/Packages/oice_16_974fa576_...

      請問是發生了什麼問題,導致 Excel worksheet 的連結被自動錯誤地更改,與及如何解決才不會產生上述的情況?

 

(2) Excel worksheet 的連結未能自動擷取更新其他Excel file的資料來源數值而需要手動去更新

     開啓 Excel worksheet 及透過連結擷取其他 Excel file的最新數值時 (見附件截圖二),對話匣顯示「警告:未重新計算來源」 (見附件截圖三),再按「更新數值」後,對話匣顯示「無法更新至連結」 (見附件截圖四),須再按「確定」才能更新,請問是發生了什麼問題,應如何解決才可自動透過連結擷取其他 Excel file來源的最新數值?

謝謝!
Stephen

 

 

0 Replies