ActiveSheet.Calculate not calculating

[Ananth]

I am using ActiveSheet.Calculate in a Macro to calculate the activesheet. The
Macro has 400lines and every line is perfectly exceuted.

One Worksheet has complex Index formula (array function) that refers to a
large database of 30000 lines.

After the Macro execution , I find the sheet has not been calculated. I had
to manually do it using Shift+F9.

Wht is it happening

 

[Gary''s Student]

Does the command work if you insert:
DoEvents
after it?

 

[Dave Peterson]

I'd start by looking at Charles Williams' site:
http://www.decisionmodels.com/calcsecretsh.htm

Maybe it's working correctly, just not the way you want.

If I saw that, then I'd use application.calculate or .calculatefull or
..calculatefullrebuild or whatever I needed to make sure that my data was ok.

 

[Ananth]

Thanks very much for the hint. Yes, it started recalculating after I used
Worksheets("Tabname").calculate

Ananth