export Pivot table to execl with image

[rohit214]

hi all

i am facing a problem regarding to export pivot table to execl but tha problem is when i am expoting

pivot table all data is showing but not showing images.

Is there any macros script to show images in execl

thanks&regards

rohit

[rohit214]

hi all

please help me wright the macros for that

thanks &regards

rohit

[#3]

Hi Rohit,

Try Copy to clipboard-->Image and then paste it excel Sheet...

But all data remains as a Image

Cheers,

Gaayathri

[rohit214]

hi Gaayathri

thanks for your reply but what i want when i click to expot to exel button in pivot table

then it directly export to the execl sheet without doing all of these thing

thanks&regards

rohit

[#5]

I've tryed copying table area, complete table and copy as image but instead the image goes not to excel, it goes only the image link:

U51-TR Altenburg Percal 180 F

148000

170203

115

qmem://<bundled>/BuiltIn/arrow_s_y.png

2160710,5

81207

[#6]

Hello Rohit,

have you find any solution for the above mentioned problem. I am facing the same problem & hinderring for the solution.

Thanks

San

[hectorgarcia]

vote the idea