pivot tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Pivot Tables

resolvedResolved · Low Priority · Version 2003

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?

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


 

Excel tip:

Moving between Worksheets without using the mouse

Use the 'Ctrl+PgDn' and 'Ctrl+PgUp' keys.

'Ctrl+PgDn' will move to the right and 'Ctrl+PgUp' will move to the left one worksheet at a time.

View all Excel hints and tips


Server loaded in 0.08 secs.