sitewolf
Active Member
- Joined
- May 4, 2012
- Messages
- 304
This has been driving me crazy....which is a short trip, but...
In my gov't job they've been using some queries created not in tables...requiring an edit (primarily for time frame) in the query wizard, then going thru this tedious manual process to separate lines of data by various criteria. The process just seems far too inefficient.
So I created parameterized queries, parameters attached to cells at the top, so that changing criteria can be done right there on the sheet. I've also added columns with formulas to do things like include/exclude dollar amounts depending on other info in the line of data. Then pivot tables to summarize it all. This should mean that a process that might take an hour can be replicated in seconds.
My problem?
Sometimes it appears that changing the query criteria (or refreshing the table with the same criteria) gives different results and/or some cells of some data lines don't fully load. Infuriating!
Am I doing something wrong ? If it were a network issue (since I'm querying a database on the network), why don't the old clunky not-in-tables queries seem to have the same issue?
We're on Excel 2010
In my gov't job they've been using some queries created not in tables...requiring an edit (primarily for time frame) in the query wizard, then going thru this tedious manual process to separate lines of data by various criteria. The process just seems far too inefficient.
So I created parameterized queries, parameters attached to cells at the top, so that changing criteria can be done right there on the sheet. I've also added columns with formulas to do things like include/exclude dollar amounts depending on other info in the line of data. Then pivot tables to summarize it all. This should mean that a process that might take an hour can be replicated in seconds.
My problem?
Sometimes it appears that changing the query criteria (or refreshing the table with the same criteria) gives different results and/or some cells of some data lines don't fully load. Infuriating!
Am I doing something wrong ? If it were a network issue (since I'm querying a database on the network), why don't the old clunky not-in-tables queries seem to have the same issue?
We're on Excel 2010