| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change of table name in access where Excel obtains pivot table inf
Hi,
I have change the table name (from table A to Table B). In Excel I normally use the 'Refresh Data' icon to refresh a pivot table with updated data. When I try to update it now I get the error [Microsoft][ODBC Microsoft Access Data] The Microsoft Jet database engine cannot find the input table or query. Make sure it exists and that its name is spelt correctly. I know the 'easy' option is to rename the table back to 'Table A' but alas I can't. How do I go about redirecting the source. -- Andrew 260707 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving an Excel pivot table to access | Excel Worksheet Functions | |||
| I NEED TO KNOW THE SOURCE OF A PIVOT TABLE FROM ACCESS in excel | Excel Discussion (Misc queries) | |||
| Import from Access to Excel, via pivot table | Excel Discussion (Misc queries) | |||
| Multiple MS Access table sources for pivot table | Excel Discussion (Misc queries) | |||
| Excel Pivot Table with Access | Excel Discussion (Misc queries) | |||
Threaded Mode
