bet angel freezing
James,James1st wrote:Anyone else having problems with a connected Excel spreadsheet recently?
Ive had no issues lately with excel updating.
Are you on the latest version; which mode are you logged in? (I upgraded to the non public version last night) and in mode 0, all well here?
Maybe try a new virgin BA spreadsheet, with just the time to see if it does the same?
This is the command i use as a count down timer :-
=IF(OR(ISERROR(F4/2),G1="In-play"),0,ROUND(F4/0.0000116,0))
Regards
Peter
-
Groovyelms
- Posts: 277
- Joined: Fri May 20, 2011 7:42 am
curoius that this old chestnut has come up again...
re my earlier posts!!!
Bt supafast infinity arrived here in Brighton at the beginning of the year, elated I signed.....
8 weeks later 3 missed appointments (them) no properly working phone for 5 of those 8 weeks.. and the broad band speed was at the death 30% less than promised ... I cancelled the contract.. it was from start to finish a complete and utter disaster...
thank good i retained the awaful virgin service...
Today the screen has frozen 5-6 times for anything between 20-30 secs, back to exactly how it was...
cheers groovy
re my earlier posts!!!
Bt supafast infinity arrived here in Brighton at the beginning of the year, elated I signed.....
8 weeks later 3 missed appointments (them) no properly working phone for 5 of those 8 weeks.. and the broad band speed was at the death 30% less than promised ... I cancelled the contract.. it was from start to finish a complete and utter disaster...
thank good i retained the awaful virgin service...
Today the screen has frozen 5-6 times for anything between 20-30 secs, back to exactly how it was...
cheers groovy
-
convoysur-2
- Posts: 1110
- Joined: Thu Jan 12, 2012 10:00 am
mine has been sticky all day,
i dont (cant) use excel
very slow and sticky at the moment ?
Marc
i dont (cant) use excel
very slow and sticky at the moment ?
Marc
Thanks for the replies.
Euler, I have it set at 19, been that way for years. However the baseline figure at the bottom of the screen jumps between 10 and 15, with a rare 17 popping up.
PeterLe, I have the latest live version running.
I have done a bit of investigating today and discovered further detail. I have one workbook connected with 2 sheets. The first sheet is just the standard multi sheet with no mods. The second sheet is my dashboard that has Excel coding, draws 3 charts and executes 100's of lines of VB code. The Remain Time on the first sheet (during recording) seems to be in line with the clock but on the second sheet starts to get "sticky". (Remain Time on sheet2 is just a copy of sheet1).
The problem is that whilst the Remain time on sheet2 starts off reducing by 2-4 second increments, it gradually slows down and gets sticky such that after 5 or so minutes of running, it is effectively freezing for maybe 9 seconds at a time. By the time the Remain time reaches zero the update increment can be as big as 20 seconds.
Since the VB is called on each odds change (via VB Calculate) then I have to conclude that the code complexity/ data recording is slowing the whole process down.
Except that when I run a similar sheet from 2 years ago when there was no such problems, I get the same slower response today.
I will keep narrowing the problem and let you know.
(Maybe my PC processor is as knackered as I am)
Euler, I have it set at 19, been that way for years. However the baseline figure at the bottom of the screen jumps between 10 and 15, with a rare 17 popping up.
PeterLe, I have the latest live version running.
I have done a bit of investigating today and discovered further detail. I have one workbook connected with 2 sheets. The first sheet is just the standard multi sheet with no mods. The second sheet is my dashboard that has Excel coding, draws 3 charts and executes 100's of lines of VB code. The Remain Time on the first sheet (during recording) seems to be in line with the clock but on the second sheet starts to get "sticky". (Remain Time on sheet2 is just a copy of sheet1).
The problem is that whilst the Remain time on sheet2 starts off reducing by 2-4 second increments, it gradually slows down and gets sticky such that after 5 or so minutes of running, it is effectively freezing for maybe 9 seconds at a time. By the time the Remain time reaches zero the update increment can be as big as 20 seconds.
Since the VB is called on each odds change (via VB Calculate) then I have to conclude that the code complexity/ data recording is slowing the whole process down.
Except that when I run a similar sheet from 2 years ago when there was no such problems, I get the same slower response today.
I will keep narrowing the problem and let you know.
(Maybe my PC processor is as knackered as I am)