Export to Excel - merge and centre issue

hi
I am exporting a report from SQL 2000 reporting services into excel and by
default all columns have merge and centre clicked. Can i change this so this
property is not checked which makes it easier for users to do things like
sorting etc.
Any help would be appreciated.
Thanks heaps
RidhimaIs this Excel export or CSV export? With CSV the default is Unicode which
Excel then merges (or doesn't split into different columns). In 2000 the
only thing you can do if this is the case is have a link the user clicks
that then uses jump to URL and you have it render in CSV ASCII. In RS 2005
you can configure it to export CSV in ASCII format as the default.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ridhima Sood" <RidhimaSood@.discussions.microsoft.com> wrote in message
news:511E9718-8B0F-4A84-AF8D-71DA3598E104@.microsoft.com...
> hi
> I am exporting a report from SQL 2000 reporting services into excel and by
> default all columns have merge and centre clicked. Can i change this so
> this
> property is not checked which makes it easier for users to do things like
> sorting etc.
> Any help would be appreciated.
> Thanks heaps
> Ridhima