Pivot Tables of Pivot Tables/Several Sheets

[Chris Norton]

Hi all

Sorry to bother you good people; another daft query...

In view of previous topics - I have a spreadsheet with about 48,000 rows which will expand to the sheet's full capacity of 60k+ in about 6 weeks.

Now, I am likely to filter this down and spread it across 4 spreadsheets which is fine, but am struggling to build up a single pivot table that reads the data from all 4 sheets. Is this possible?

Thanks

Chris

 

[Mark W.]

No. Consider storing your data separately (e.g., in a Text file, Access table) and connecting to this external data using ODBC.