Sounds like a good workaround. Thanks for the tip.
--
Thanks,
PJ


"Jim Thomlinson" wrote:

There is no way to lock the position of a sheet that I know of. Generally
when I want to use a formula such as that I will create 2 blank worksheets.
One called Start and one called end. I place them at either end of my source
sheets. I then use formulas like

=SUM('Start:End'!C3)

Not fool proof but it helps keep end users from moving the end sheets...
--
HTH...

Jim Thomlinson


"PJ" wrote:

Is there a way to lock the location of a sheet within a spreadsheet? I have
a spreadsheet that has a sheet for each employee. Then I have a Total sheet
that totals across all the sheets. For example, the Total sheet adds cell C3
on Sheet 1 plus C3 on Sheet 2 plus C3 on Sheet 3, etc. I want to lock Sheet
1 so it can't be moved because the formula will not work if the sheets are
rearranged. See formula below.

=SUM('Sheet1:Sheet10'!C3)

--
Thanks,
PJ