Pivot Table Help

R

Rich

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?
 
R

Roger Govier

Hi Rich

What error message is it giving when it crashes?

--
Regards
Roger Govier

Rich said:
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?

__________ Information from ESET Smart Security, version of virus
signature database 4830 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4830 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top