ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel query not responding (https://www.excelbanter.com/excel-programming/428789-excel-query-not-responding.html)

mckzach

Excel query not responding
 
I am attempting to create an Excel query (using Query Wizard) by importing
about 130 columns of Excel data (only 50 rows or so). However, at the point
where I reach the Query Wizard-Finish dialog box, then click on the 'Save
Query' button, nothing happens. No error message, no hourglass, nothing.

I've built numerous queries before and have never experienced this problem,
though I've never had a data table of 130 columns before. Is that the
problem; too many columns??

Are there any work-arounds to this issue? Any alternatives??

Thanks all



joel

Excel query not responding
 
Maybe there is no data in the filters you selected.

"mckzach" wrote:

I am attempting to create an Excel query (using Query Wizard) by importing
about 130 columns of Excel data (only 50 rows or so). However, at the point
where I reach the Query Wizard-Finish dialog box, then click on the 'Save
Query' button, nothing happens. No error message, no hourglass, nothing.

I've built numerous queries before and have never experienced this problem,
though I've never had a data table of 130 columns before. Is that the
problem; too many columns??

Are there any work-arounds to this issue? Any alternatives??

Thanks all




All times are GMT +1. The time now is 05:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com