problem in opening excel 2003

[Debashis]

hi, myself Debashis

whenever I am opening excel 2003, it is opening having rows in right side
and column number starting from right side of all sheets.

but if I create the file first, as like new> New Microsoft Excel Worksheet,
it is opening normally

pls advice
thanks in advance

 

[Gord Dibben]

Tools>Options>International

Set left to right.


Gord Dibben MS Excel MVP

 

[Debashis]

thank you very much sir,

but what I am finding, I have to do this operation every time I open excel.
is there any way excel to be opened normally

thanks again

 

[Jim Rech]

When you change the setting Gord suggested it should be permanent, that is,
it should be recorded in your registry and used thereafter for all new
worksheets. So either you're not changing the setting or it's not getting
recorded properly for some reason. Fwiw, this is the setting, which you can
check with the Regedit.exe program (Start->Run->Regedit.exe):

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options\DefaultSheetR2L

This is a Dword value and it should have a value of 0.

 

[Debashis]

thank you sir,
it works

When you change the setting Gord suggested it should be permanent, that
is, it should be recorded in your registry and used thereafter for all new
worksheets. So either you're not changing the setting or it's not getting
recorded properly for some reason. Fwiw, this is the setting, which you
can check with the Regedit.exe program (Start->Run->Regedit.exe):

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options\DefaultSheetR2L

This is a Dword value and it should have a value of 0.