Error while trying to export to Excel

One of the RS2005 users is complaining that they are no longer able to export
data to Excel. The problem is specific to just one report. Following is the
error I am getting.
w3wp!ui!8!7/21/2007-16:51:14:: Unhandled exception: System.Exception: An
error occurred during rendering of the report. --> System.Exception: An
error occurred during rendering of the report. --> System.Exception: Excel
Rendering Extension : Number of columns in the Excel sheet exceeded the limit
of 256 columns.
The report was working just fine before. Has anyone faced a similar issue?On Jul 21, 5:10 pm, Adam <A...@.discussions.microsoft.com> wrote:
> One of the RS2005 users is complaining that they are no longer able to export
> data to Excel. The problem is specific to just one report. Following is the
> error I am getting.
> w3wp!ui!8!7/21/2007-16:51:14:: Unhandled exception: System.Exception: An
> error occurred during rendering of the report. --> System.Exception: An
> error occurred during rendering of the report. --> System.Exception: Excel
> Rendering Extension : Number of columns in the Excel sheet exceeded the limit
> of 256 columns.
> The report was working just fine before. Has anyone faced a similar issue?
There seems to be very little documentation on this Excel limit error.
If nothing has changed in the report itself, I would suggest re-
uploading the report to the report server. If this does not work, you
might try rebooting the server itself (of course this is a long shot).
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant