yeah,
I think you/we discovered a
bug in excel 2007.
once the option "right to left"
is selected,
the option for "left to right"
is removed.
one possible method is to
reinstall excel but I haven't
tried it.
---------------------
there is however a possible
work around with the current
installation of excel and it's
slightly tricky.
open a blank workbook in
excel.
then under the "view" menu
option select "arrange all" for
the opened worksheet.
then select "cascade"
at the left hand corner and
above the first cell the work
book name will be notated.
right click on it and select
"view code"
this will take you to the
worksheets' visual basic
module.
then you will see "vba project" at
the top of the left hand window
and you will be able to click on
each spreadsheet that is notated
under it.
for each sheet there will be
a properties sheet in the window
below and it will have "display
right to left", in which case you
modify that property from true
to false
afterwards select "file" from
the menu bar and save then
exit and you will be taken
back to the worksheet.
hopefully the columns will
be left to right.
you will then need to save the
worksheet.
choose "save as" "other formats"
via the office button and name the
file book1 and then select the file
type as "excel macro enable workbook."
then try to save your work book in:
\Program Files)\Microsoft Office\
Office12\XLSTART
also, might as well save a copy in
"my documents".
----------------------
if you have a problem with
saving the workbook in the
"\xlstart" folder, it may be
due to not having admin
priviledges.
if so, exit excel and right click
on the excel short cut to pull
up the properties page.
I'm sure you have seen the
properties page for shortcuts
because it provides the option
to run in "compatibility" mode
however, you will need to look
around for the option to
"run as administrator".
after you save/apply the modification
above you should be able to save
into the xlstart folder.,
so open excel and book1 that you
saved in my documents.
then try to save it as "book1" as a
"excel macro enabled" file into the
xlstart folder:
[ \Program Files)\Microsoft Office\
Office12\XLSTART]
you should be able to save it
there and it should open up
with the left to right columns
when you startup excel.
--------------------
another trick is to hold
down the ctrl key and
click the excel shortcut
until a box pops up citing
that it will open in safe
mode.
the worksheet will open
with the columns left to
right.
unfortunately, I am not
sure what all is disabled
other than add-ins.
but you can try it out and
get back with us.
~db
"syed_sal_ali" <syed_sal_ali.4aclda@DoNotSpam.com> wrote in message
news:syed_sal_ali.4aclda@DoNotSpam.com...
>
> thanks...but the problem is that my excel has no option "international",
> i have searched everywhere.
> plz help.if it helps, i have the professional version of office.
> thanks
>
>
> +-------------------------------------------------------------------+
> |Filename: Untitled1.jpg |
> |Download: http://forums.techarena.in/attachment.php?attachmentid=10881|
> +-------------------------------------------------------------------+
>
> --
> syed_sal_ali
> ------------------------------------------------------------------------
> syed_sal_ali's Profile: http://forums.techarena.in/members/215772.htm
> View this thread: http://forums.techarena.in/ms-office-support/1332979.htm
>
> http://forums.techarena.in
>