Useing data from defferent workbook

[emukiss10]

Hello,

I have a little problem. I have a large statistic table in one WB and in a different WB references to the first one. When I open my second WB i see #ARG ! in every cell, but when I open both the values are displaying properly.

Can I somehow fix it so that values would be correct if only second WB was opened?

Best Regards
W.

 

[RoryA]

What are the formulas in the second workbook?

 

[emukiss10]

Random cell -> (suma.warunków = sumifs)

=SUMA.WARUNKÓW([STAT.xlsm]Licznik!$T$2:$T$50000;[STAT.xlsm]Licznik!$R$2:$R$50000;$A$4;[STAT.xlsm]Licznik!$B$2:$B$50000;C$2;[STAT.xlsm]Licznik!$J$2:$J$50000;">="&"2017-09-01";[STAT.xlsm]Licznik!$J$2:$J$50000;"<="&"2017-09-30")

 

[RoryA]

You seem to have omitted the important part - what function is being used? If it's a SUMIF(S)/COUNTIF(S) then they do not work with closed workbooks.

 

[emukiss10]

Ok, so that would be the case I presume.. Can I somehow import data to the second WB? Mayby whole sheet with sums from which I made my formulas?

 

[RoryA]

Yes, there are many ways that could be done. Which version of Excel do you have?

 

[emukiss10]

office 2010 plus
excel 14.0.7188.5000 SP2 MSO 12.0.7188.5002

 

[RoryA]

If you have the (free) Power Query add-in, you could use that to query the other workbook and bring all the data into a new sheet in your second workbook. If you don't you can use MSQuery to do the same thing, or you can use code to either import or simply copy the sheet.

 

[emukiss10]

I use MS Office at work, so I cant add any feature nor install anything. My STAT WB is being updated very often and I need something to import data to my second WB. I do not want to open two files at the same time. Can you help?

 

[RoryA]

MSQuery should be installed by default so you should be able to use that as long as you want to import the entire worksheet. Use the Data - From other sources - From Microsoft Query option, then choose Excel Files* in the Database tab and browse to your file. (If you get a message about no visible tables, click the Options button and make sure that the System tables option is checked).