Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I unlimit field size in using Excel Pivot Tables?
I am creating a pivot table in excel and my source information is not
competely copying over to my pivot table field. How do i un-limit the field size in the pivot tab le so the entire source information will be captured? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I unlimit field size in using Excel Pivot Tables?
Whilst in your Table, right click, choose Pivot table wizard, hit Back until
you see the source selection option that says 'Where is the data you want to use', reselect your entire range and then hit Next and Finish. To set up a dynamic range so that it will expand as you increase your source data, see the following link:- http://www.contextures.com/xlPivot01.html -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "CBK" wrote in message ... I am creating a pivot table in excel and my source information is not competely copying over to my pivot table field. How do i un-limit the field size in the pivot tab le so the entire source information will be captured? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables in Excel 2000 | Excel Discussion (Misc queries) | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
How can I change the default settings for pivot tables in Excel? . | Excel Discussion (Misc queries) | |||
Pivot tables Excel 2003 absolute references | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) |