Search:

Type: Posts; User: kadzu

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    773

    Re: Update source of chartData

    How can I put the formula in the source?
  2. Replies
    3
    Views
    773

    Update source of chartData

    I have 4 charts in a sheet called "Menu" that uses a sheet in the image bellow as source. All of them have the first column as the X axis and each chart uses one of the four other columns as Y axis....
  3. Replies
    2
    Views
    4,799

    Re: Refresh Pivot and Sort By Data Source Order

    I think I solved(still looking for possible troubles caused by this solution but none found so far) :

    1. I created one empty version of each sheet thats used as a source(with the name of the...
  4. Replies
    2
    Views
    4,799

    Refresh Pivot and Sort By Data Source Order

    I have many differents Worksheets with 1 or more pivot tables, their source is always a worksheet.

    For example, the source of a PivotTable is "sheet_data1!$A$1:$I$1149". The worksheet...
  5. Replies
    1
    Views
    1,046

    Update PivotTable Source

    I have many differents Worksheets with 1 or more pivot tables, their source is always a worksheet.

    For example, the source of a PivotTable is "sheet_data1!$A$1:$I$1149". The worksheet...
  6. Replies
    5
    Views
    1,096

    Re: Error in Worksheet_PivotTableUpdate

    But what is activeworksheet? If it is the worksheet currently been seen then it wont work because the pivot table will be changed in the WorkbookOpen and the sheet with this pivot is not the first...
  7. Replies
    5
    Views
    1,096

    Error in Worksheet_PivotTableUpdate

    I'm trying to synchronize the filters of 2 pivot table(just from one way, change filters in pivot2 when filters in pivot1 are changed but not the opossite).
    But I get this error when I try getting...
  8. Replies
    6
    Views
    764

    Re: Help with Error 1004

    I used "ActiveWorkbook.RefreshAll" and it worked, is "application.ontime" better?
  9. Replies
    6
    Views
    764

    Re: Help with Error 1004

    Is there a way to wait for the workbook for the data to load?
  10. Replies
    6
    Views
    764

    Help with Error 1004

    I created a program in C# that generates an Excel File, the file also has the a VBA code that runs when the file is opened.
    When I open the file,the VBA code runs normal but if I close without...
Results 1 to 10 of 10



Click Here to Expand Forum to Full Width