2007 vs 2003 - work protection

T

Theo

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 re: a compatability download,
but I don't know if that will help the situation.

Any advice is appreciated (as always).
T
 
R

Roger Govier

Hi Theo

You could ask them to save the file as a .xls file by choosing the Office
Button>Save>Xl97-2003 Format
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unreadable text when viewing organization chart in Web version of Visio 365 0
Asking for password problem 0
Excel 2007 says a workbook is corrupted when it isn't 4
Remove protection from 2003 Excel 1
Remove 2003 Password in 2007 1
How do you remove the workbook/document password in EXCEL 2007 6
Unprotecting what Excel says is unprotected ??? 2
How secure is Excel 2007 worksheet protection? 1

Top