在不使用 INDIRECT 的情况下防止 REF 错误？
因此，众所周知，如果删除工作表，间接函数可以防止公式被破坏：
=INDIRECT("Sheet2!A1")
即使 Sheet2 被删除并稍后替换，公式也将保留（而如果我们只有 Sheet2!A1 它会 中断并变为 =#REF!A1 。该工作表也可以清除其单元格（仅替换值）以防止中断，但这个问题专门针对删除工作表的情况。
否则会 防止公式的方法在这种情况下打破？间接有点慢，因为它必须重新计算所有内容 - 是否有一种替代方法可以以某种方式保留这些公式，即使工作表被删除并稍后替换？
So it's well known that an INDIRECT function can prevent formulas from breaking if a sheet is deleted:
=INDIRECT("Sheet2!A1")
Even if Sheet2 is deleted and replaced later, the formula will remain (whereas if we just had Sheet2!A1 it would otherwise break and become =#REF!A1. The sheet could also have its cells cleared (values replaced only) to prevent breaking, but this question is specifically about the case where sheets are deleted.
Is there another way to prevent formulas from breaking in this situation? INDIRECT is sort of slow since it has to recalculate everything - is there an alternative that somehow preserves these formulas even when the sheet is deleted and later replaced?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论