Hello AltCommunity,
I have a system generated Excel file (.xlsx) that i'm having trouble connecting an Input Tool to. Alteryx is not recognizing the Sheet Name. I've found that if I configure the File Format to Microsoft Excel Legacy, it works! However, when attempting to run on Alteryx Server I receive this error message: Error opening connect string: Can't create Data Source Object.
Has anyone run into this issue? If so, how did you resolve it?
