Excel Named Cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kerry - 30 Jun 2008 16:39 GMT

Hi, I'm running RS2000 with service packs, I'm having a strange problem with
some reports. When I execute and export the results to Excel some of the
cells are exported as named cells, they are given names such as _142 other
cells are not given a name. THis causes a problems when trying to work with
the exported data. When you create a formula and try to copy/paste the
formula it will not work because you cell formula references the "name" not
the cell address such as =_142 + _153 therefore pasting simply duplicates the
original formula.

Is there a way to prevent the naming of cells so the end-user can create and
copy/paste their formulas.

thanks

Reply to this Message

Kerry - 07 Jul 2008 18:54 GMT

I figured it out so I leave this for anyone else who comes across this issue,
if you refer to ReportItems on your report for example:
=ReportItems!txtDollarMonth1.Value + ReportItems!txtDollarMonth2.Value +
ReportItems!txtDollarMonth3.Value. When Exporting to excel it will use named
ranges (cells) in for its formulas and it will also give a every cell with a
value a 'named range' within the exported spreadsheet. If you don't want
this remove references to ReportItems and replace with dataset items such as
=Fields!DollarMonth1.Value+ Fields!DollarMonth2.Value+
Fields!DollarMonth3.Value

> Hi, I'm running RS2000 with service packs, I'm having a strange problem with
> some reports. When I execute and export the results to Excel some of the
[quoted text clipped - 9 lines]
>
> thanks

Reply to this Message