can you not just change the file type to .xlsx? on your 97-2003 worksheet? the way lazy people would change a notepad file to html? If that doesn't work can you just send me a copy of your file? I'll open it, change the type, save it and confirm it works in 2016 and send it back to you. Also, you dont have any addons enabled in your 2016 that might be causing issues right? ive had to toggle developer mode and solver off randomly to fix issues. I'm sure I can square you away with a bit more info haha