rogue row in pivot table - "Formula1"

M

merlin777

Well-known Member
Joined
Aug 29, 2009
Messages
1,395
Office Version
  1. 2007
I've inserted a pivot table and in the row labels column one of the labels is 'Formula1'. I don't have any rows labelled formula1 - where the heck is this coming from!
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
You must log in or register to reply here.

Similar threads

E
  • Question
Conditional Formatting disappears from value's area after filtering the pivot table
Replies
0
Views
66
ExcelNoob222
E
T
  • Question
How do I clear/reset all overwritten labels in a pivot table?
Replies
0
Views
162
TheoTester
T
S
  • Question
Dynamic Pictures as Data Labels in Excel Graph from Pivot Table/Slicer
Replies
0
Views
150
schmitkl
S
O
  • Solved
Msgbox to output cell value in adjacent column but pivot tables won't let me...
Replies
1
Views
101
omairhe
O
M
  • Question
Pivot Chart - X Axis issues
Replies
7
Views
218
RoryA
RoryA

Watch MrExcel Video

Learn Excel - Changing Case in Excel: Lower, Upper, Proper: Podcast #1356

Forum statistics

Threads
1,119,290
Messages
5,577,218
Members
412,777
Latest member
jmulldome

Share this page

Top