Forum home » Delegate support and help forum » Microsoft Office general help » VBA Pivot Refresh/Conditional Formatting
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA Pivot Refresh/Conditional Formatting
Resolved · Low Priority · Version 2007
Reply Wed 30 Jun 2010, 16:36Delegate Adam said...
Adam has attended:
Upgrade to Office 2007 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.
For upcoming training course dates see: Pricing & availability
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.
|