I've got a file with several hundred tabs with identical structure that I needed to transform and bring in to one table. I created a query on one sheet, converted it to a function and applied it to a list of the sheet names. All worked fine so far.
I then received an updated version of the source sheet and reconnected my query. However this time I got an unable to format as a number type error. I eventually tracked it down to an entry that contained both text and numbers "16 hours per day", but it took me ages. The error was therefore generated by the function for one of the sheets and so as soon as I expanded the columns I get the error status with no indication of where it came from.
Any better way to do this?
I then received an updated version of the source sheet and reconnected my query. However this time I got an unable to format as a number type error. I eventually tracked it down to an entry that contained both text and numbers "16 hours per day", but it took me ages. The error was therefore generated by the function for one of the sheets and so as soon as I expanded the columns I get the error status with no indication of where it came from.
Any better way to do this?