Securing a worksheet vs. HTTP

  • Thread starter Thread starter Michael G. Schneider
  • Start date Start date
M

Michael G. Schneider

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
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.
Click to expand...

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?
 
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
Click to expand...

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
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.
Click to expand...
[MSIE used a cached version instead of the latest]

Great! Thanks or letting us know.
 
Back
Top