Protection problem

J

jazztpt

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
 
F

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
 
J

jazztpt

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


Frank Kabel said:
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
Click to expand...
Click to expand...
 
Top