Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell reference problem | Excel Worksheet Functions | |||
how to include a cell reference that is contained in a cell withi. | Excel Worksheet Functions | |||
How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Flexible Cell Reference | Excel Discussion (Misc queries) |