View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Monish Monish is offline
external usenet poster
 
Posts: 22
Default macro error when shared

I have a macro-driven workbook which I sent to a client, but when she tries
to run it she gets an error in the initial portion of the macro (as shown
below)...I'm not sure if this is enough info to understand the issue or not.

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _
"TendercardReport!R1C1:R100C49").CreatePivotTa ble
TableDestination:="", _
TableName:="PivotTable10", DefaultVersion:=xlPivotTableVersion10

The macro runs a pivot table from a table of data and then transposes the
vales into another output table.

Appreciate any help or thoughts...

M