Home Sign Up Sign In
jsjcjsjc
V2EX  ›  问与答

excel 保留外部 vlookup 链接,会让体积爆大吗?

  •   
  •   jsjcjsjc · May 15, 2023 · 1445 views
    This topic created in 1275 days ago, the information mentioned may be changed or developed.
    如果把数据转成"值"就几 M,但是保留外部 vlookup 就要近 200M......打开奇慢

    有办法优化吗?

    感谢
  • vlookup
  • 奇慢
  • 保留
  • EXCEL
    1 replies  •  2023-05-15 10:10:36 +08:00
    rayyume
    rayyume
    May 15, 2023 via Android
    1
    最好把所有需要的数据源全部导入到一个 excel 中再 vlookup ，跨表引用害人害己
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   1422 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 22ms · UTC 16:47 · PVG 00:47 · LAX 08:47 · JFK 11:47
    ♥ Do have faith in what you're doing.