The instructions in the User's Guide for Excel web query only work for when first created. If you close and reopen the spreadsheet or after a period of time I just get the signin screen
This web query returned no data. To modify the query, click OK, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar.
When using a Web Query to import a report from SBM it used to be possible to select just the table containing the report data and not import the report headers and footer.
If you right click in a report using IE 7 and select Export to MS Excel, the report appears in Excel 2007. When you select Edit Web Query , window opens and then you get a run tme error: line: 245; Error is null or not an object"
The following instructions explain how to import SBM data to Microsoft Excel 2003 and Excel 2013 using the Microsoft Excel Web Query feature. Use this method to
When using Form/URL/Cookie authentication, users who wish to query TeamTrack from external applications, such as Microsoft Excel , must add the login parameters to the URL. For example, if the Web query is:
