Protection problem

[Guest]

Hope someone can help. I have a shared workbook with a summary sheet which
consolidates all other sheets. I set this up and it all worked nicely.However
I am now getting an error when trying to consolidate data.
[The cell or chart you are trying to change is protected and therefor read
only]. When I go to unprotect the sheet the option to 'unprotect sheet' is
greyed out. The other worksheets have the option to 'protect sheet' greyed
out. Anyone have any ideas why this is. I could rebuild the summary sheet, no
big job but it is frustrating.
Thanks
Russ

 

[Frank Kabel]

Hi
changing the protection is not possible with shared workbooks (see
Excel's help for the restriction of shared workbooks).
So you first have to 'unshare' the file

 

[Guest]

Many thanks Frank for the quick reply, much appreciated.
Russ

Hi
changing the protection is not possible with shared workbooks (see
Excel's help for the restriction of shared workbooks).
So you first have to 'unshare' the file

--
Regards
Frank Kabel
Frankfurt, Germany

Hope someone can help. I have a shared workbook with a summary sheet
which consolidates all other sheets. I set this up and it all worked
nicely.However I am now getting an error when trying to consolidate
data. [The cell or chart you are trying to change is protected and
therefor read only]. When I go to unprotect the sheet the option to
'unprotect sheet' is greyed out. The other worksheets have the option
to 'protect sheet' greyed out. Anyone have any ideas why this is. I
could rebuild the summary sheet, no big job but it is frustrating.
Thanks
Russ