Getting Excel 2000 Options to be remembered

  • Thread starter Thread starter Mervyn Thomas
  • Start date Start date
M

Mervyn Thomas

Two questions really:
1. How do I get options for a particular workbook to be saved? I am findng
that the option to have R1C1 Reference style to be ticked does not get saved
with the workbook but other options do.
2. How can I get options to be either global for all workbooks or for a
range of workbooks?

Thanks
Mervyn
 
Mervyn


Unfortunately, R1C1 style is one of those options that is set by the first
workbook that is opened in a session. Calculation Mode is another.

You could set the R1C1 style in your Personal.xls which will open hidden with
each session of Excel, thus ensuring that the style is set.

Gord Dibben Excel MVP
 
Thanks - Another undocumented feature?
Mervyn
Gord Dibben said:
Mervyn


Unfortunately, R1C1 style is one of those options that is set by the first
workbook that is opened in a session. Calculation Mode is another.

You could set the R1C1 style in your Personal.xls which will open hidden with
each session of Excel, thus ensuring that the style is set.

Gord Dibben Excel MVP
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
How to create absolue path link to another workbook (Excel 2003) 1
Formula Audit mode active in one column only; cannot kill. 2
R1C1 reference 1
Error message when attempting to set up an Excel workspace 19
Excel 2007- can't get it to automatically make backups 1
Excel workbook will not save 2
Removing digital signature 1

Back
Top