HI, I have a question for you.
Usually I need to copy a pivottable from a excel file to another (Excel
2003), to do this I click on source file A.xls and an excel application
startup, after I click on destination file B.xls and this start another
excel application too.
I select and copy the pivottable from file A and after paste the pivottable
on file B, but only values and formats are copied not the data, if I do
right-click of the mouse button on pivottable copied on file B there isn't a
menu for pivottable.
This work only if I open file A and B from the same excel application, but
normally I open the xls files from explorer and this open more that one
I remember that with excel 2000 I do this, but I not remember if excel 2000
opened the a both files on the same application or not.
Is possible to bypass this trouble because many job colleagues copy
pivottable in this way whitout to verify if the pivot is correct and loosing
the pivottable data.
Thanks in advance