New Member
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 🙂
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
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.
1 Guest(s)