informationThere are some rules about Excel cell names that must be observed:

1.Names cannot have spaces in them.

2.Names cannot be the same as a cell reference. For example, you could not use 'Q1' as a name for a cell which contains the sales for your first quarter, because Q1 is a valid cell reference. You could however, name the range 'Q1Sales' or 'Q1_sales'.

3.Names cannot begin with "c" plus and number or "r" plus any number. Excel treat this as a cell or row reference no matter what follows. So "C1Sales" and "R5QuarterlyResults" are not valid names. "_C1Sales" and "R_5QuarterlyResults" will, however, work.

4.Names cannot begin with a number.

5.Names cannot include any special characters (, @, #, $, %, &, *, [, ], {, }, /, etc). The underscore character is allowed. 'ClientName' and 'Client_Name' are OK. 'Client Name' and 'Client-Name' are not.

6.If you try to name a cell something that Excel will not accept, you might get an error message, but just as often, you will not..

redarrowNote: Excel will not accept a cell name containing brackets, the preferred marker for Pathagoras variables.  Even if you are using brackets for your IDB (a preferred practice), name the cell without brackets. When you export the record, Pathagoras will ask if you want to enclose the variable names with brackets. If you say 'Yes', then brackets will be added, thereby making them fully compatible with Pathagoras-Word.

redarrowNote: Excel will not accept a cell name containing a slash,  the character used for separating Pathagoras multiple choice variables.   Therefore, multiple choice variables cannot be used as the name for a cell. But, as discussed below, to the extent that you handle multiple choices using Excel tools, you won't need multiple choice or MultiChoice variables in Word anymore.

 

 

Created with Help & Manual 7 and styled with Premium Pack Version 2.70 © by EC Software