When I hit the back button and it asks me to save and I hit cancel the same spreadsheet comes back even when I import new data. It works fine if I click yes to save.
When the file is downloaded to the client, the action of IE and Excel is controlled totally by MS. Maybe you have to check your IE settings. In my machine I don’t find this issue.
Would you mind screen printing your IE setting or give me a recommendation. I am getting this issue consistently.
I uploaded my IE settings in the attached file. If this issue still occurs in your machine, you may need to update your Windows and IE to the latest patch.
You can also test this issue on another machine to see what caused your problem.