Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 Reference Style won't STAY gone?
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: http://www.excelforum.com/member.php...o&userid=32037 View this thread: http://www.excelforum.com/showthread...hreadid=517843 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 Reference Style won't STAY gone?
Do 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) "khrystle" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=32037 View this thread: http://www.excelforum.com/showthread...hreadid=517843 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 Reference Style won't STAY gone?
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: http://www.excelforum.com/member.php...o&userid=32037 View this thread: http://www.excelforum.com/showthread...hreadid=517843 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 Reference Style won't STAY gone?
khrystle, why not create your own book.xlt, mentioned by Bob Phillips, with
R1C1 unchecked, and store it in the XLStart directory? -- Sincerely, Michael Colvin "khrystle" wrote: 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: http://www.excelforum.com/member.php...o&userid=32037 View this thread: http://www.excelforum.com/showthread...hreadid=517843 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 Reference Style won't STAY gone?
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: http://www.excelforum.com/member.php...o&userid=32037 View this thread: http://www.excelforum.com/showthread...hreadid=517843 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 Reference Style won't STAY gone?
Your very welcome, Khrystle. Thanks for the feedback.
-- Sincerely, Michael Colvin "khrystle" wrote: 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: http://www.excelforum.com/member.php...o&userid=32037 View this thread: http://www.excelforum.com/showthread...hreadid=517843 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I switched on the R1C1 reference style but I can't switch it off a | Excel Discussion (Misc queries) | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
Change GETPIVOTDATA cell reference to A1 style | Excel Worksheet Functions | |||
R1C1 reference | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |