Pivot table : Excel cannot complete this task with available resou
Good day everybody,
I am promoting this exciting feature of Pivot table in Excel 2002 to my
colleagues to do data analysis hence reduce customised report request.
I managed to process and build required data into a DBF to link to Pivot
table.
When I hit the first 'Cannot complete' message, I spilt my DBF for two Pivot
tables.
Then my users request to see Material description instead of just Material
number.
This cause the second 'Cannot complete' message when I try to add to Pivot
table.
I cannot shorten the description, I have run out of ideas how to solve or
work around to deliver the pivot table to my users.
I will appreciate it very very much if anyone provide me with
suggestions.........
Have a nice day and weekend.
Best regards,
Julie
|