Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 pivot table formats that work with 2003 | Excel Discussion (Misc queries) | |||
Function dosn't work in Excel 2007 but did in 2003 | Excel Worksheet Functions | |||
Make Excel 2007 work like 2003 | New Users to Excel | |||
Since updating Office 2003 to 2007 Excel formulas do not work? | Excel Discussion (Misc queries) | |||
I was using Excel 2007, now 2003 and my Macros won't work | Excel Worksheet Functions |