Updating an Excel Web Query File

To update an existing Excel Web Query (.iqy) file for a report, you need to determine the original report for this file and export it as an .iqy file again.

To determine the report:

1. Open the .iqy file using a text editor of your choice and find the cr attribute.

   The value of the cr attribute is the original report’s ID.

2. Go to Reports > Reports Overview and click any report to open it.

3. Edit the web page address by changing the cr attribute, so it contains the .iqy file's report ID, and press Enter.

   For example, if the cr attribute in the .iqy file contains 515 as the report ID, the report address will be:

                   https://<accountID>.app.netsuite.com/app/reporting/reportrunner.nl?cr=515 
   
                 

4. The original report for the .iqy file is displayed.

To export the .iqy file again:

1. In the report footer, click the Export to Excel Web Query icon .

   If the footer doesn't contain such an icon, click Customize, select the Allow Web Query option on the More Options tab and click Save to save the report.

2. The report is downloaded as an .iqy file.

Related Topics

• Exporting a Saved Report as an Excel Web Query

General Notices