Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
R1C1 - how can I permanently undo this setting in Excel?
Despite changing the setting under Options/General where I uncheck the box
"R1C1" every time I open Excel, it does not seem to store my setting permanently. How can I permanently undo this setting so that I work in "A1" mode? Thankx Sheila |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
R1C1 - how can I permanently undo this setting in Excel?
Excel picks up this setting from the first workbook you open in that session.
If you're unlucky enough that your first workbook opened is in R1C1 reference style, you'll have to make the change. Do you save the workbook after you make the change to A1 reference style? Do you have a coworker who likes R1C1 and saves it that way? (Could mean a fight!) Sheila wrote: Despite changing the setting under Options/General where I uncheck the box "R1C1" every time I open Excel, it does not seem to store my setting permanently. How can I permanently undo this setting so that I work in "A1" mode? Thankx Sheila -- Dave Peterson |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
R1C1 - how can I permanently undo this setting in Excel?
Could it be that you have the workbook template setup in R1C1, it is
Book.xlt in the XLStart directory. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dave Peterson" wrote in message ... Excel picks up this setting from the first workbook you open in that session. If you're unlucky enough that your first workbook opened is in R1C1 reference style, you'll have to make the change. Do you save the workbook after you make the change to A1 reference style? Do you have a coworker who likes R1C1 and saves it that way? (Could mean a fight!) Sheila wrote: Despite changing the setting under Options/General where I uncheck the box "R1C1" every time I open Excel, it does not seem to store my setting permanently. How can I permanently undo this setting so that I work in "A1" mode? Thankx Sheila -- Dave Peterson |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
R1C1 - how can I permanently undo this setting in Excel?
Hi Dave
Thankx for the reply but I'm still battling. I had this problem on Office 2003 and after completely un-installing that version and then doing a brand new install of Office 2007 beta release 2, I have the same problem. This kinda tells me that this setting is held in some kind of profile file or such like 'cos like I say I completely un-installed Office 2003. I am the only user of these worksheets as I'm saving them on my own laptop. If I just launch Excel and do nothing else other than change that setting and then close out of Excel I stil have the problem when I come back in. I appreciate your suggestions. Thankx Sheila "Dave Peterson" wrote: Excel picks up this setting from the first workbook you open in that session. If you're unlucky enough that your first workbook opened is in R1C1 reference style, you'll have to make the change. Do you save the workbook after you make the change to A1 reference style? Do you have a coworker who likes R1C1 and saves it that way? (Could mean a fight!) Sheila wrote: Despite changing the setting under Options/General where I uncheck the box "R1C1" every time I open Excel, it does not seem to store my setting permanently. How can I permanently undo this setting so that I work in "A1" mode? Thankx Sheila -- Dave Peterson |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
R1C1 - how can I permanently undo this setting in Excel?
HI Sheila,
Do look at Bob's suggestion -- Kind regards, Niek Otten Microsoft MVP - Excel "Sheila" wrote in message ... | Hi Dave | | Thankx for the reply but I'm still battling. I had this problem on Office | 2003 and after completely un-installing that version and then doing a brand | new install of Office 2007 beta release 2, I have the same problem. This | kinda tells me that this setting is held in some kind of profile file or such | like 'cos like I say I completely un-installed Office 2003. | | I am the only user of these worksheets as I'm saving them on my own laptop. | If I just launch Excel and do nothing else other than change that setting | and then close out of Excel I stil have the problem when I come back in. | | I appreciate your suggestions. | Thankx | Sheila | | | | "Dave Peterson" wrote: | | Excel picks up this setting from the first workbook you open in that session. | If you're unlucky enough that your first workbook opened is in R1C1 reference | style, you'll have to make the change. | | Do you save the workbook after you make the change to A1 reference style? | | Do you have a coworker who likes R1C1 and saves it that way? (Could mean a | fight!) | | Sheila wrote: | | Despite changing the setting under Options/General where I uncheck the box | "R1C1" every time I open Excel, it does not seem to store my setting | permanently. How can I permanently undo this setting so that I work in "A1" | mode? | | Thankx | Sheila | | | -- | | Dave Peterson | |
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
R1C1 - how can I permanently undo this setting in Excel?
Hi Bob
Thankx for your suggestion. I found a file called "personal.xls" in that folder (not book.xlt) and I opened it and then made the change and saved it and my problem is solved!!!! You pointed me in the right direction and I thank you for that. Cheers Sheila "Bob Phillips" wrote: Could it be that you have the workbook template setup in R1C1, it is Book.xlt in the XLStart directory. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dave Peterson" wrote in message ... Excel picks up this setting from the first workbook you open in that session. If you're unlucky enough that your first workbook opened is in R1C1 reference style, you'll have to make the change. Do you save the workbook after you make the change to A1 reference style? Do you have a coworker who likes R1C1 and saves it that way? (Could mean a fight!) Sheila wrote: Despite changing the setting under Options/General where I uncheck the box "R1C1" every time I open Excel, it does not seem to store my setting permanently. How can I permanently undo this setting so that I work in "A1" mode? Thankx Sheila -- Dave Peterson |
#7
Posted to microsoft.public.excel.setup
|
|||
|
|||
R1C1 - how can I permanently undo this setting in Excel?
Of course, I should have thought about Personal.xls as well.
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Sheila" wrote in message ... Hi Bob Thankx for your suggestion. I found a file called "personal.xls" in that folder (not book.xlt) and I opened it and then made the change and saved it and my problem is solved!!!! You pointed me in the right direction and I thank you for that. Cheers Sheila "Bob Phillips" wrote: Could it be that you have the workbook template setup in R1C1, it is Book.xlt in the XLStart directory. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dave Peterson" wrote in message ... Excel picks up this setting from the first workbook you open in that session. If you're unlucky enough that your first workbook opened is in R1C1 reference style, you'll have to make the change. Do you save the workbook after you make the change to A1 reference style? Do you have a coworker who likes R1C1 and saves it that way? (Could mean a fight!) Sheila wrote: Despite changing the setting under Options/General where I uncheck the box "R1C1" every time I open Excel, it does not seem to store my setting permanently. How can I permanently undo this setting so that I work in "A1" mode? Thankx Sheila -- Dave Peterson |
#8
Posted to microsoft.public.excel.setup
|
|||
|
|||
R1C1 - how can I permanently undo this setting in Excel?
This relates to an issue I'm trying to figure out. In my case I have no
listing in the XLstart directory. Any idea why? Any other suggestions? "Bob Phillips" wrote: Could it be that you have the workbook template setup in R1C1, it is Book.xlt in the XLStart directory. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dave Peterson" wrote in message ... Excel picks up this setting from the first workbook you open in that session. If you're unlucky enough that your first workbook opened is in R1C1 reference style, you'll have to make the change. Do you save the workbook after you make the change to A1 reference style? Do you have a coworker who likes R1C1 and saves it that way? (Could mean a fight!) Sheila wrote: Despite changing the setting under Options/General where I uncheck the box "R1C1" every time I open Excel, it does not seem to store my setting permanently. How can I permanently undo this setting so that I work in "A1" mode? Thankx Sheila -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro security | Setting up and Configuration of Excel | |||
Why can't I undo forever in Excel like in Word? | Excel Discussion (Misc queries) | |||
Excel 2003 Undo greys out after few minutes - Not saving | Excel Discussion (Misc queries) | |||
Permanently visible colunm in an Excel chart | Excel Discussion (Misc queries) | |||
How can I increas undo level in Microsoft EXCEL ? | Excel Discussion (Misc queries) |