Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I have an excel pivot table using a query from an access database as the source. Worked great, including refreshing the data. Now I have a problem because I had to change the structure of the underlying database and didn't fix some of the querys yet. When I try to hange the query I'm getting the error message: "This query can not be edite". On OK I get the next message: "Too few parameters. Expected 1." I'm sure that's because of my changes in the database structure. But my problem is, that I don't know which query I used for the data. Is there anyway to show which query was used???? Any help would be appreciated. Juergen Amling -- halemweg ------------------------------------------------------------------------ halemweg's Profile: http://www.excelforum.com/member.php...o&userid=24839 View this thread: http://www.excelforum.com/showthread...hreadid=383930 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot Table Security in Excel | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |