hello,
I have a really bugging thing that keeps happening to me. On a specific
workbook, the word "calculate" appears at the bottom of the page. However the
option is on automatic and even after I recalculate (F9) it is still there.
I have tried with the following VBA when opening the workbook, but nothing
works. Any idea?
With Application
.Calculation = xlAutomatic
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = False
Calculate

Thanks
--
caroline

Hi Caroline,

Look here:

http://www.decisionmodels.com/calcsecretsf.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"caroline" <(E-Mail Removed)> wrote in message
news:84F31102-3109-4F5A-9CB5-(E-Mail Removed)...
> hello,
> I have a really bugging thing that keeps happening to me. On a specific
> workbook, the word "calculate" appears at the bottom of the page. However
> the
> option is on automatic and even after I recalculate (F9) it is still
> there.
> I have tried with the following VBA when opening the workbook, but nothing
> works. Any idea?
> With Application
> .Calculation = xlAutomatic
> .MaxChange = 0.001
> End With
> ActiveWorkbook.PrecisionAsDisplayed = False
> Calculate
>
> Thanks
> --
> caroline

Thanks a million. This link gave me the answer:
I hit one of Excels limits for tracking dependencies.



--
caroline


"Niek Otten" wrote:

> Hi Caroline,
>
> Look here:
>
> http://www.decisionmodels.com/calcsecretsf.htm
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "caroline" <(E-Mail Removed)> wrote in message
> news:84F31102-3109-4F5A-9CB5-(E-Mail Removed)...
> > hello,
> > I have a really bugging thing that keeps happening to me. On a specific
> > workbook, the word "calculate" appears at the bottom of the page. However
> > the
> > option is on automatic and even after I recalculate (F9) it is still
> > there.
> > I have tried with the following VBA when opening the workbook, but nothing
> > works. Any idea?
> > With Application
> > .Calculation = xlAutomatic
> > .MaxChange = 0.001
> > End With
> > ActiveWorkbook.PrecisionAsDisplayed = False
> > Calculate
> >
> > Thanks
> > --
> > caroline
>