Flytallguy83
New Member
- Joined
- Nov 26, 2007
- Messages
- 4
Hello,
I am trying to use sumifs formulas across workbooks. I have read a couple of posts about this and wrote vb code to open each workbooks that my sumifs formulas reference. Even after I open and close each referenced workbook though, I still have #VALUE errors. I am using variables in my file paths when opening the referenced workbooks. Does anyone know what I could be doing wrong? If I manually open my referenced workbooks, my sumifs formulas calculate correctly.
I am trying to use sumifs formulas across workbooks. I have read a couple of posts about this and wrote vb code to open each workbooks that my sumifs formulas reference. Even after I open and close each referenced workbook though, I still have #VALUE errors. I am using variables in my file paths when opening the referenced workbooks. Does anyone know what I could be doing wrong? If I manually open my referenced workbooks, my sumifs formulas calculate correctly.