I had watched ExcelisFun's video here and have posted comments there.
My issue:
When I refresh the query with only one file in the queried folder, there are no problems. I can even swap one excel file for another in the folder. The issue arises as soon as I have more than one file in the folder.
I get the following message:
"Excel Couldn't refresh the table '.....' Here's the error message from the external data source: The operation failed because the source database does not exist, the source table does not exist, or because you do not have access to the data source. More Details: OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number.... An error occurred while processing table '....' The current operation was canceled because another operation in the transaction failed.
Any help is of course appreciated!
My issue:
When I refresh the query with only one file in the queried folder, there are no problems. I can even swap one excel file for another in the folder. The issue arises as soon as I have more than one file in the folder.
I get the following message:
"Excel Couldn't refresh the table '.....' Here's the error message from the external data source: The operation failed because the source database does not exist, the source table does not exist, or because you do not have access to the data source. More Details: OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number.... An error occurred while processing table '....' The current operation was canceled because another operation in the transaction failed.
Any help is of course appreciated!