Hierarchy formatting lost when workbook migrated
We migrated our workbooks to Version 7.0 and except for a few annoying qliches, they seem to work the same.
Unfortunately, whenever we have a hierarchy on the workbook - the colour disappears in the background. When in the same query the hierarchy is removed, the colour comes back.
Any ideas of what this could be?
All help appreciated.
Leonardo Restrepo replied
The command equivalent in Excel 2007 is : Menu Excel "Home" --> "> Cells Styles".
In "http://www.microsoft.com/downloads/details.aspx?FamilyId=89718ABD-2758-47B3-9F90-93788112B985&displaylang=en" you can download "Excel 2007 Guide: Excel 2003 to Excel 2007 interactive command reference guide".
I hope you will be helpful.