Hi
My workbook doesn't have any external data connections (all the queries/connections are from Tables within the sheet),
however, when I refresh one of the queries that loads to a Table a the worksheet, I get this message...
...only if
Can anybody think of a way to avoid that happening?
(I tried deleting all but the first couple of rows of the table before refreshing the query, but in Excel 365 it seems having done that it only refreshes those first two rows and doesn't load the rest of the rows that the query generates to the table.)
My workbook doesn't have any external data connections (all the queries/connections are from Tables within the sheet),
however, when I refresh one of the queries that loads to a Table a the worksheet, I get this message...
The following data range failed to refresh:
ExternalData_1
...only if
- I'm using Excel 2010 (refreshing the same query in the same file opened in 365 does not produce this error)
- The table of data that the query is refreshing results in fewer rows than is already present on the worksheet
Can anybody think of a way to avoid that happening?
(I tried deleting all but the first couple of rows of the table before refreshing the query, but in Excel 365 it seems having done that it only refreshes those first two rows and doesn't load the rest of the rows that the query generates to the table.)