VBA Pivot Refresh/Conditional Formatting

Resolved · Low Priority · Version 2007

Wed 30 Jun 2010, 16:36 Delegate Adam said...

Adam has attended:
Upgrade to Office 2007 course
Team Performance Management course

VBA Pivot Refresh/Conditional Formatting

A spreadsheet built in excel 2003, contains some code to refresh and conditionally format 2 pivot tables based on a validation list in another sheet. When opened in 2007, some of the pivot fields are filled black with black text (ie. unreadable but still there) but in 2003 this doesn't happen. Any ideas? There is also conditional formatting in the code, I suspect that this is what is causing it as the other pivot is fine, but can't see anything immediately obvious.

Wed 30 Jun 2010, 20:30 Trainer Anthony said...

RE: VBA Pivot Refresh/Conditional Formatting

Hi Adam, welcome to the forum. I've done some digging to see if this problem has been replicated elsewhere and come across one similar instance:

http://social.answers.microsoft.com/Forums/en-US/excelchart/thread/f295aa70-96d1-4ef9-a3a8-3f8a040dcf5b

If this is VBA related I suggest "stepping through" the code line by line to identify which line is going wrong (go into the code and press F8 repeatedly, it will action the code a line at a time). The only other way to work around this would be to build in a subroutine to reformat the mis-formatted cells which would be tedious but successful!

Hope this helps,

Anthony

Wed 7 Jul 2010: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Microsoft Office tip:

Draw a perfect square or circle

Click on the Rectangle or Oval button on the Drawing toolbar. (If necessary, click Customize on the Tools menu, and then click the Drawing check box on the Toolbars to display the toolbar.)
Press and hold down both the [SHIFT] key and the mouse button.
Drag the mouse pointer diagonally downward and to the right until the rectangle or circle drawn has your preferred measurements.
Release the mouse button.
Release the [SHIFT] key.
In short, simply hold down the SHIFT key while dragging the mouse pointer!

View all Microsoft Office hints and tips