Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected document loses all protection(hidden columns) when manually copy-pasted
Hi everyone,
This is my problem i have this file which has a lot of info on it and obviously certain clients shouldn't see all the info in particular columns thus i have protected the spreadsheet and the workbook so that nobody can make changes to it, however i noticed recently that if I manually copy all of the content from existing spreadsheet and export it into a new spreadsheet voila! boom all my hidden info comes up here, keep in mind the option for unhide is greyed out too on the protected document. could someone tell me whether this is a software glitch or is there anything else perhaps i missed out on? Any help on this would be greatly appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected document loses all protection(hidden columns) when manually copy-pasted
It's not a bug as far as MS is concerned. Excel is just not secure and it
isn't intended to be. There are many ways someone can break into a 'protected' sheet. -- Jim wrote in message oups.com... | Hi everyone, | | This is my problem i have this file which has a lot of info on it and | obviously certain clients shouldn't see all the info in particular | columns thus i have protected the spreadsheet and the workbook so that | nobody can make changes to it, however i noticed recently that if I | manually copy all of the content from existing spreadsheet and export | it into a new spreadsheet voila! boom all my hidden info comes up here, | keep in mind the option for unhide is greyed out too on the protected | document. | | could someone tell me whether this is a software glitch or is there | anything else perhaps i missed out on? | | Any help on this would be greatly appreciated! | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Center document titles over several columns | Excel Discussion (Misc queries) | |||
Linking to a Password Protected Document in Excel 2000 | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Why can't a copy and paste columns? | Excel Worksheet Functions |