If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell Reference Issue
One of our users opens excel up and for some reason the R1C1 Reference Style
is ticked, which shows the numbers across the top of the sheet. The user can take this off by going into. Tools - Options - General and removing the tick. However when the user closes excel and goes back into it, it defaults back to the numbers across the top. I log in as admin and as myself and this does not happen. when i log in as these users it is set to the default of letters across the top. Any help appreciated. Thanks Craig |
#2
|
|||
|
|||
Cell Reference Issue
The user doesn't have rights to his *.xlb file.
************ Anne Troy www.OfficeArticles.com "CraigM" wrote in message ... One of our users opens excel up and for some reason the R1C1 Reference Style is ticked, which shows the numbers across the top of the sheet. The user can take this off by going into. Tools - Options - General and removing the tick. However when the user closes excel and goes back into it, it defaults back to the numbers across the top. I log in as admin and as myself and this does not happen. when i log in as these users it is set to the default of letters across the top. Any help appreciated. Thanks Craig |
#3
|
|||
|
|||
Cell Reference Issue
Where can i find this file. I have searched my machine and i cannot find it.
Regards Craig "Anne Troy" wrote: The user doesn't have rights to his *.xlb file. ************ Anne Troy www.OfficeArticles.com "CraigM" wrote in message ... One of our users opens excel up and for some reason the R1C1 Reference Style is ticked, which shows the numbers across the top of the sheet. The user can take this off by going into. Tools - Options - General and removing the tick. However when the user closes excel and goes back into it, it defaults back to the numbers across the top. I log in as admin and as myself and this does not happen. when i log in as these users it is set to the default of letters across the top. Any help appreciated. Thanks Craig |
#4
|
|||
|
|||
Cell Reference Issue
Hi, Craig. You must be searching (an option in the search) AND viewing (an
option in Windows) hidden/system files. ************ Anne Troy VBA Project Manager www.OfficeArticles.com "CraigM" wrote in message ... Where can i find this file. I have searched my machine and i cannot find it. Regards Craig "Anne Troy" wrote: The user doesn't have rights to his *.xlb file. ************ Anne Troy www.OfficeArticles.com "CraigM" wrote in message ... One of our users opens excel up and for some reason the R1C1 Reference Style is ticked, which shows the numbers across the top of the sheet. The user can take this off by going into. Tools - Options - General and removing the tick. However when the user closes excel and goes back into it, it defaults back to the numbers across the top. I log in as admin and as myself and this does not happen. when i log in as these users it is set to the default of letters across the top. Any help appreciated. Thanks Craig |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Getting contents of a cell when cell reference is in the sheet | A Nelson | General Discussion | 3 | October 5th, 2005 06:46 PM |
how do I format a cell reference to move as source changes | KGray | Worksheet Functions | 1 | August 13th, 2005 12:41 AM |
Reference Cell in Named Range | mark1 | General Discussion | 1 | September 7th, 2004 01:15 AM |
Cut and paste without altering cell reference | ski-rdu | Worksheet Functions | 2 | June 16th, 2004 12:18 PM |
Convert a Cell Reference to Text | Chuck Buker | Worksheet Functions | 6 | September 22nd, 2003 05:04 PM |