I cannot export my PivotTable as a GIF

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

All,

When I run the following code in Javascript to convert a Pivot Table to an
image, I get a 'The user canceled the operation' as an error message with
the error simply being 'Error'.

var imgName = "c:\\advantage\\tmpimages\\test2.jpg";
frm1.PivotTable1.ExportPicture( imgName, "jpg", 650, 500 );

The following works fine from exporting a Chart Space to an image

var imgName = "c:\\advantage\\tmpimages\\test.jpg";
frm1.ChartSpace1.ExportPicture( imgName, "jpg", 650, 500 );

Any idea why the Pivot Table gives up the ghost?

Best,
Doug




.

Relevant Pages

  • How would you accomplish the following in OWC 10
    ... My reference object would be frm1.ChartSpace1.Charts ... How do you hide or display the ToolBar for the Chart linked to a Pivot table ... via JavaScript? ... Doug ...
    (microsoft.public.office.developer.web.components)
  • Re: Click or Double Click event
    ... javascript you need special syntax - i forget that off the top of my head ... I click or double click in anywhere in the Pivot ...
    (microsoft.public.office.developer.web.components)
  • Re: How would you accomplish the following in OWC 10
    ... My reference object would be frm1.ChartSpace1.Charts ... for a Chart linked to a Pivot table via JavaScript? ... Display the values of the graphs on the chart ...
    (microsoft.public.office.developer.web.components)
  • Re: Dropdown list in PivotTable has deleted items. How to omit?
    ... There are instructions here for clearing old items from a pivot table: ... Bonny wrote: ... the dropdown list for that field still contains "ghost" items that were deleted. ...
    (microsoft.public.excel.misc)
  • Ghost Blank Cell References
    ... Can anyone explain why there are "ghost" blank cells when a pivot table is ... If you have a pivot table that starts in B1 and if you select all of column ... the selected cells are only through ... and perform the same blank cell selection, the selection is not the last row ...
    (microsoft.public.excel.worksheet.functions)