Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Unprotect 2003 excel files when opening in Excel 2007

I opened an Excel file created in Excel 2003 version in Excel 2007 the cells
were protected and asking for a password to change, which I never locked with
a password. can some one guide me how to modify the sheet.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 143
Default Unprotect 2003 excel files when opening in Excel 2007

On the ribbon, go to Review and then Unprotect Sheet.

Here is a great resource for using commands from a 2003 template and the
corresponding 2007 template for Excel.
http://office.microsoft.com/en-us/he...491511033.aspx

--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Mayumdwl" wrote:

I opened an Excel file created in Excel 2003 version in Excel 2007 the cells
were protected and asking for a password to change, which I never locked with
a password. can some one guide me how to modify the sheet.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening Excel 2003 files with Excel 2007 CAnest Excel Discussion (Misc queries) 0 January 13th 09 08:16 PM
Opening 2007 Excel files in 2003 Jedi New Users to Excel 2 January 21st 08 12:06 AM
Issue opening 2003 excel files in Excel 2007 Lee Excel Discussion (Misc queries) 2 December 6th 07 10:28 PM
Excel 2003/2007 Crash when opening/closing files Richard NYC Excel Discussion (Misc queries) 1 October 18th 07 08:22 AM
Excel 2007, why is it slow opening files created in Excel 2003? Rick B Excel Discussion (Misc queries) 1 February 19th 07 02:21 AM


All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"