Calc F9) Button and time.
 

I'm working with a combination of large and small files. The larger
files I open for reference purposes only.

However, if I forget to close one before I update the calculations for
something I have done on the smaller files, it takes ages.

Is there anyway I could limit the impact of F9 to the file "on top" so
to speak?


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=483192

Calc F9) Button and time.
 

To calculate *only* the active sheet:

<Shift <F9
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Timmy Mac1" wrote
in message ...

I'm working with a combination of large and small files. The larger
files I open for reference purposes only.

However, if I forget to close one before I update the calculations for
something I have done on the smaller files, it takes ages.

Is there anyway I could limit the impact of F9 to the file "on top" so
to speak?


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile:
http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=483192

Calc F9) Button and time.
 

Many thanks Rag :)


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=483192

Calc F9) Button and time.
 

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Timmy Mac1" wrote
in message ...

Many thanks Rag :)


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile:
http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=483192