excel goes to sleep

[max-hikorski]

I sometimes use Excel to search for numbers with certain properties - the required numbers often turn out to be big, and many times I have run Excel through the night to complete the search.

I've just tried this on my new Windows 7 computer, and it turns out that when the computer goes to sleep, Excel does too, rather than continuing to run in the background as it used to on my old computer. This means that unless I keep activating the computer, the search is limited to a few minutes. Has anyone else had this problem, and is there any way around it?

Thank you,

Jonny

 

[Derek Brown]

Hello and welcome to The Board.
Probably it was just the display that was being turned off, on your old computer, with Windows still running.
The following may help:
http://blog.enterpriseitplanet.com/green/blog/2009/01/how-to-manage-windows-7-power-settings.html

 

[max-hikorski]

Hi Derek, and thanks for your welcome. Your advice looks to be spot on - I've adjusted my computer, and fingers crossed that'll do it; I'll post again if there are any more problems,

Thank you,

Max