| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Help
Help!
I have written some code which manipulates Excel 2007 pivot tables. The program works fine on my machine and on the guy that sits next to me. But...3 other people in the organisation have issues with the spreadsheet crashing. The code is around this part: With ActiveSheet.PivotTables("PivotTable2").PivotFields ("Activity Date") .PivotItems("<" & Start_Date).Visible = False .PivotItems("" & End_Date).Visible = False End With Where 'Start_Date' and 'End_Date' are variables based on data entry. As I said...works fine on my machine and the second machine I tested it on but not on the others. Everyone is working on Excel 2007. What I am trying to do is limit the data input to only show values between start and end date... Any clues or fixes out there? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Threaded Mode
