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?

To calculate *only* the active sheet:

<Shift> <F9>
--
HTH,

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


"Timmy Mac1" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

Many thanks Rag

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Timmy Mac1" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>