excel 365製作的excel檔中的圖片。

岳嘉星 0 信譽點數
2025-09-19T19:44:24.3933333+00:00

excel 365檔案中有圖片,然後將檔案傳給同事,同事會無法顯示圖片,而顯示文字'#value!' ,但線上檢視又正常

同事excel 版本是 2016

Microsoft Teams | Microsoft Teams 免費版 | 設定 | 隱私權
0 則留言 沒有留言

1 個回答

排序依據: 最實用
  1. IGYQ 22,340 信譽點數 獨立顧問
    2025-09-19T20:19:36.7933333+00:00

    Hi,

    You might want to try these steps.

    • Check what version of Excel folks are on. Just ask your colleagues straight up what they're using. Ideally, everyone sticks with Excel 365, or at least something from 2016 and up, you know, for the best shot at things working smooth together without glitches.
    • Embed those images right into the file, basically. Don't just link to them from somewhere else, because that can cause all sorts of headaches. Go to Insert, then Pictures, and drop it in there. Make sure it's actually embedded, not hanging out as a link.
    • Switch your images over to formats that play nice. Save them as PNG or JPEG first, before you bother inserting. That way, compatibility issues drop way down.
    • Look out for any formulas tied to those images. If they're getting generated on the fly or linked through some formula magic, double-check that it runs okay across versions. Or, you know, just turn them into plain static images to keep it simple.
    • If seeing the file right is the big deal and nobody needs to tweak it much, send it out as a PDF. Or flatten the pictures into a static copy. That sidesteps a ton of version drama.
    • Test it out on another setup. Grab a machine running the exact same Excel version as your team, open the file there, and see if the image mess shows up again.

    此回答有幫助嗎?

    0 則留言 沒有留言

您的回答

答案可由問題作者標示為「已接受」,而由仲裁者標示為「推薦」,這可協助使用者知道答案解決了作者的問題。