We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Refresh the Range of a Pivot Table

Thread ID:

Created:

Updated:

Platform:

Replies:

93694 Mar 30,2010 04:53 AM Apr 6,2010 09:10 AM ASP.NET Web Forms (Classic) 4
loading
Tags: XlsIO
Administrator [Syncfusion]
Asked On March 30, 2010 04:53 AM

I tried to insert rows in the pivot table example. The insert works fine but the source range of the pivot table didn't refresh.
I tried the same with the chart example. The source of the chart will be refresh automaticly after the insert.

Is it not possible to insert rows and refresh the source range automaticly in a pivot table?

View the example in the attachment.





PivotTable_290865d8.zip

Sathish Babu R [Syncfusion]
Replied On March 30, 2010 09:31 AM

Hi Matthias,

Thank you for using Syncfusion Products

We are afraid that we were not able to reproduce the issue on our side.

We gave new value “65000” to cell “F10” by changing the line number “90” in the sample code, It Automatically updating in the Pivot Table.

Please see the output screenshots from the below location.

Refresh Pivot Table-1827958255.zip

Regards
Sathish Babu R


Administrator [Syncfusion]
Replied On March 31, 2010 02:33 AM

I see the new 2 rows in the pivot table, but the last 2 rows are not in the range of the pivot table. Please see the example below.


1. The Range will set to "A1:H50".
2. Adding a few rows between Row 1 and 50.
3. The Range of the PivotTable is still "A1:H50" instead of "A1:Hn"



PivotTable_2010_a3d02b00.zip

Sathish Babu R [Syncfusion]
Replied On April 1, 2010 01:48 AM

Hi Matthias,

We are sorry for the possible inconvenience caused.

The issue mentioned here is suspected to be a defect and we have sent this to our development team for more analysis. We will get back to you within two business days.

However, it would be great, if you could open a incident in the direct-trac to further follow-up on this issue.
https://www.syncfusion.com/Support/DirectTrac/logon.aspx?URL=/Support/DirectTrac/default.aspx


Regards,
Sathish Babu R

Sathish Babu R [Syncfusion]
Replied On April 6, 2010 09:10 AM

Hi Matthias,

The issue 'Refresh the Range of a Pivot Table' has been confirmed as a defect and we have logged a defect report. The fix for this issue will be available on '04/20/2010'.

Thank you for your interest in Syncfusion products.

Regards,
Sathish

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;