however, the solution was just a tilt!! i moved the subtasks to outer level and then back to place, and the pivot gave the correct wbs structure this time..
So, be careful when you have many activities.. you may have to tilt your program
Member for
21 years 8 months
Member for21 years8 months
Submitted by Rafael Davila on Wed, 2009-06-17 16:52
What if you use Save as CSV or even as MS Excel Workbook instead of a MS Excel Pivot Table throug your visual reports wizards. By doing so maybe you will be in better control of your Pivot Tables than if using a Pivot Table Wizard from the start of data transfer.
Never had such a schedule but understand MS Excel is RAM hungry. Save as CVS should be the less RAM demanding route. Follow the link for an article on the limits of Pivot Tables.
Member for
21 years 8 monthsRE: urgent help - cash flow report
Great, just keep hanging around PP, seems like you are a lot of steps ahead of me, the sharing of your knwledge will be welcomed.
Best regards,
Rafael
Member for
20 yearsRE: urgent help - cash flow report
thank you rafeel for your help..
however, the solution was just a tilt!! i moved the subtasks to outer level and then back to place, and the pivot gave the correct wbs structure this time..
So, be careful when you have many activities.. you may have to tilt your program
Member for
21 years 8 monthsRE: urgent help - cash flow report
suha
What if you use Save as CSV or even as MS Excel Workbook instead of a MS Excel Pivot Table throug your visual reports wizards. By doing so maybe you will be in better control of your Pivot Tables than if using a Pivot Table Wizard from the start of data transfer.
Never had such a schedule but understand MS Excel is RAM hungry. Save as CVS should be the less RAM demanding route. Follow the link for an article on the limits of Pivot Tables.
http://support.microsoft.com/kb/211517
If you cannot overcome the limits in any way then save as CVS and use of a Database software as MS Access/ Lotus Approach could be an option.
Primavera SureTrak have a Pivot Table Wizard but it is very slow and wonder if can handle the 10,000 activities, SureTrak limit.
Hope this helps,
Rafael