Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel grabbing focus on web update

16 Sep 2010   #1
masplin

Windows 7 64 bit
 
 
Excel grabbing focus on web update

I have an excel spread sheet pulling web queries on stock market data every few minutes. Every time it updates it jumps to the foreground and won't let me continue with any other app until the update has finnished. This never happened in 2007 so how can I turn this off? I am using windows 7 64 bit.

Thanks Mike


My System SpecsSystem Spec
.
16 Sep 2010   #2
Lomai

Win7 HP (x64)/Win7 Ultimate (x64)
 
 

Hi


Have a look at this thread - Outlook 2010 EXCEL (64 bit) problem
I don't think it's the answer to your issue but may clarify in some way
regards
My System SpecsSystem Spec
16 Sep 2010   #3
masplin

Windows 7 64 bit
 
 

Thanks but the refresh is working perfectly. It is in someway related to the active window and windows pushing this to foreground. Maybe in Excel 2007 the refresh of data didn't make the window automaticalyl active whereas 2010 does.
My System SpecsSystem Spec
.

16 Sep 2010   #4
Lomai

Win7 HP (x64)/Win7 Ultimate (x64)
 
 

Have you tried using Alt+Tab to rearrange your active windows whenever Excel is performing the update/refresh?

Regards
My System SpecsSystem Spec
17 Sep 2010   #5
masplin

Windows 7 64 bit
 
 

I assume alt-tab moves to the next window. If I click on another app excel grabs it back again. I have about 8 differnet calls for data as info comes form different sources so i guess as each call starts it makes excel the active/foreground app. Each call lasts maybe 5 seconds so essentially i can't use any other app for a minute while it works through them.

I did some digging and saw related issues that involved the follwing solution












I have seen this issue before it's "Prevent applications from stealing focus"
Unfortunately i didn't find a solution for Windows 7
You could try something that used to work in XP and sometimes in Vista

1, Go To Start > Regedit
2, Go to HKEY_CURRENT_USER > Control Panel > Desktop
4, Right Click and Click on Export, name it Registrybackup and save it
3, On Right side you can see ForegroundLockTimeout
4, Change the ForegroundLockTimeout value to 30d40 (Hexadecimal) or 200000 (Decimal) to 0


I was a little unclear on the last line, but I tried changing the registry to 200000 and rebooting but hasnt made any difference. I read that shoudl be the default but mine was set to 0. I have just chekced and it has sreset to 0. This seems a common problem as this guy posted

Registry value changing : foregroundlocktimeout, focus, refresh, registry

So I think this is the issue and i need toi keep this registry key at 200000.
My System SpecsSystem Spec
17 Sep 2010   #6
masplin

Windows 7 64 bit
 
 

This seems to have fixed it. No idea why it changed back to zero. Useful tool to monitor your registry in case there is some app changing registry values is this

Process Monitor
My System SpecsSystem Spec
18 Sep 2010   #7
Lomai

Win7 HP (x64)/Win7 Ultimate (x64)
 
 

Thanks for keeping us posted on your progress.

Take care and regards
My System SpecsSystem Spec
21 Sep 2010   #8
masplin

Windows 7 64 bit
 
 

As a floow up on this I was then left with the problem others have found where the icon now flashes in the task bar. This is extremely irritating as it pops up over your application if you usually work with the taskbar hidden. You can change the number of flashes in the registry by ammending the registry value for ForegroundFlashCount in the same folder to 0 = continuous flashing or any number for a number of flashes. There is however no way to turn it off.

A number of other forums suggest using Tune Up Utilities as it has a function to turn of the flashing. I gave this a try and yes it does turn off the flashing but it also disables the ForegroundLockTimeout setting so instead you are back to the window popping to the front and grabbing focus!

I do wish they would stop trying to improve some things!!!
My System SpecsSystem Spec
Reply

 Excel grabbing focus on web update




Thread Tools




Similar help and support threads
Thread Forum
Power Query for Excel January update
Source: Power Query January update‚
News
W7 keeps deleting my excel ss desktop icon whenever I update it??
Whenever I update my Excel speadsheet after first opening it by clicking the desktop icon. It then deletes the desktop icon when I save the sheet. It only does it with this particular icon. If I try copying the ss from another backup location back onto the desktop it says 'this is a duplicate...
Microsoft Office
Allow 1 screen to focus on desktop, and other to focus on game?
Say I am playing a game, that game is a full screen game being displayed on one monitor, and I have itunes open in the other monitor. The song changes, and I dont like it, I can free my mouse, and move it to the other monitor, but if I click anything, Windows sees that as me wanting to focus the...
Software
Last night's Windows 7 Update, grabbing 192.168.123.xxx IPs now
Came to the office this morning and all the Windows 7 machines dropped off the network after a Windows update last night. No other machines (Mac, CentOS, Ubuntu) were affected. I had to static the IPs on them in order to get them to connect otherwise they would just grab 192.168.123.xxx IPs.
Network & Sharing
Resource hogging and window grabbing
When I play back recorded TV, WMC is very greedy and eats up all of my CPU time. I can look at menus, TV Guide, etc. without problem - it's just playback that is the hassle. But the really big problem that I've got is that even when the window is not full-screen, WMC doesn't like to let go of...
Media Center
what's the possibility of me grabbing win7 elsewhere?
i need to get a 32-bit iso of win7, and i keep getting bumped out with this gem: The webpage...
General Discussion


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 00:37.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App