Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

Pivot Tables

ResolvedVersion 2003

Wed 18 Feb 2009, 15:48 Delegate Mark said...

Mark has attended:
Excel Advanced course

Pivot Tables

Will data from any V & H lookup tables come across as data fields rather than formula fields when taking data for pivot tables?

Thu 19 Feb 2009, 11:49 Trainer Cress said...

RE: Pivot Tables

Hello Mark
Thank you for your question

I have used the results in a pivot table before and they have worked fine. If for any reason you get stuck, try copying the columns and paste special as text.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Changing the Tab Colour of an Excel 2010 Worksheet

Did you know you could give the tabs in your worksheet different colours?

This is particularly useful when organizing all your worksheets relating to a particular period or year, for example.

Right click a tab
Select Tab Colour
And choose your favourite colour!

View all Excel hints and tips

Pivot Tables

Pivot Tables

RE: Pivot Tables

Excel articles

Excel tip:

Changing the Tab Colour of an Excel 2010 Worksheet