Prev: How can I insert rows BELOW, in Excel
Next: Excel error: "The path you entered, ---------- , is too long. "
From: Dave Peterson on 15 Apr 2010 07:39
I don't have a solution for you.

If you are the only one updating the values, then maybe you can unprotect the
sheet, update the values, and reprotect the sheet.

At least the data will be protected from other users.

Lise wrote:
>
> Hope this helps
>
> Two sheets involved - one is a chart the other data (which is the sorce data
> used in the chart)- If I lock the data sheet you can't update the chart
> source data (which you need to do as I need to change the months each month)
> the only way I have found this will work is by not locking the actual months
> required in the data sheet - but this leaves them open for editing which I
> don't want.
> --
> Thanks as always
>
> Lise
>
> "Dave Peterson" wrote:
>
> > I guess I don't understand enough.
> >
> > Why can't you lock that range?
> > What do you mean by source data and why can't those cells be locked?
> >
> >
> >
> > Lise wrote:
> > >
> > > Hi Dave
> > >
> > > The only way the source data works is if I unlock a specific range ie data
> > > in the row under Jan - Dec - the problem with this is that other users can
> > > then edit those cells which I don't want if possible? thoughts?
> > > --
> > > Thanks as always
> > >
> > > Lise
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > If you lock the cells and protect the worksheet, what happens when the user
> > > > tries to copy those cells?
> > > >
> > > > Lise wrote:
> > > > >
> > > > > Hi everyone
> > > > >
> > > > > I have a spreadsheet where I have locked cells and password protected.
> > > > > within this sheet though I have not locked a specific range of cells as they
> > > > > are used in another sheet as source data.
> > > > >
> > > > > Is there a way that I can allow these cells to still be copied for the
> > > > > source data but not actually changed by other users??
> > > > > --
> > > > > Thanks as always
> > > > >
> > > > > Lise
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > > .
> > > >
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson
First  |  Prev  | 
Pages: 1 2
Prev: How can I insert rows BELOW, in Excel
Next: Excel error: "The path you entered, ---------- , is too long. "