| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create pivot table, error "Range is not valid"
I made a pivot table with dynamic range and below is my offset function
the name is defined "finacialoffset" the worksheet name is " financial" the number of column is 6 =OFFSET(finanancial!$A$1,0,0,COUNTA(financial!$A:$ A),6) BUT I have error as above! when I put this name in wizard Any comment are welcome Thanks Daniel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Error "Reference Is Not Valid" | Excel Discussion (Misc queries) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| "File Format Not Valid" When Starting Excel. Error Code 0D3F6000 | Excel Discussion (Misc queries) | |||
Threaded Mode
