Export to XLS without Macros

[#1]

Dear QV Experts,

We have few charts in the sheet & need to be exported to XLS SpreadSheet without Macros.

Can you please share your thoughts.

Thanks,
SasikumarR

[pamaxeed]

Hi,

if you want to export the charts data into a single sheet then the only way you can achieve it is to use macro.
On the other way there is the possibility to export a chart one by one in a diff. .xls, but as I understood it is not what are you looking for.

Cheers,

Patric

[#3]

If each sheet can be exported seperately you can right click on the chart and select Send to Excel or Export, which will then send to a .csv file

[datanibbler]

Hi Sasi,

in addition to the possibility thatPatric has mentioned, there is a third-party tool called "ReportToMail" which supports exporting charts to Excel - to a specific worksheet and into a specific range of cells. But well, that would again be an additional tool that you'd need.

Without anything extra, I guess Patric's solution is the only one.

HTH

[Chanty4u]

hope this helps you..