I remember seeing your first note, but I think that most of us have probably run into problems using the pivot table wizzard. I have attempted it on several occasions and found that I had to use the mouse keys and the results were not at all consistent. That is probably why you are not getting answers on this. As I recall, you can look at the defining parameters of a pivot table after it has been created, so the best short term solution might be to have someone set it up visually. There might be a way to create one manually without using the wizzard and there might also be a scripting approach. If you could describe what you are wanting to do with the pivot table, we might be able to suggest alternatives.
Best regards, Steve Jacobson On Wed, 11 Nov 2009 14:39:02 +0100, Marek Durila wrote: >Hi all, >I didn't saw it in my in-box folder, in this Case I'm sending again. >Do you have somebody any experiences with Pivot Table in Excel? >How it's works, how can I go trough it? >It used for a statistic or listing some necessary information, but it's >everything, what I know about. >Excel 2003 or XP is optional. >I'm having classic table with 250 rows and 20 columns and I need some >columns make as rows, some as a columns and some put in data field. I'm >able go only trough vizard but what to do after? >With best regards, > Marek Durila >IBM Global Services Delivery Center Czech Republic, s.r.o., SA-dlo: Brno, >TechnickA 2995/21, PSC 61600 >IC: 26244535, ZapsanA v obchodnA-m rejstrA-ku, vedenAcm KrajskA«m soudem v >Brne >oddA-l C, vlo_ka 39922 >IBM Global Services Delivery Center Czech Republic, s.r.o., Registered >address: Brno, Technicka 2995/21, Zip code: 61600 >Company ID: 26244535, Entered in the Commercial Register maintained by the >Regional Court in Brno (Part C, Entry 39922) If you reply to this message it will be delivered to the original sender only. If your reply would benefit others on the list and your message is related to GW Micro, then please consider sending your message to [email protected] so the entire list will receive it. All GW-Info messages are archived at http://www.gwmicro.com/gwinfo, and can be searched through and sorted using the search form at the bottom of the page. If you wish to unsubscribe from this list, send a message to [email protected] and include leave gw-info in the body of the message.
