pivot tables

[Ludvig]

I have data from approximately 8 to 10 worksheets usually in the same
workbook . am trying to consolidate the data using a pivot table , firstly
have been past linking the data on one sheet then using a pivot , problem is
that there is to much data for the pivot table to manage and it is easy to
delete a paste link loosing important data. is it possible to consolidate
data direct from each sheet to the same pivot table?

 

[Ludvig]

Does Anyone know a good source for information on pivot tables or
spreadsheets?

 

[Dave Peterson]

If you've never used pivottables, here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

=======
You may want to try Excel's Help for specific questions about excel.

Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html

See if you can find them in your local bookstore/internet site and you can
choose what one you like best.