Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
When the user first presses 'Save' and then 'Open', everything works fine. - the best possible workaround for the case) – Peter L. Feb 22 '13 at 17:27
You can use something like Process Monitor to see where the file's been temporarily saved. %TMP% / %TEMP% or a sub-dir is generally where it goes. – Karan Feb 22 '13 at 17:59

Had the same issue. What I've found out:

IE8 renames files on cliking "Open" like fileName[n].extension and puts it in temp folder which is not writtable by user.

  1. In Excel file name symbols [ and ] are not allowed. See Section "MORE INFORMATION":

    • Make sure the file name does not contain any of the following characters: < > ? [ ] : | *.
  2. Macroses can be enabled only in writable folder

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .