MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Pivot Table

  Asked By: Alma    Date: Oct 16    Category: MS Office    Views: 1689

Pivot table refresh throws error "Cannot open the source table" whn
the Excel sheet is downloaded from the web.

This error is shown because Pivot table is pointing to some temp
folder for the data source instead of the excel sheet.

i have manipulated the string in the code to hard code the
datasource. but i dont know how to get the cells of a particular
Can anyone please help me in this regard,

PvtSource = Worksheets("A").Range("G").PivotTable.SourceData
//here PvtSource is pointing to temp folder of the system
PvtSource = "A!R10C3:R300C5"
//i hv hard coded the source data
Worksheets("A").Range("G").PivotTable.SourceData = PvtSource

// this works fine but i dont want to hardcode the value. i want
atleast to get the values form the range object
(Worksheets("A").Range("G"). ? )

or if someone knows any other way to fix this error tht would be of
gr8 help.



1 Answer Found

Answer #1    Answered By: Viheke Fischer     Answered On: Oct 16

Not sure what you mean,

but try: Worksheets("A").Range("G").Currentregion

Didn't find what you were looking for? Find more on Pivot Table Or get search suggestion and latest updates.