Importing data from xlsm format

[mridulasori]

Hi,

Is it possible to import data from xlsm formats ? I am using version 10.0 but can't see this option?

 Any help will be appreciated.

Regards

Mridula

[mridulasori]

Is it possible to import data from xlsm formats ? I am using version 10.0 but can't see this option?

 Any help will be appreciated.

Regards

Mridula

[TaraM]

You could also try the Read All Excel Worksheets Macro:

http://community.alteryx.com/t5/Engine-Works-Blog/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-All...

This macro will read all Excel file types, including xlsm and xlsb.