I collect data from a DDE link and my spreadsheet normally, and through most
of today, calculated at its normal fast speed. I made a minor change here
and there to some spreadsheets and suddenly noticed that my worksheets are
laboring in recalculations that go on continuously (stock price real time
feed). Well, at first I thought it might have to do with the data source
itself, but now after market hours, I notice that a scroll bar I use to move
a vertical dotted line back and forth across the charts is lagging behind my
clicks. Normally, the scroll bar actions would move the cursor
instantaneously.
I have checked all of the usual suspects... am I overlooking something
rather obvious?
I'd appreciate any suggestions on things to try to pull the calculation
performance back up to its old standard... of just a couple of hours ago!!!
My thanks in advance! Brad
Nick Hodge - 09 Dec 2006 09:15 GMT
Brad
I guess you've tried a re-boot?

Signature
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk
>I collect data from a DDE link and my spreadsheet normally, and through
>most of today, calculated at its normal fast speed. I made a minor change
[quoted text clipped - 14 lines]
>
> My thanks in advance! Brad
Brad - 09 Dec 2006 15:39 GMT
Nick, thanks, sure... a couple of times. I am back in the morning to see if
I can tackle the issue with a clearer head. It still doesn't respond
rapidly, so I may try a few other ideas. What is odd is how it suddenly
deteriorated... I saw some Norton Software get updated... I will check that
out to see if it is an issue. Brad
> Brad
>
[quoted text clipped - 18 lines]
>>
>> My thanks in advance! Brad