Modifying UnProtected Cells

I have a user who Is using Excel XP. SHe has created a workbook with Some 
Protected cells. She emails to another user who is using Excel 2000 - this 
user is unable to modify any cells. The error states that the cells are all 
protected.
A user that has Excel XP or 2003 is able to modify the unprotected cells.

I have installed all the updates to Office 2000 - any other suggestions?

THanks in advance!
0
Gladys (25)
7/26/2005 8:27:02 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
338 Views

Similar Articles

[PageSpeed] 26

Gladys: Likely the cells aren't being protected/unprotected properly. Cells
are protected by default. Check this:
http://www.officearticles.com/excel/cell_locking_in_microsoft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com


"Gladys" <Gladys@discussions.microsoft.com> wrote in message
news:696813D3-FAAF-4524-9EB9-0A2EBA573DEA@microsoft.com...
> I have a user who Is using Excel XP. SHe has created a workbook with Some
> Protected cells. She emails to another user who is using Excel 2000 - this
> user is unable to modify any cells. The error states that the cells are
all
> protected.
> A user that has Excel XP or 2003 is able to modify the unprotected cells.
>
> I have installed all the updates to Office 2000 - any other suggestions?
>
> THanks in advance!


0
ng1 (1444)
7/26/2005 8:49:53 PM
In Excel 2002 and later versions, you can apply different options when 
you turn on protection. For example, you can allow users to format 
cells, and use AutoFilters.

Users with these versions will be able to change the contents of 
unprotected cells, and modify the formatting, etc., if allowed in the 
protection settings.

Users with Excel 2000 and earlier should be able to edit the data in a 
cell, but won't be able to access the other features.

Gladys wrote:
> I have a user who Is using Excel XP. SHe has created a workbook with Some 
> Protected cells. She emails to another user who is using Excel 2000 - this 
> user is unable to modify any cells. The error states that the cells are all 
> protected.
> A user that has Excel XP or 2003 is able to modify the unprotected cells.
> 
> I have installed all the updates to Office 2000 - any other suggestions?
> 
> THanks in advance!


-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

0
dsd1 (5911)
7/26/2005 9:33:02 PM
Thanks for your responses.

The XP user was using the options - allow users to edit ranges - which of 
course is not an option in 2000.  

After We Protected the "old fashion" way the 2000 user was able to edit the 
cells that were not protected.

"Anne Troy" wrote:

> Gladys: Likely the cells aren't being protected/unprotected properly. Cells
> are protected by default. Check this:
> http://www.officearticles.com/excel/cell_locking_in_microsoft_excel.htm
> 
> *******************
> ~Anne Troy
> 
> www.OfficeArticles.com
> 
> 
> "Gladys" <Gladys@discussions.microsoft.com> wrote in message
> news:696813D3-FAAF-4524-9EB9-0A2EBA573DEA@microsoft.com...
> > I have a user who Is using Excel XP. SHe has created a workbook with Some
> > Protected cells. She emails to another user who is using Excel 2000 - this
> > user is unable to modify any cells. The error states that the cells are
> all
> > protected.
> > A user that has Excel XP or 2003 is able to modify the unprotected cells.
> >
> > I have installed all the updates to Office 2000 - any other suggestions?
> >
> > THanks in advance!
> 
> 
> 
0
Gladys (25)
7/27/2005 1:39:17 PM
Reply:

Similar Artilces: