Reading from different files

I'm sorry but I just have to say that it's "Excel", not "exile".

Are you just doing a straight reference of other data? If so then I have already provided the solution.

Are you doing something more interesting, like a lookup based on data in the other file? Then the solution is very similar, you just include the file name and sheet name in the cell reference, like in my simpler example.

This gets more difficult if the files that you want to reference change dynamically. That is, if today you want to reference "May 2014.xlsx" and next month you want that reference to automatically change to "June 2014.xlsx" then we are going to need a bigger thread.

My problem is that Excel only show the charts on my file if the source is open.

this are my code:
=COUNTIFS(
'Location]Name'!$J$3:$J$999,
">="&TODAY()-30,'Location'!$J$3:$J$999,"<="&TODAY(),
'Location]Other'!$N$3:$N$999,"Name")

&

=SUMIFS(
'Location]Other'!$O$3:$O$999,
'Location'!$J$3:$J$999,">="&TODAY()-30,
'Location]Other'!$J$3:$J$999,"<="&TODAY(),
'Location]Other'!$N$3:$N$999,"name")

Both codes work perfectly with the file open, but when the source is not open it is giving ##### and #VALUE!

COUNTIFS and SUMIFS require the other file to be open. One way to solve this is with macros. A more straightforward way is to use a "shadow" worksheet. The shadow worksheet has a formula in every cell that starts in A1 with

=A1

and so forth with every cell that is used in the other file.

Then your formulas refer to the "shadow" sheet instead of the other file.