| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Reference is not Valid"
I have an Excel 2007 table linked to an Access table and have created several
Pivot Tables from the Excel table. I am getting "Reference is not Valid" error message during refresh. Is there any approach to finding the invalid reference without having to tear apart and rebuid my many pivot tables. I'm dealing with a table with approximately 2K rows and 20 columns. I pull interim data tables (GETPIVOTDATA) for graphs which do not always have complete data sets and give me a #Ref!, but I've had these previously and did not get the error message. Thanks in advance, J Austin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "Reference not valid" error when I try to edit the macro in excel | Excel Discussion (Misc queries) | |||
| Create pivot table, error "Range is not valid" | Charts and Charting in Excel | |||
| Pivot Table - Error "Reference Is Not Valid" | Excel Discussion (Misc queries) | |||
Linear Mode
