Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.sqlserver.odbc
|
|||
|
|||
"Problems obtaining data" error refreshing Excel pivottable
I have an extremely large Excel XP (SP2) workbook with tables and charts
being refreshed programmatically from SQL Server 2000 (via the PivotTableWizard method). The amount of data being pulled back grows each day and, in the last few days, the PivotTableWizard call to refresh one of the pivottables sporadically began raising a "Problems obtaining data" error (very informative). The query used to refresh the table returns a ton of data (18 columns and over 65000 rows); note: the fact that it returns over 65000 rows has not caused problems in the past. Anyway, when I reduce the amount of data being pulled back the query (by reducing the time span over which data is drawn), the error stops being raised. Thus, the problem does SEEM to be related to the amount of data being retrieved--but I'd like to have a better idea what exactly is going on. Does anybody know whether there's a limit to the size of queries used to refresh pivot tables? Or, does anyone have any idea what might be the specific cause of this murky error message? Thanks... Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: "Reference is not valid" when refreshing pivot table | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel Service error "cannot connect to external data source" | Excel Discussion (Misc queries) | |||
VBA code to "background-color" a cell obtaining a value from Row | Excel Discussion (Misc queries) | |||
Data Validation with "VBA Refreshing" out of order | Excel Discussion (Misc queries) |