Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to Unprotect a 2003 .xls file
My company recently upgraded to 2007. I had a file that was protected and
only certain cells could be modified, for data entry. I now need to manipulate the file but I am unable to unprotect the file. The €śunprotect sheet€ť button is not available. How do I unlock the protection? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to Unprotect a 2003 .xls file
Press Alt+T+P+P.
Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "r25ramirez" wrote: My company recently upgraded to 2007. I had a file that was protected and only certain cells could be modified, for data entry. I now need to manipulate the file but I am unable to unprotect the file. The €śunprotect sheet€ť button is not available. How do I unlock the protection? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to Unprotect a 2003 .xls file
If the file is shared you need to unshare it first as that option is not
available in shared workbooks... -- HTH... Jim Thomlinson "r25ramirez" wrote: My company recently upgraded to 2007. I had a file that was protected and only certain cells could be modified, for data entry. I now need to manipulate the file but I am unable to unprotect the file. The €śunprotect sheet€ť button is not available. How do I unlock the protection? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to Unprotect a 2003 .xls file
Nope. nothing happend. A window popped up at the top of the screen looking
like it was accepting the code, but nothing happend. Thanks for the help though. "Ms-Exl-Learner" wrote: Press Alt+T+P+P. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "r25ramirez" wrote: My company recently upgraded to 2007. I had a file that was protected and only certain cells could be modified, for data entry. I now need to manipulate the file but I am unable to unprotect the file. The €śunprotect sheet€ť button is not available. How do I unlock the protection? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to Unprotect a 2003 .xls file
That's what it was! thank you so much! I was freaking out thinking I had to
create this file over again from scratch! Thanks again! "Jim Thomlinson" wrote: If the file is shared you need to unshare it first as that option is not available in shared workbooks... -- HTH... Jim Thomlinson "r25ramirez" wrote: My company recently upgraded to 2007. I had a file that was protected and only certain cells could be modified, for data entry. I now need to manipulate the file but I am unable to unprotect the file. The €śunprotect sheet€ť button is not available. How do I unlock the protection? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to unprotect an Excel Worksheet | Excel Discussion (Misc queries) | |||
unable to paste Excel 2003 chart into Outlook 2003 | Charts and Charting in Excel | |||
Pie chart built in 2000, now in 2003 but unable to edit 2003-way | Excel Discussion (Misc queries) | |||
unable to unprotect my protected excel file | Excel Discussion (Misc queries) | |||
Unable to unprotect a protected excel file | Excel Discussion (Misc queries) |