Dynamic Data Source in Excel 97

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
 
D

Debra Dalgleish

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.
 
M

Mark

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

Create a dynamic master file 1
Calculation Based on Dynamic Variables (What-if Scenario) 0
Mail Merge Directory Conditional Page Break 0
PivotTable - feature like "value range" or "slices" available on regular fields? 0
Dynamic pivot table linked to dynamic excel spreadsheets 0
Dynamic Named Range formula without using OFFSET function 5
Creating a high performance dynamic name 2
Dynamically load DataValidation List through Source field? 1

Top