Where does Excel 2000 save the Referenece Style user setting?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chuck McLemore - 24 Jul 2003 22:15 GMT

When the user opens Excel, the blank sheet opens in the
R1C1 Reference Style instead of the normal A1, B1, C1
style. When she tries to select TOOLS -> OPTIONS, nothing
happens. She can see it and select it from the menu list
fine, but the OPTIONS window just never opens. Under what
file does Excel save the Reference Style settings? It
doesn't appear to be the excel.xlb file. Or does someone
know what can be done to resolve the OPTIONS window not
coming up? If it would open properly, the user could
unmark the R1C1 Reference Style box and correct the
problem that way. Thanks, Chuck

Reply to this Message

David McRitchie - 25 Jul 2003 01:14 GMT

Hi Chuck,
I think in your personal.xls workbook or some other workbook
that might be the first workbook opened when you open Excel.
Use the Excel Window menu item to unhide the workbook.

The only time I don't see the tools --> Options is when I
haven't yet opened a workbook that I can see (not hidden).
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> When the user opens Excel, the blank sheet opens in the
> R1C1 Reference Style instead of the normal A1, B1, C1
[quoted text clipped - 7 lines]
> unmark the R1C1 Reference Style box and correct the
> problem that way. Thanks, Chuck

Reply to this Message

Rate this thread: