ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What is a field name in excel when making a pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/68060-what-field-name-excel-when-making-pivot-table.html)

mr1176

What is a field name in excel when making a pivot table?
 
i'm trying to make a pivot table from accounting journal entries. a window
pops-up when i click finish saying the field name is not valid. i'm using
excel 2003.

pinmaster

What is a field name in excel when making a pivot table?
 
You probably have a blank column header in your selection.

HTH
JG

"mr1176" wrote:

i'm trying to make a pivot table from accounting journal entries. a window
pops-up when i click finish saying the field name is not valid. i'm using
excel 2003.


mr1176

What is a field name in excel when making a pivot table?
 
thank u for the reply, i had column headers, the problem was i had unused or
blank cells in my rows, if you've journalized before you know what i mean.
for the accounts you have to stretch one row out to fit all the data, rather
than just one cell overflowing to the next on some accounts. hopefully this
will help you if this question is asked again. : - ) thanks again


All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com