I have a standard template workbook which has a summary sheet and a
number of linked subsheets. For some reason I can't use the cursor to
create a formula to references cells in the summary to the subsheets.
For example if I start a formula in the subsheet and move the cursor to
the summary sheet, it gives the sheet reference but won't permit a cell
slection in the summary sheet. None of the sheets have protection so
that doesn't seem to be the issue...