Ok, now upon obtaining a spreadsheet from a client months ago, Excel
changed my reference style to R1C1. I have changed it back several
times using the Options/General/and unchecking the R1C1 box, however,
every time I reboot my computer, Excel reverts back to the R1C1 style
just as if it had never been changed.
Any help would be MUCH appreciated as this is getting to be very
annoying.
Thank you!
Khrystle.--
khrystle
------------------------------------------------------------------------
khrystle's Profile: www.excelforum.com/member.php...oamp;userid=32037
View this thread: www.excelforum.com/showthread...hreadid=517843Do you have a default book, Book.xlt, that has that style? Book.xlt will
reside in the XLStart directory if you have one.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;khrystlequot; gt; wrote in
message ...
gt;
gt; Ok, now upon obtaining a spreadsheet from a client months ago, Excel
gt; changed my reference style to R1C1. I have changed it back several
gt; times using the Options/General/and unchecking the R1C1 box, however,
gt; every time I reboot my computer, Excel reverts back to the R1C1 style
gt; just as if it had never been changed.
gt;
gt; Any help would be MUCH appreciated as this is getting to be very
gt; annoying.
gt;
gt; Thank you!
gt;
gt; Khrystle.
gt;
gt;
gt; --
gt; khrystle
gt; ------------------------------------------------------------------------
gt; khrystle's Profile:
www.excelforum.com/member.php...oamp;userid=32037
gt; View this thread: www.excelforum.com/showthread...hreadid=517843
gt;
Thanks for responding, Bob.
No, I have searched even hidden and system files and did not find any
default book like you mention. Also I checked in the XLStart directory
and it is totally empty.
I'm really stumped here.
Any other ideas? Is there somewhere in a .dll that this can be changed
manually?
Thanks!
Khrystle.--
khrystle
------------------------------------------------------------------------
khrystle's Profile: www.excelforum.com/member.php...oamp;userid=32037
View this thread: www.excelforum.com/showthread...hreadid=517843khrystle, why not create your own book.xlt, mentioned by Bob Phillips, with
R1C1 unchecked, and store it in the XLStart directory?
--
Sincerely, Michael Colvinquot;khrystlequot; wrote:
gt;
gt; Thanks for responding, Bob.
gt;
gt; No, I have searched even hidden and system files and did not find any
gt; default book like you mention. Also I checked in the XLStart directory
gt; and it is totally empty.
gt;
gt; I'm really stumped here.
gt;
gt; Any other ideas? Is there somewhere in a .dll that this can be changed
gt; manually?
gt;
gt; Thanks!
gt;
gt; Khrystle.
gt;
gt;
gt; --
gt; khrystle
gt; ------------------------------------------------------------------------
gt; khrystle's Profile: www.excelforum.com/member.php...oamp;userid=32037
gt; View this thread: www.excelforum.com/showthread...hreadid=517843
gt;
gt;
Thank you, Michael!!!
That worked perfectly (after I installed it in all three XLStart
directories on the hard drive!).
Thank you so much!
Khrystle.--
khrystle
------------------------------------------------------------------------
khrystle's Profile: www.excelforum.com/member.php...oamp;userid=32037
View this thread: www.excelforum.com/showthread...hreadid=517843Your very welcome, Khrystle. Thanks for the feedback.
--
Sincerely, Michael Colvinquot;khrystlequot; wrote:
gt;
gt; Thank you, Michael!!!
gt;
gt; That worked perfectly (after I installed it in all three XLStart
gt; directories on the hard drive!).
gt;
gt; Thank you so much!
gt;
gt; Khrystle.
gt;
gt;
gt; --
gt; khrystle
gt; ------------------------------------------------------------------------
gt; khrystle's Profile: www.excelforum.com/member.php...oamp;userid=32037
gt; View this thread: www.excelforum.com/showthread...hreadid=517843
gt;
gt;
- Mar 09 Fri 2007 20:36
R1C1 Reference Style won't STAY gone?
close
全站熱搜
留言列表
發表留言