excel+training - Excel 2003

excel+training - Excel 2003 - Pivot Table

Resolved · Low Priority · Version Standard

Excel 2003 - Pivot Table

Miss has attended:
Excel Advanced course

by - delegate Miss [1 post] (2007 Oct 10 Wed, 16:04) Reply

How do I delete a column from a pivot table that gives the message cannot delete or insert into this pivotal table?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu	Bayswater	3	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	3	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
Full Schedule: See all 109 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel 2003 - Pivot Table

by - trainer Sandy silver contributer [93 posts] (2007 Oct 11 Thu, 12:01) Reply

Hi
You cannot physically delete the column from the Pivot Table the only way to remove it is to drag the field name off the Pivot Table and it will be removed.

Hope this helps.

· Reasons Why VBA for Excel Training Fails
· Fun Things I've Done With Excel
· Tips to Facilitate Printing of Excel worksheets
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Customized Financial Excel Courses in London

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

Rate this page: