View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marston Marston is offline
external usenet poster
 
Posts: 43
Default PIVOT TABLES IN VBA

That would be nice, but we don't have Access

BrianB wrote in message ...
Must be done in a worksheet in Excel.

I suppose you can do it, because there is an option in the setup wizard
to use "multiple consolidation ranges". You don't get as much layout
flexibility though. Pages are possible. The final table cannot exceed
certain limitations, as with any PT.

I would link to an MS Access table in this scenario.


---
Message posted from http://www.ExcelForum.com/