| 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 |
| 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 | |||
Threaded Mode
