MACRE0

Not sure why it won't calculate but you could force it by placing code in
the Workbook_SheetActivate event like so

Private Sub Workbook_SheetActivate(ByVal sh As Object)
sh.Calculate
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"MACRE0" wrote in
message ...

Excel is having a tough time shifting from one tab to another and
recalculating the page. If however I clikc F9 the tab is fine. Is
there anyway to make it when clicking upon the tabs that they refresh
automatically? I was considering a macro that would refresh every 15
seconds or something, but I thought I'd ask this first. I'd
appreaciate help with either, thanks.


--
MACRE0
------------------------------------------------------------------------
MACRE0's Profile:
http://www.excelforum.com/member.php...o&userid=10848
View this thread: http://www.excelforum.com/showthread...hreadid=478527