When running a python executable /consolidation script on several excel files, the user sees “Error Processing File ‘~XYZ_file name_123.xlsx’ : File is not a zip file”. The script is supposed read several tabs per file and consolidate with 8-10 other files. I myself have no issue running the script successfully however when this teammate runs the script on our target folder , he is seeing the above error for 4 out of the 10 files. The strange thing is there are no zip files and they are not supposed to be any zip files, if the file was ever in a zip file it was done so by someone upstream in the process before it’s landed in target folder. The error means the script will leave these files out of the final consolidation when they should be included.

User with error moved copies of files to a new folder and was able to run successfully however , we need to account for future cases where there are “ghost zip files” that prevent script from running. There will be many different users trying script and we need to be able to handle such a situation or give correct guidance to file owners if there are preventative measures.