Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Web Query for Excel 2007
The default format for data retrieved by a data connection to an external source is in Excel 2007 is as a "table". This is ideal because it allows us to create formulas using column names, use auto filter, etc., thus solving a lot of problems if we add columns, etc. at a later time.
However, when I choose an iqy file create by NS I can never get the data to import into a table format, and if I choose to format it as a table Excel warns that me the data connection will be lost.
Has anyone gotten web queries to import as a data table in Excel 2007?