OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Excel Spreadsheet is Protected.....HELP!!

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
insaneo
Newbie
Newbie


Joined: 22 Jun 2004
Posts: 2

PostPosted: Tue Jun 22, 2004 6:37 am    Post subject: Excel Spreadsheet is Protected.....HELP!! Reply with quote

Is there a way to open an Excel spreadsheet that is protected.....the entire document is protected. I looked online for assistance but couldn't find anything. Any help would be appreciated.
Back to top
View user's profile Send private message
The Liquidator
Super User
Super User


Joined: 27 Feb 2003
Posts: 1368
Location: Manchester, UK

PostPosted: Tue Jun 22, 2004 8:08 am    Post subject: Reply with quote

Hi

OOo cannot recognise Excel passwords. You won't be able to open a password protected document within OOo.

You could try opening with an Excel viewer, available free from www.microsoft.com, highlighting the whole sheet and then copying and pasting the lot into an OOo spreadsheet. You may encounter problems though if there are any fancy Excel Functions in there.

Try it and let us know.

Ian
Back to top
View user's profile Send private message
Guest






PostPosted: Tue Jun 22, 2004 4:59 pm    Post subject: Reply with quote

I was able to open password protected excel files with 1.1.1.
I think ms abandoned the password protection in versions greater than 97, as excel 2000 didn't have password protection.
Back to top
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Tue Jun 22, 2004 7:26 pm    Post subject: Reply with quote

Anonymous wrote:
... as excel 2000 didn't have password protection.


Sure it does; both sheet and/or workbook protection [and cells of course.]

David.
Back to top
View user's profile Send private message
insaneo
Newbie
Newbie


Joined: 22 Jun 2004
Posts: 2

PostPosted: Wed Jun 23, 2004 4:25 am    Post subject: Excel - OO Thingy Reply with quote

Well....our users are using Excel 97....or they were.....until we migrated the company to Open Office (a total of 150 users). This is one of the bigger issues because the HR Department is now unable to open these files that were password protected. Is there any plans in future to provide this importable feature into OO? I know OO can protect; however, I need it to view protected Excel files....if it can't be done....I'll come up with something else.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group