I would like to have a user enter a parameter into a cell in a worksheet, then run a saved query on that worksheet that uses that (cell reference) parameter. Has anyone ever done this that could help me?
Tim,
Thanks for the help, but I guess I don't understand what you're saying. I tried different variations of what I thought you meant, but nothing seems to work. Basically I want to place 401 rows in a pivot table with subtotals on one field of data. I can't believe that I'm exceeding the...
When trying to add fields to the "row area" I get this message after about the 5th field:
Microsoft Excel cannot make this change because there are too many row or column items.
Does anyone know what this error message means?
The PC that this occurs on is running Windows NT. I get the error when I double click on the file ODBCNT.REG. In the past when I have done this after running ODBCNT.REG, a message appears that ODBC entries have been to the registry and I need to reboot.
I'm receiving an error message that says:
Windows cannot find recycled.vxd. This program is needed for opening files of type 'Registration Entries'.
I am trying to install the ODBC driver ODBCNT\odbcnt.reg. I have done this at least 20 times on different PC's within our offices and never...
Does anyone know of a way to assign a parameter value, that the user is prompted to input, to a variable that is to be used multiple times in the query?
Does anyone know of a good reference source for Excel data queries??? Thanks
I am trying to get a query with 5 parameters to work in Excel. The query works correctly when I hard code the parameters, but as soon as I modify the query to prompt for parameters it duplicates the number of parameters. Instead of asking for the 5 parameters, it asks for 10. If I enter each...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.