Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Gladys: Likely the cells aren't being protected/unprotected properly. Cells
are protected by default. Check this: http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com "Gladys" wrote in message ... 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! |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com "Gladys" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |