formulas do not work sometimes...

[03021979]

I have a spreadsheet with formulas and macros. Sometimes when a certain user opens it, the formulas are not updated but cells contain these formulas.(this is not the matter of automatic recalculation - I've already checked this) This happens only in my company when some users use this sheet. There is all ok on my home computer. Is it possible that a spreadsheet is corrupted, when there is always all ok in my house? Can it be sth wrong with windows or excel at work?

 

[GlennUK]

If a user switches calculation mode to manual before opening your workbook, then calculation will not occur. You could put a Workbook_open event macro in to force calculation to be automatic, no matter what the user has done beforehand.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[03021979]

I said that this is not the point because when a certain user logs on after another one, formulas are not updated, but after computer restart everything is ok.. strange isn't it?

 

[GlennUK]

you say:

when a certain user logs on after another one

explain what this means exactly?

You are talking about opening a workbook. A user opening a workbook. What circumstances is this happening in? How is the workbook opened?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[combo]

If this happens with user defined functions - are the macros enabled (can be permanently disabled if high security level set).

combo

 

[03021979]

Glen was right when I turned off automatic calculation there were the same things as in my company! so this is the reason

 

[03021979]

how to put an open event macro in this case?

 

[GlennUK]

Go in the VBE, ( Alt-F11 ) ... you should see a set of Windows one of which shows the objects in the workbook ( the Project Explorer ). In this Window for the project for your workbook, right-click on ThisWorkBook and choose View Code. This will take you to the code Window, which has two drop-downs embedded in the top of it. Click the left one, and choose WorkBook ... this should automatically give you this code:

Private Sub Workbook_Open()

End Sub

... in between the two lines of code, type :
Application.Calculation = xlCalculationAutomatic

That's it!

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[03021979]

Thanks! I've already found it works perfectly!