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?
tx count summarize
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....
NO I know this, and tried this before, but with this way it doest work :Snigelk wrote: ↑Fri Aug 17, 2018 10:04 pmDoes this help?
https://www.youtube.com/watch?v=_YgCJb2FF-4
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 :Srain91 wrote: ↑Sat Aug 18, 2018 8:43 amNO I know this, and tried this before, but with this way it doest work :Snigelk wrote: ↑Fri Aug 17, 2018 10:04 pmDoes this help?
https://www.youtube.com/watch?v=_YgCJb2FF-4
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
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
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.spreadbetting wrote: ↑Sat Aug 18, 2018 1:08 pmDo you have calculation options set to manual or automatic in excel?
Please check the pictures to me. You can see that the "connection properties" option is inactive (grey), i cant click on it :S
You do not have the required permissions to view the files attached to this post.
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
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.
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.
-
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
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.
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.CallumPerry wrote: ↑Sat Aug 18, 2018 9:41 pmSurely 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.
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
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
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
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.ShaunWhite wrote: ↑Mon Aug 20, 2018 2:32 pmTX 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