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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create pivot table, error "Range is not valid"
The first sheet name in the offset formula is spelled incorrectly --
finanancial If that's not the problem, what error do you get? Is there a heading in each cell in the first row of the source data? Daniel wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create pivot table, error "Range is not valid"
Sorry miss spelled the first sheet name but that is not a problem.
THe error is " reference is not valid" ?? and there is a heading in each cell in the first row of the source data but I changed to A2 and still not working =OFFSET(financial!$A$2,0,0,COUNTA(financial!$A:$A) ,6) Thanks for your help Daniel "Debra Dalgleish" wrote: The first sheet name in the offset formula is spelled incorrectly -- finanancial If that's not the problem, what error do you get? Is there a heading in each cell in the first row of the source data? Daniel wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create pivot table, error "Range is not valid"
Choose InsertNameDefine, and click on the FinancialOffset name
Then, click in the formula in the Refers to box. Is the range that you expected selected on the worksheet? Daniel wrote: Sorry miss spelled the first sheet name but that is not a problem. THe error is " reference is not valid" ?? and there is a heading in each cell in the first row of the source data but I changed to A2 and still not working =OFFSET(financial!$A$2,0,0,COUNTA(financial!$A:$A) ,6) Thanks for your help Daniel "Debra Dalgleish" wrote: The first sheet name in the offset formula is spelled incorrectly -- finanancial If that's not the problem, what error do you get? Is there a heading in each cell in the first row of the source data? Daniel wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
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) |