Excel export with formulas

Hi All
Just wondering if there is an option to turn of the exporting of formulas to
Excel, or alternatively not having it create named ranges for the formulas.
I have one report that frequently has over 5500 rows and 5 columns, the last
two are formulas for calculating percentage of the total.
This results in around 20000 named ranges which makes it incredibly slow
(15-20 seconds) to open the workbook.
Thanks
PhillYou can set OmitFormulas in device info to turn off formulas.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_4d0x.asp
Fang Wang (MSFT)
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Phill Carter" <pcarter@.no-spam.bellpotter.com.au> wrote in message
news:%23oti9n8XEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Hi All
> Just wondering if there is an option to turn of the exporting of formulas
to
> Excel, or alternatively not having it create named ranges for the
formulas.
> I have one report that frequently has over 5500 rows and 5 columns, the
last
> two are formulas for calculating percentage of the total.
> This results in around 20000 named ranges which makes it incredibly slow
> (15-20 seconds) to open the workbook.
> Thanks
> Phill
>|||So how do I specify the OmitFormulas device info in a subscription?
Thanks
Phill
"Fang Wang (MSFT)" <fangw@.microsoft.com> wrote in message
news:Op1S2ZJYEHA.2812@.TK2MSFTNGP11.phx.gbl...
> You can set OmitFormulas in device info to turn off formulas.
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_4d0x.asp
> Fang Wang (MSFT)
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Phill Carter" <pcarter@.no-spam.bellpotter.com.au> wrote in message
> news:%23oti9n8XEHA.1000@.TK2MSFTNGP12.phx.gbl...
> > Hi All
> >
> > Just wondering if there is an option to turn of the exporting of
formulas
> to
> > Excel, or alternatively not having it create named ranges for the
> formulas.
> >
> > I have one report that frequently has over 5500 rows and 5 columns, the
> last
> > two are formulas for calculating percentage of the total.
> >
> > This results in around 20000 named ranges which makes it incredibly slow
> > (15-20 seconds) to open the workbook.
> >
> > Thanks
> > Phill
> >
> >
>