Excel 2007 Refresh to odc MsAccess Connection losing conditional formatting - need VBA solution

Have you tried the recalculation Hot Keys.

Shift+F9 Recalculates Active Worksheet.
CTRL+ALT+Shift+F9 Forces Excel to rebuild the dependency tree and forces recalculation.

Regards,

Brian

This did not seem to do anything to my spreadsheet.  Any other ideas?

Can you post a copy of the spreadsheet. Be advised that anything posted here is public, so do not post proprietary data.

The spreadsheet is extremely proprietary however I think I have a better clarification for my problem.  The table linked is a pivot table.  My conditional formatting remains on all charts and tables links which  are not a pivot table.  I have seen that there are issues with the pivot table in other posts.  I am just not sure how to address it.  Do you still need my report?  

How are you setting up the conditional Formatting? There should be choices under Apply Rule To: for applying to all cells showing "Field Name" Values. Have you tried selecting these? If I just choose the cells in the pivot and refresh the formatting is only on the cells I selected originally. If I change the rule to All cells showing "Field Name" values, it changes with the refresh.

Brian
ScrnShot.jpg

I  hate to be an idiot - but I do not see the top part of the edit formatting rule where you chose the "All cells showing "Sum... on my spreadsheet.  Do I need to check a different box to have this portion appear?

Are the formatted cells actually in the pivot table or are they copies linked to the pivot table? If so, does the number of cells with data stay the same?

Hmm.  I do not know what to tell you.  I was preparing a table that I could attach for public viewing and made a copy of the spreadsheet for when I lost all of my formatting.  When I hit refresh this time - I did not lose my formatting.  My guess is that I may be experiencing a memory issue.  I have a Toshiba Portege R600 with an Intel Core 2 Duo CPU U9400 @ 1.40 GHz with 3.00GB of memory using the 32bit Windows Vista.  I should have enough memory however I have another spreadsheet that has multiple connections back to the access database which is starting to show issues by not redrawing the charts unless you click on them and then only half the chart shows up.  

This spreadsheet has been losing my conditional formatting for weeks - why it has decided not to do it this morning - I do not know.  I appreciate your time - If you think that this is all caused by memory and the conditional formatting is the last to fire, please let me know.  I am using the data connection wizard - odbc dsn connection to my database instead of queries because it is a deliverable.
If there is a more memory efficient way to connect, please let me know.

Thank you

Kathy

Thank you very much