?
Solved

PivotTable

Posted on 2013-01-16
3
Medium Priority
?
233 Views
Last Modified: 2013-01-24
Hi,

I have a pivottable and in two fields excel put a 2 after the fieldname.
0
Comment
Question by:sonmic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 19

Expert Comment

by:helpfinder
ID: 38781845
probably better would be to attach the mentioned file or create a sample with the same problem if original file is confidential
0
 
LVL 5

Expert Comment

by:LazyFolk
ID: 38781885
is the fieldname already used somewhere in the workbook ?
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 1600 total points
ID: 38781888
Hello,

column headers (field names) must be unique in a pivot table source. If you have two data columns with the same name, Excel will MAKE them unique by adding a number at the end.

cheers, teylyn
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question