tx count summarize

[rain91]

i need to running 4 (same: excel1=excel2=excel3=excel4) excel in 4 betangel (i need to dispart/disjoin/disunite/unstick (i dont know which is the best word for this) the markets). I cant solved yet the multiple exel, because of the difficult vba codes.
The problem: I want to summarize tx count on this exels.
I tried to solve it, but after i connect to the angel it dosnt work (until i dont connect with exel and i change the tx count number cells with my hand it works ). How can i solve it?

[rain91]

Nobody know the solution?:S
I made something wrong?:S

[Euler]

If you are running multiple copies you can't easily do this. The TX count is global on one running version of Bet Angel but will be independent if you run multiple copies.

[nigelk]

Does this help?

https://www.youtube.com/watch?v=_YgCJb2FF-4

[rain91]

If you are running multiple copies you can't easily do this. The TX count is global on one running version of Bet Angel but will be independent if you run multiple copies.

I running just "single" copies. I just want to solve it on one multiple excel, but i cant do it (which works, like i want) yet....

[rain91]

Does this help?

https://www.youtube.com/watch?v=_YgCJb2FF-4

NO I know this, and tried this before, but with this way it doest work :S
Until i changed the tx count cell with hand it ok everything change and works well, but after i connect and the angel changed automtically the "tx count cell" it dosnt do nothing on the other exel...:S

[rain91]

Does this help?

https://www.youtube.com/watch?v=_YgCJb2FF-4

NO I know this, and tried this before, but with this way it doest work :S
Until i changed the tx count cell with hand it ok everything change and works well, but after i connect and the angel changed automtically the "tx count cell" it dosnt do nothing on the other exel...:S

So yeah its work, but after i opened the excel from Angel then it dosnt work :S

[spreadbetting]

Do you have calculation options set to manual or automatic in excel?

[rain91]

Do you have calculation options set to manual or automatic in excel?

I dont know what you think exactly. i attached 2pictures i think one of these should be what you wrote.
Please check the pictures to me.

1.JPG

You can see that the "connection properties" option is inactive (grey), i cant click on it :S

2.JPG

[spreadbetting]

I wouldn't have a clue as I can't understand whatever language it's in.

You should go onto an excel forum in your own language as it's nnot a hard thing to sum data from different worksheets and they should be able to sort it out very quickly for you.

[CallumPerry]

Surely you just want something simple like this:

https://www.youtube.com/watch?v=PszntzN3x1c

Just sum the tx count on each of your active tabs on your first tab or a dashboard tab.

[rain91]

Surely you just want something simple like this:

https://www.youtube.com/watch?v=PszntzN3x1c

Just sum the tx count on each of your active tabs on your first tab or a dashboard tab.

I made video.

https://www.youtube.com/watch?v=86til-M ... e=youtu.be

0-20sec it didnt work when i opened excels from angel...
about ~1min i just opened excels witout angel and then everything work...... so i cant understand what happend....

[ShaunWhite]

TX count is zero on both excels because you haven't created any transactions ?

In cell I5 on BetAngel__1.xls enter

='[BetAngel__1.xls]BetAngel'!$c$4 + '[BetAngel__2.xls]BetAngel'!$c$4

Then connect
Then create transacions

[rain91]

TX count is zero on both excels because you haven't created any transactions ?

In cell I5 on BetAngel__1.xls enter

='[BetAngel__1.xls]BetAngel'!$c$4 + '[BetAngel__2.xls]BetAngel'!$c$4

Then connect
Then create transacions

It was just because the video. When there are numbers then i was problem too :s but maybe now someone can help me and it solved i hope. I open the excel in wrong way. I hope just this was the problem.