Updating an Excel Web Query File

To update an existing Excel Web Query (.iqy) file, you need to find the original report for the 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 to 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 you don't see the icon in the footer, click Customize, select Allow Web Query on the More Options tab, and click Save.

2. The report downloads as an .iqy file.

Related Topics

• Exporting a Saved Report as an Excel Web Query

General Notices