| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GetpivotData returns a #REF! error
I have a monthly file with getpivotdata formulas which I resave each month as
a different name. All of the sudden on the most recent resave, my getpivotdata formulas no longer work, with absolutely no changes to the file other than the filename. Any suggestions out there? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
GetpivotData returns a #REF! error
What version of Excel are you using?
What's the GetPivotData formula? What was the file name previously, and what is the new file name? Jeff K wrote: I have a monthly file with getpivotdata formulas which I resave each month as a different name. All of the sudden on the most recent resave, my getpivotdata formulas no longer work, with absolutely no changes to the file other than the filename. Any suggestions out there? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
GetpivotData returns a #REF! error
I found the issue, just not sure why it's popped up or how to fix it. In the
formula below if the Haberfeld!G6 cell is text, the formula works, but does not if this cell is numeric. Any suggestions? "Jeff K" wrote: This is in Excel 2000. The file was previously "Deposit Summary - Oct 05.xls" and is now "Deposit Summary - Nov 05.xls" "Debra Dalgleish" wrote: What version of Excel are you using? What's the GetPivotData formula? What was the file name previously, and what is the new file name? Jeff K wrote: I have a monthly file with getpivotdata formulas which I resave each month as a different name. All of the sudden on the most recent resave, my getpivotdata formulas no longer work, with absolutely no changes to the file other than the filename. Any suggestions out there? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP using a cell calculated with NOW returns Error | Excel Worksheet Functions | |||
| Date Value Funtion in Excel 2003 returns an error, but not in Exce | Excel Worksheet Functions | |||
| Condition now returns error | Excel Worksheet Functions | |||
| Problem with GEOMEAN - returns #NUM error | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
