2003/XP Macros in 2000

[Bernie T]

I am running Excel 2000 in Windows XP. I received an email with an .xls
attachment which, when I opened gave me the macro warning. I didn't need the
macros so I chose the disable option. I copied same to a new worksheet so I
could rework some of the data - which was not covered by the macros.
Whilst working with the new worksheet I noticed that the auto sum was not
working as normal. I re-dragged the range and it was OK. Later I was
working on another worksheet and I had the same problem, auto sum behaving
badly!
I contacted the email source (trusted) who asked what version I was on -
2000 but he was on 2003/XP and thought that this would be the problem, not a
virus.
My problem was he didn't know how to fix it - neither do I !
Can any one help ?
Regards,
Bernie T

 

[Jim Cone]

Have you checked that Calculation is set to automatic? ...
Tools | Options | Calculation (tab)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Bernie T"
wrote in message
I am running Excel 2000 in Windows XP. I received an email with an .xls
attachment which, when I opened gave me the macro warning. I didn't need the
macros so I chose the disable option. I copied same to a new worksheet so I
could rework some of the data - which was not covered by the macros.
Whilst working with the new worksheet I noticed that the auto sum was not
working as normal. I re-dragged the range and it was OK. Later I was
working on another worksheet and I had the same problem, auto sum behaving
badly!
I contacted the email source (trusted) who asked what version I was on -
2000 but he was on 2003/XP and thought that this would be the problem, not a
virus.
My problem was he didn't know how to fix it - neither do I !
Can any one help ?
Regards,
Bernie T

 

[Bernie T]

Hey Jim, that was easy, but that was the way it would have been set, would
the macro 'tripped' it ?
Thanks a million, Kindest Regards,
Bernie T
Darwin Australia

 

[Gord Dibben]

Common problem......not yet fixed in 2007 version.

Tools>Options>Calculation can be Auto or Manual.

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g>

If you want a particular workbook to always open in AutoCalc mode you can use
code to set it to auto whenever you open the workbook.

Private Sub Workbook_Open()
Application.Calculation = xlAutomatic
End Sub

Right-click on the Excel Icon left of "File" and select "View Code"

Paste the above into that module and save the workbook.


Gord Dibben MS Excel MVP