ShufflePoint deprecated the XML Spreadsheet feed so that we could avoid having to support two different feeds. Since the HTML feed works with both Windows and Mac, this was chosen as the single feed format. What we didn't realize was that Excel 2007 could not refresh reports created with the XML Spreadsheet IQY file but fed the HTML feed.  I spent some time today (happy 4th of July!) to create a macro which corrects the web queries present in an Excel workbook so that they will work.

If you refresh a ShufflePoint query in Excel and get an error that begins with "The web query returned no data" then you will have to run this macro to update all the web queries.  The macro will also set query properties to values we recommend. You can review the macro source to see what those are.

To run the macro, you need to:

1. Download and unzip ConvertXmlssToHtml.zip
2. enable the developer ribbon by clicking the Office icon in the upper-left and selecting "Excel Options"
3. Check "Show Developer tab in the Ribbon"
4. Open a work book to convert
5. Select the "Developer" ribbon.
6. Click the "Visual Basic" button
7. Click "File/import file…" and select ConvertXmlssToHtml.bas
8. In the Visual Basic editor. Under Tools menu open "References" and check "Microsoft Scripting Runtime"
9. Close the Visual Basic window
10. On Developer tab, click "Macros"
11. Select ConvertXmlssToHtml and click "Run"

After running the macro, test that it was successful by refreshing one of the web queries.

If you have any question or problems, please don't hesitate to contact support.