0

I have the strange case of 2 nearly identical Excel workbook downloads in my code, and often on another team member's machine, and sometimes on my machine, when the user clicks download, the .xlsx file downloads and then "automatically"' opens without having to explicitly open it.

What could cause an Excel workbook to automatically open as soon as its download finishes?

Regards the first answer, I don't have the suggested property in my Chrome settings: enter image description here

7
  • Many things can be at play here: the client browser settings, the computer settings, parameters in the download link, etc... Can you perhaps edit your question to incliude more detail? I think the client browser settings are the most important distinguishing setting. Aug 11, 2020 at 14:02
  • Yes, browser setting. Which browser are you using?
    – harrymc
    Aug 11, 2020 at 15:08
  • @SaaruLindestøkke I don't know much more. The only "parameters" in the download link are the id for which spreadsheet to download. My teammate, where this happens more, also suspects browser settings.
    – ProfK
    Aug 12, 2020 at 6:56
  • @harrymc Chrome, always latest version
    – ProfK
    Aug 12, 2020 at 6:57
  • @ProfK,, are you using any VBA code to download, if yes check the command line , has it set to OPEN FILE,,, or if using TORENT has an option Always open the file,, OR,, hit BROWSER Setting,, Advance,,and clear your Auto Open options. Next time you download an item, it will be saved instead of opened automatically.!! Aug 12, 2020 at 7:32

1 Answer 1

1

Chrome has a setting to open files of certain type automatically.

The first Google hit when I search for chrome open files automatically is this article. It explains how to reset this behavior:

  1. Click on the 3 dots in the top right of your Chrome window and select Settings
  2. Scroll to the bottom of the page and click on Advanced
  3. Find the Downloads section
  4. Click Clear next to Open certain file types automatically after downloading

enter image description here

1
  • Thanks, but I have updated the question to show that I do not have this property in my download settings.
    – ProfK
    Aug 13, 2020 at 10:40

You must log in to answer this question.

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