Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert "read only" to a working sheet?
fOR SOME REASON MY WORKSHEETS BECAME "READ ONLY". I NEED TO GET BACK TO THE
POINT WHERE i CAN PERFORM ALL THE EXCEL FUNCTIONS WITHIN THE WORKSHEETS THAT I UPDATE WEEKLY. i AM USING EXCEL 2007. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert "read only" to a working sheet?
HOWARDJASONRUBINOFSKY
wrote... fOR SOME REASON MY WORKSHEETS BECAME "READ ONLY". *I NEED TO GET BACK TO THE POINT WHERE i CAN PERFORM ALL THE EXCEL FUNCTIONS WITHIN THE WORKSHEETS THAT I UPDATE WEEKLY. i AM USING EXCEL 2007. Turn off caps lock. All caps is considered shouting. Do you mean your workBOOK was opened read-only, with [Read-Only] appearing in either the Excel application window's caption or the workbook's document window caption if document windows aren't maximized? Or do you mean some worksheets in the open workbook are protected so that you can't enter/revise cell contents, run spell check, etc? If the former (workbook opened read-only), save it using a different filename, close it, then check whether the original file is marked read-only in Windows Explorer. If the original file is read-only, then you have an OS problem. If the latter, you need to unprotect the worksheet(s), which in Excel 2007 is done using the thoroughly unintuitive Home tab, Cells section, Format drop-down menu, Unprotect Sheet... menu command. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert "read only" to a working sheet?
Perhaps it's connected with that broken caps lock key which is making you
SHOUT at us? :-( -- David Biddulph HOWARDJASONRUBINOFSKY wrote: fOR SOME REASON MY WORKSHEETS BECAME "READ ONLY". I NEED TO GET BACK TO THE POINT WHERE i CAN PERFORM ALL THE EXCEL FUNCTIONS WITHIN THE WORKSHEETS THAT I UPDATE WEEKLY. i AM USING EXCEL 2007. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"working" filters on protected sheet | Excel Discussion (Misc queries) | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
Solution "Your changes could not be saved" "The document may be read-only or encrypted" | Excel Discussion (Misc queries) | |||
convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions |