参考其他工作簿的公式 [英] formula referencing other workbooks
问题描述
A ---------- B ------- C ----- D -------------------------------- E ----------
workbook1 sheet1 A1'[workbook1.xlsx] sheet1'!$ A $ 1 =(????
workbook2 sheet1 A1'[workbook2.xlsx] sheet1'!$ A $ 1
workbook3 sheet1 A1'[工作簿3.xlsx] sheet1'!$ A $ 1
给定A,B和C,我可以创建D但我没有办法在E中的公式中使用它。
我不能在公式中引用D中的上述字符串,INDIRECT也不起作用。
根据Excel 2007帮助INDIRECT:
如果ref_text引用另一个工作簿(外部引用),另一个工作簿必须打开,如果源工作簿未打开,INDIRECT返回#REF!错误值。
是否有相关文件打开一个选项?
如果没有,听起来像某些脚本可能需要.. 。
Given a list of workbook's filenames, write a formula to reference a specific cell value in the specified workbook.
A----------B-------C-----D--------------------------------E----------
workbook1 sheet1 A1 '[workbook1.xlsx]sheet1'!$A$1 =(????
workbook2 sheet1 A1 '[workbook2.xlsx]sheet1'!$A$1
workbook3 sheet1 A1 '[workbook3.xlsx]sheet1'!$A$1
Given A,B and C, I can create D but I find no way to use it in a formula in E.
I am not able to reference the above string in D in a formula. Also INDIRECT does not work.
According to Excel 2007 Help on INDIRECT:
If ref_text refers to another workbook (an external reference), the other workbook must be open. If the source workbook is not open, INDIRECT returns the #REF! error value.
Is having the relevant files open an option?
If not, sounds like some scripting might be required...
这篇关于参考其他工作簿的公式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!