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.
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
