Ask Your Question

Calc: Named ranges-Hyperlinks in one sheet-C and R not working

asked 2017-12-04 11:15:49 +0200

I produced an alphabetised list similar to a contents list at the back of a book and added a hyperlinked alphabet as a heading linked to each of the section headings for easy navigation.

I did this using named ranges and linking the quick find letter, with the corresponding section heading letter and named range, using the single sheet option.

This was no problem including having a return to top hyperlink for 24 from the 26 letters. I cannot get C and R to work. I can produce the hyperlinked quick find letter but cannot create a named range "C" or "R". Having carried out the process successfully I do not tink I am the issue and the hyperlink is setup ready the link to the range but the problem remains with the use of C and R as names for the ranges.

When naming the ranges a blue line appears at the top stating that it is an invalid name and only letters numbers or underscore are accepted. I checked for spaces none present and changed the font to a more basic one but the problem remains.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-12-04 11:46:36 +0200

C and R are reserved words, because they are used in R1C1 notation.

edit flag offensive delete link more


Thank you Mike, I thought I was going mad.

zebraman gravatar imagezebraman ( 2017-12-05 15:52:57 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-12-04 11:15:49 +0200

Seen: 31 times

Last updated: Dec 04 '17