catlady004
02-19-2009, 09:32 AM
Hi
I am very new to VBA programming so please bear with me
I have a spreadsheet (Excel 2003) that takes data from a pivot table that in turn takes its information from an OLAP cube on a different server that holds Microsoft Project plans.
My problem is that I want to automate the update Pivot Table option but if a new MS Project Plan is added and I go to Refresh Data on the pivot table it adds the new plan as well as the plan the spreadsheet is refering to.
Is it possible for a VBA script to only select one field from the drop down list - (macros are not possbile as there are too many fields to chose from and it errors out) and if so where do I do I store it and run it.
Thanks
Beverly
I am very new to VBA programming so please bear with me
I have a spreadsheet (Excel 2003) that takes data from a pivot table that in turn takes its information from an OLAP cube on a different server that holds Microsoft Project plans.
My problem is that I want to automate the update Pivot Table option but if a new MS Project Plan is added and I go to Refresh Data on the pivot table it adds the new plan as well as the plan the spreadsheet is refering to.
Is it possible for a VBA script to only select one field from the drop down list - (macros are not possbile as there are too many fields to chose from and it errors out) and if so where do I do I store it and run it.
Thanks
Beverly