Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - problem with field
Hello,
I received the following message when trying to run PivotTable report.."A field in your source data has more unique items than can be used in a PivotTable report. Microsoft Office Excel may not be able to create the report, or may create the report without the data from this field." The field the message referred to is a 9 digits field and has no space in front of column title. Please help! -- Thanks, XIDEN |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - problem with field
This sounds like a version issue. What version of Excel are you using and
where are you trying to place the field- a row, column, data, or page field? For example in 2007: Unique items per field 1,048,576 earlier versions have lower limits. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Xiden" wrote: Hello, I received the following message when trying to run PivotTable report.."A field in your source data has more unique items than can be used in a PivotTable report. Microsoft Office Excel may not be able to create the report, or may create the report without the data from this field." The field the message referred to is a 9 digits field and has no space in front of column title. Please help! -- Thanks, XIDEN |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - problem with field
Hi Shane,
I have Microsoft Office 2003. The table was exported from Access query and contains many columns and about 4,000+ rows. I was able to place this particular field in data area; however, it would let me place it in row area. Thanks, XIDEN "Shane Devenshire" wrote: This sounds like a version issue. What version of Excel are you using and where are you trying to place the field- a row, column, data, or page field? For example in 2007: Unique items per field 1,048,576 earlier versions have lower limits. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Xiden" wrote: Hello, I received the following message when trying to run PivotTable report.."A field in your source data has more unique items than can be used in a PivotTable report. Microsoft Office Excel may not be able to create the report, or may create the report without the data from this field." The field the message referred to is a 9 digits field and has no space in front of column title. Please help! -- Thanks, XIDEN |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - problem with field
"Xiden" wrote: Hi Shane, I have Microsoft Office 2003. The table was exported from Access query and contains many columns and about 4,000+ rows. I was able to place this particular field in data area; however, it would not let me place it in row area. Thanks, XIDEN "Shane Devenshire" wrote: This sounds like a version issue. What version of Excel are you using and where are you trying to place the field- a row, column, data, or page field? For example in 2007: Unique items per field 1,048,576 earlier versions have lower limits. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Xiden" wrote: Hello, I received the following message when trying to run PivotTable report.."A field in your source data has more unique items than can be used in a PivotTable report. Microsoft Office Excel may not be able to create the report, or may create the report without the data from this field." The field the message referred to is a 9 digits field and has no space in front of column title. Please help! -- Thanks, XIDEN |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - problem with field
"Xiden" wrote:
Hi Shane, I have Microsoft Office 2003. The table was exported from Access query and contains many columns and about 37,000+ rows. I was able to place this particular field in data area; however, it would not let me place it in row area. Thanks, XIDEN "Shane Devenshire" wrote: This sounds like a version issue. What version of Excel are you using and where are you trying to place the field- a row, column, data, or page field? For example in 2007: Unique items per field 1,048,576 earlier versions have lower limits. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Xiden" wrote: Hello, I received the following message when trying to run PivotTable report.."A field in your source data has more unique items than can be used in a PivotTable report. Microsoft Office Excel may not be able to create the report, or may create the report without the data from this field." The field the message referred to is a 9 digits field and has no space in front of column title. Please help! -- Thanks, XIDEN |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem if Source field name of pivot table changes | Excel Worksheet Functions | |||
Calculated field problem in a Pivot table | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Pivot Table calc field problem | Excel Discussion (Misc queries) | |||
Pivot Table Calculated Field Problem | Excel Discussion (Misc queries) |