Microsoft Excel issue

Good morning,

 

Just wondering if anyone has experienced this before or knows what is going on...

 

Currently, we are using runner machines that are on Windows 7 OS along with Excel 2013. We have a test that when it starts up, it reads from an excel file without actually opening it to verify the columns are present in the file so for a few seconds it is running this in the background then after a minute it starts running the test in our company's software using information in that data file. 

 

We recently decided to move to new runner machines which are running Windows 10 OS and Excel 2016. When we run that exact same test, during that same time period of it reading the data file, instead of checking and moving on we are getting a message asking us if we want to Save, Don't Save, or Cancel. Because of this message box coming up, the test thinks it is still doing stuff with excel so it won't proceed. We are not actually changing anything in the data file so there isn't anything to save. 

 

Would this because of the change in OS and version of Excel? Is it reading the data file and something happens in the background of Microsoft Excel where it thinks "oh hey, this was created in 2013 and I am 2016 so I am running something in the background/updating the file and now there is a change"?

 

Anyone have any thoughts on this? The examples I am using are Macro enabled excel files so I don't know if that makes a difference...?

 

I appreciate any help. Thanks.