November 6, 2019
Hey everyone, first of all I would already now apologize because i do not have a lot of experience with excel and neither is engl. my mother language.
However, i give it a try.
My problem is that i have different excel files (lets say file A, B, C, D) on a server which are closed and one excel file I am working with a P&L.
The information in the P&L are linked with SUMIF formulas to the files A,B,C,D which are not open.
I always need to open file A,B,C,D that the P&L file can update the values but I would like to have a successful update without open file A,B,C and D.
Is there a general macro I can use to make this happen?
Thanks very much 🙂
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013
Not a good idea, sounds like you need a design improvement.
See this article about how to bring data from a folder with multiple files. You can combine all the files into 1 table in you PL file, then point your formulas to this table, they will no longer be referring to external files. To update data, a simple refresh will do the job.