I receive an Excel spreadsheet from a supplier monthly and have a scripted process to import this which has been working fine for years (the structure doesn't change). I've just received their latest spreadsheet and I'm getting an error when running the script - invalid import error. Looking at the spreadsheet everything appears to be the same, so I tried importing this manually and I can see what the issue is:
There's another worksheet above Sheet1 that it should be importing from called ArrayValuesWorksheet which is causing the problem. However in Excel I can't see this worksheet to delete it:
Anyone seen this before or know how I can delete this invisible worksheet so my script will continue to work again?