| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File appears to be Readme only
I use Excel 2000. My boss just got me a new computer. I can still access my
Excel files since I was saving them to the network. Now however, I can open them but the auto sum and other functions do not work. Is there a way I can fix this so that I can make changes to the worksheets? -- Thanks! Cathy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File appears to be Readme only
It sounds more like the worksheet is protected.
Tools|Protection|Unprotect sheet may help. When a file is readonly, you can make as many changes as you want--including autosum, but you can't save the file using that name. (You can save as a different name, though.) Cathy wrote: I use Excel 2000. My boss just got me a new computer. I can still access my Excel files since I was saving them to the network. Now however, I can open them but the auto sum and other functions do not work. Is there a way I can fix this so that I can make changes to the worksheets? -- Thanks! Cathy -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File appears to be Readme only
Dave,
I don't think it is a protection issue because of the autosum feature not working. I researched it on Microsoft and it looks like it is some kind of shared workbook issue. Article ID 130560 lists several commands that are disabled in a shared workbook and those are the problems I am having. However I don't know how to "unshare" it. -- Thanks! Cathy "Dave Peterson" wrote: It sounds more like the worksheet is protected. Tools|Protection|Unprotect sheet may help. When a file is readonly, you can make as many changes as you want--including autosum, but you can't save the file using that name. (You can save as a different name, though.) Cathy wrote: I use Excel 2000. My boss just got me a new computer. I can still access my Excel files since I was saving them to the network. Now however, I can open them but the auto sum and other functions do not work. Is there a way I can fix this so that I can make changes to the worksheets? -- Thanks! Cathy -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File appears to be Readme only
Tools|Share workbook|Editing tab
Remove that checkmark. Cathy wrote: Dave, I don't think it is a protection issue because of the autosum feature not working. I researched it on Microsoft and it looks like it is some kind of shared workbook issue. Article ID 130560 lists several commands that are disabled in a shared workbook and those are the problems I am having. However I don't know how to "unshare" it. -- Thanks! Cathy "Dave Peterson" wrote: It sounds more like the worksheet is protected. Tools|Protection|Unprotect sheet may help. When a file is readonly, you can make as many changes as you want--including autosum, but you can't save the file using that name. (You can save as a different name, though.) Cathy wrote: I use Excel 2000. My boss just got me a new computer. I can still access my Excel files since I was saving them to the network. Now however, I can open them but the auto sum and other functions do not work. Is there a way I can fix this so that I can make changes to the worksheets? -- Thanks! Cathy -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to search a word in a excel file which appears twice | Excel Worksheet Functions | |||
| File A and File B Together | Excel Discussion (Misc queries) | |||
| disc full, saved to temp. file | Excel Discussion (Misc queries) | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| Links picking up values from an older version of linked file | Links and Linking in Excel | |||
Linear Mode
