Bizzare Excel Problem

[Norphy]

I have an excel problem that comes under the "bit bloody odd" classification

 

Here is a nice healthy Excel window. Please note the labels on the columns, normal A, B, C etc

 

http://www.hglan.com/Norphy/good.jpg

 

Here is a weird Excel window on a Virtual PC which opened a spreadsheet created in Assesment Manager (always laugh when I install SIMS and see assman.exe come up )

 

http://www.hglan.com/Norphy/bad.jpg

 

Please note the labels on these columns, they're 1, 2, 3, 4 etc and also please note the cell name. I don't know if Assessment Manager is the cause of this but whatever it is, its screwing a lot of people up as their cell forumlae no longer work. Does anyone have an idea how to fix it? As far as I can make out Excel does not have a default template like Word so I can't delete it and see if that fixes it.

 

This has happened on two versions of Excel, Excel 2000 and 2003.

 

Any ideas?

 

Cheers,

 

Norphy

 

/edit Whatever it is, it appears to be a per user thing so if need be I could delete their roaming profiles to fix it. However that is going a bit too far

[DMcCoy]

Tools -> Options -> General. R1C1 reference style

 

Untick it

[Geoff]

Choose Tools > Options and select the General tab

Remove the check mark from 'R1C1 reference style'

[Norphy]

Ah

 

Thats got it.

 

Thanks guys