Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Visual Studio 2005 For discussing Visual Studio 2005. Please post code questions about a specific language (C#, VB, ASP.NET, etc) in the correct language forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Studio 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 4th, 2008, 12:14 PM
Registered User
 
Join Date: Nov 2008
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help needed for Excel Automation

Hi,

I want to refresh my existing pivot table in excel in VB .net Application when i refresh my Base data.How can i achieve that.

How can i use PivotTableWizard for this purpose?

With this,I have formula attach with this base data so when my base data get refresh the reference data also get refresh,problem is when my base data has more rows than that formula not carry forward to that extra rows..How can i resolve this issue using VB .net application.

I already achieved refreshing my base data but stuck on Pivot refresh and formula carry forward..Anyhelp is higly appreciated.

Thanks
Material.Study
 
Old November 5th, 2008, 11:11 AM
Registered User
 
Join Date: Nov 2008
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I solved issue of Pivot table refresh..Now only problem with carry forwading the formula..

Anyhelp is higly appreciated...

Material.study
 
Old December 3rd, 2008, 10:51 AM
Registered User
 
Join Date: Nov 2008
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

This is really bad forum..You should atleast reply on user questions..They think that somebody from this forum goign to support you but they disappointed when no one reply you after days and days.

Instead of being part of this forum..googling is best option..Why you are doing marketing by saying that use our P2P forum where expert can help you on your question.

We do understand that writter is doing other jobs and all that but,If you are doing marketing on P2P forum then you should atleaast maintain the customer/user faith.

I hope someone take this seriously and take action on it.The books by Wrox production is really nice..I have somany different language copy of Wrox production..

I resolved my below issue but i want to share my feedback.

Thanks




Similar Threads
Thread Thread Starter Forum Replies Last Post
Pictures in Automation of Excel gardengirl447 BOOK: Access 2003 VBA Programmer's Reference 2 July 4th, 2011 06:54 PM
Excel Automation MAKO C# 0 August 16th, 2006 01:05 PM
Excel VB Automation jeannief Excel VBA 3 June 14th, 2005 06:06 AM
Excel Automation ameysun C# 0 November 4th, 2004 07:33 AM
Excel Automation ameysun Pro VB 6 0 November 4th, 2004 02:55 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.