I have a specific problem with IE8. Our users download excel files via IE8. Those excel files contain macros which create pivot tables. In order to do that, excel 2007, needs the file to be writable or else the macro will crash with a VBA error.
This only happens when the user downloads the files in question with IE8 and presses 'Open' directly, because IE8 then downloads the files to a "Temporary Folder" which I have not found (it does not seem to be %temp% or Temporary Internet Files, but maybe I am wrong) in which the file is not writable.
When the user first presses 'Save' and then 'Open', everything works fine.
Can someone suggest a work around for that issue?