My RS2005 reports use specific company colors. Looks great in RS, but when you export such a report to Excel, my bright green turns yellow and my dark green turns brown. This is outright ugly.
As a workaround, I can manually open another Excel sheet where the standard colors have been overridden to match company colors, then go back into the Excel Report, Tools>Options>Color, then use the dropdown "Copy Colors From" the other file, which "fixes" my Excel Report.
I cannot require my user base to repeat this action with every new export to excel instance. Question is whether I can somehow manipulate the excel export programmatically or add settings in the RDL that make the export aware of the specific color palette?
Many thanks for your assistance