R1C1 Style Reference

  • Thread starter Thread starter Jasper Recto
  • Start date Start date
J

Jasper Recto

Is there a way to prevent the R1C1 Style Reference from activating?

I have some users that use that format and when I open up their document, it
changes my settings to that format.

I don't want that format to change. Is there a way to prevent this?

Thanks,
Jasper
 
Excel picks this setting up from the first workbook you open in that session.

So if you always open one of your workbooks first (in A1 reference style), then
open the other workbook(s), you should be ok.

Maybe you could create a "master" workbook that includes a bunch of hyperlinks
to commonly used files.

Then always open your workbook first. Then open (via the hyperlink???) the
other workbooks.
 
Back
Top