We finally came up with a solution for the IE prompts for PIN multiple times and passwrods.
The solution turned out to be adding a Content Header to treat the xls files as “Attachements” — this way IE doesn’t try to open see if it can open for “editing” instead it just gives the user the dialog to open or save choice – If they choose open it just pops open without any delay or extra pin prompts J
Here is the Microsoftt page that gave us this IDEA:
http://support.microsoft.com/kb/899927
Which we found from here:
http://support.microsoft.com/kb/2019105/en-us
The Apache /etc/httpd/conf/httpd.conf change we made to fix this is here:
First – make sure the mod_headers module is loaded and then add the yellow below.
LoadModule headers_module modules/mod_headers.so
Order allow,deny
Allow from all
Deny from all
Header set Content-Disposition attachment