Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Priya Repl
 
Posts: n/a
Default Excel and open office


I have made an excel file and protected sheets in it and even
hidden some of the worksheets with macros.

But when i open the xls file in Open Office (linux)

It shows all the worksheets and there is no protection.

I dont want to display the hidden sheets in any OS(or Package).

any work arounds?

Kindly help

  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Priya,
workaround: Don't use Open Office or pretend it doesn't exist.

Open Office is a different software program, it can read Excel files
but it is not Excel. It's great for recovery of Excel files. Possibly
features of exposing data while helpful in some areas are not helpful
to others.

If this is a security issue, you should be aware that there is not much
security in Excel. What there is is basically to help prevent you from
accidentally destroying parts of your file. Security was not builtin to
Personal Computing from day one. PCs were not connected to
networks, you turned off your machine and went home.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Priya Repl" <Priya wrote in message ...

I have made an excel file and protected sheets in it and even
hidden some of the worksheets with macros.

But when i open the xls file in Open Office (linux)

It shows all the worksheets and there is no protection.

I dont want to display the hidden sheets in any OS(or Package).

any work arounds?

Kindly help



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
Pretty simple question Alex Excel Discussion (Misc queries) 5 August 30th 06 02:13 PM
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? nwtrader8 Excel Discussion (Misc queries) 5 June 21st 05 02:16 PM
Why can I not open an Excel Compound file with Office Excel xp? Wetcoast40 Excel Discussion (Misc queries) 1 February 4th 05 10:42 PM
Open Office file to EXCEL BOULEY New Users to Excel 1 December 26th 04 10:42 PM
How do I open Excel 4.0 files in Office 2000? Tom_Hunn Excel Discussion (Misc queries) 1 November 29th 04 11:49 AM


All times are GMT +1. The time now is 02:19 PM.

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"