Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In Excel 2000, Cannot edit cells in worksheet created in 2003?
We have a spreadsheet that only the needed cells to edit are
unlocked/unprotected. However, on a pc using Excel 2000 all of the cells appear to be locked. Please help! Is this a capability issue? |
#2
|
|||
|
|||
hi,
check this... can you edit the cell in the formula bar. if so .... tooloptionsedit tabcheck "edit directly in cell" that is all i can think of that might be wrong. regards FSt1 "hbca4" wrote: We have a spreadsheet that only the needed cells to edit are unlocked/unprotected. However, on a pc using Excel 2000 all of the cells appear to be locked. Please help! Is this a capability issue? |
#3
|
|||
|
|||
No this does not work... Options is NOT available on the spreadsheet.
Certain areas of the worksheet are protected while others are not. Only the cells needing data changed is available for editing. I can open and edit the spreadsheet just fine, while my co-worker cannot. It appears to be an issue with the worksheet being created in Excel 2003. Since I am running Excel 2003 as well I can edit the available cells with no problem. But the user with Excel 2000 cannot. I was hoping there may be an option or something preventing her from editing it. If anyone else has a clue, please help! "FSt1" wrote: hi, check this... can you edit the cell in the formula bar. if so .... tooloptionsedit tabcheck "edit directly in cell" that is all i can think of that might be wrong. regards FSt1 "hbca4" wrote: We have a spreadsheet that only the needed cells to edit are unlocked/unprotected. However, on a pc using Excel 2000 all of the cells appear to be locked. Please help! Is this a capability issue? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I protect cells in Excel 2000? | Excel Worksheet Functions | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
other systems detecting excel 4.0 if excel 2000 is installed | Setting up and Configuration of Excel | |||
IN EXCEL 2000, HOW DO I PROTECT MULTIPLE WORKSHEET | Excel Worksheet Functions | |||
Is there a way to make Excel 2000 open a new worksheet in a new w. | Excel Discussion (Misc queries) |