Dynamic Data Source in Excel 97

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi,
Can I use a Dynamic Data Source (PivotTables) in Excel 97?
I defined it, but I can't insert "name" in range
PivotTable. Error occured: irregular reference.
HELP
Best regards
Mark
 
Are you doing this through code, or manually? Is the range a contiguous
block of cells, with a header row?

Through code, something similar to the following should work:

ActiveSheet.PivotTableWizard SourceType:=xlDatabase, _
SourceData:="Database", TableDestination:="", _
TableName:="PivotTable1"

If you're doing this manually, type the range name in step 2 of the wizard.
 
Dynamic Data Source works in Excel 97 on condition that
functions excel will be writes in native language. My
don't english.
Debra, sorry for commotion.
Best regards
Mark
 
Back
Top