Re: "The Pivot Table Name is Not Valid"

Do you just have one column of data selected?
Is there a heading in the first cell in the selected range?

SPECTRUM wrote:
I am trying to create a Pivot Table and am getting an error that the pivot table name is not valid and that my data must be organized in columns with headers- I already have the data sorted A to Z in column A with headers... any help?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

.

Relevant Pages

  • Re: Advanced filter and a list
    ... want to use the first cell as the heading. ... When I create a list of data cells and do Data, Filter, Advanced Filter.. ... "names" is the column heading. ...
    (microsoft.public.excel.newusers)
  • Re: Formating first line of every cells in first column of word ta
    ... I would suggest that you use separate rows for the headings and apply different paragraph styles to the heading and body rows. ... trying to write macro in word for the first time & unable to understand. ... 'orng is the content of the first cell of the row ...
    (microsoft.public.word.tables)
  • s9 of noise right across the hf spectrum...
    ... As in the subject heading I have s9 of noise on every amateur band on the ... HF spectrum... ...
    (uk.radio.amateur)
  • Re: How weird are you?
    ... You're heading toward the opposite end of the spectrum from autism-- ... your neural architecture is slanted toward being good at social stuff ...
    (alt.fan.harry-potter)
  • Re: Help with defining which cell the cursor goes to after you hit enter
    ... of the selected range, moving right goes to the first cell in the next ... Walkenbach's free Enhanced Data Form: ... I have a user looking to hit ...
    (microsoft.public.excel.worksheet.functions)