Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 66
Default 2007 vs 2003 - work protection

Good Friday Morning!
I have not seen this issue addressed -
I have a 2003 version excel workbook that is protected. There are no macros
in this document, although there is a sheet I want to remain hidden.
I have a user that can open the document and fill it out in their 2007
version. When they send it back as an attachment (.xlsx), and I try to open
it (I'm in 2003), it requests the password (for unprotecting the workbook).
It opens when I type in the password, although the workbook still shows
protected in Tools - Protection.

Is there any work-around to opening up the workbook WITHOUT having to know
and type in the password? I've seen some info a compatability download,
but I don't know if that will help the situation.

Any advice is appreciated (as always).
T
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default 2007 vs 2003 - work protection

Hi Theo

You could ask them to save the file as a .xls file by choosing the Office
ButtonSaveXl97-2003 Format

--
Regards
Roger Govier

"Theo" wrote in message
...
Good Friday Morning!
I have not seen this issue addressed -
I have a 2003 version excel workbook that is protected. There are no
macros
in this document, although there is a sheet I want to remain hidden.
I have a user that can open the document and fill it out in their 2007
version. When they send it back as an attachment (.xlsx), and I try to
open
it (I'm in 2003), it requests the password (for unprotecting the
workbook).
It opens when I type in the password, although the workbook still shows
protected in Tools - Protection.

Is there any work-around to opening up the workbook WITHOUT having to know
and type in the password? I've seen some info a compatability
download,
but I don't know if that will help the situation.

Any advice is appreciated (as always).
T


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
Excel 2007 pivot table formats that work with 2003 Steven Excel Discussion (Misc queries) 1 March 22nd 08 12:44 AM
Function dosn't work in Excel 2007 but did in 2003 Harding Excel Worksheet Functions 1 February 12th 08 04:05 PM
Make Excel 2007 work like 2003 jgcwustl New Users to Excel 1 January 28th 08 09:50 PM
Since updating Office 2003 to 2007 Excel formulas do not work? Pheasant Plucker® Excel Discussion (Misc queries) 2 January 26th 08 02:11 PM
I was using Excel 2007, now 2003 and my Macros won't work Jaynemoggy Excel Worksheet Functions 2 September 21st 07 11:14 PM


All times are GMT +1. The time now is 02:51 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"