 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Securing a worksheet vs. HTTP
Suppose a worksheet is secured (user may not edit cells, select cells, format cells, etc.). If the file is served via http, it seems as if these security settings are not regarded. Is this correct, or do I make some error. Michael G. Schneider Sun, 23 Sep 2007 18:41:05 +0200 from Michael G. Schneider <mgs@newsgroups.nospam>: > Suppose a worksheet is secured (user may not edit cells, select cells, > format cells, etc.). If the file is served via http, it seems as if these > security settings are not regarded. Is this correct, or do I make some > error. Serving it via HTTP should not be a problem. When you say "secured", do you mean via Tools | Protection | Protect Sheet? I have a couple of workbooks that are served that way, and the protection seems to work just fine. See http://www.tc3.edu/instruct/sbrown/stat50/grades.xls for instance. So I think you may have made a mistake, but I don't know what it is. I know this is *really* elementary, but are you sure you saved the workbook after protecting it, AND closed Excel, before uploading the workbook to your server?  SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ > Serving it via HTTP should not be a problem. When you say "secured", > do you mean via Tools | Protection | Protect Sheet? I have a couple > of workbooks that are served that way, and the protection seems to > work just fine. See Hello Stan, thanks a lot for your answer. You are absolutely correct. After reading your post, I did some more tests and found out the mistake. It had something to do with the Internet Explorer settings. The setting "search for new versions of a file" was set to "automatically". This did not work reliably. So when I was playing with the XLS file, saving it on the server (also in the LAN), then opening it via http, sometimes an old version of the file was served. So I saved a secured version of the file, but the older un-secured version of the file was retrieved from IE's cache. Michael G. Schneider Mon, 24 Sep 2007 07:45:45 +0200 from Michael G. Schneider <mgs@newsgroups.nospam>: > > Serving it via HTTP should not be a problem. When you say "secured", > > do you mean via Tools | Protection | Protect Sheet? I have a couple [quoted text clipped - 5 lines] > thanks a lot for your answer. You are absolutely correct. After reading your > post, I did some more tests and found out the mistake. [MSIE used a cached version instead of the latest] Great! Thanks or letting us know. SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.