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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Run-time error '1004' General ODBC Error 1
Drop Down with dynamic named range offsheet source list 14
Dependent drop down dynamic range formula, off sheet. 7
URGENT: Using Named Ranges with Chart Wizard 4
Function to return a range of cells from a PivotTable 2
Excel 2007: Create a pivot table where data is in multible sheets 12
Pivot Table from linked spreadsheets 1
Use multiple page fields in pivot table 7

Back
Top