Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro error when shared
Make sure that the SourceData and TableDestination arguments are
correct - if the Workbook has been renamed it will cause errors here. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro error when shared
Thanks for the response first of all.
The error is in fact a "Compile Error, Named Argument Not Found" And it highlights Default Version in the portion of code below: ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _ "TendercardReport!R1C1:R100C49").CreatePivotTa ble TableDestination:="", _ TableName:="PivotTable10", DefaultVersion:=xlPivotTableVersion10 ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1) Any help again would be much appreciated. M "JakeyC" wrote: Make sure that the SourceData and TableDestination arguments are correct - if the Workbook has been renamed it will cause errors here. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro error when shared
Just to hazard a guess: Is your client running an earlier version of
Excel? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro error when shared
She is...I wasn't sure how to accommodate that...is there anything I should
have/ can do? M "Mark Lincoln" wrote: Just to hazard a guess: Is your client running an earlier version of Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared workbook error message | Excel Worksheet Functions | |||
Shared workbook - Locked Error | Excel Discussion (Misc queries) | |||
Macro error when file is shared | Excel Discussion (Misc queries) | |||
Macro in Shared workbook - Runtime error | Excel Programming | |||
Shared file - macro error | Excel Programming |