Pivot tables and merged Cells
 

Howdie

Does a pivot table work with Merged Cells? Conceptually difficutl as
output is in single cells but input is in multiple cells. I need to use
pivot table functionality, but over merged cells. Any ideas?

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***

Pivot tables and merged Cells
 

Another good reason to avoid merged cells. If you can't change them in the
source data, make a copy of the source with no merged cells and use this as
the real source.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Darin Kramer" wrote in message
...
Howdie

Does a pivot table work with Merged Cells? Conceptually difficutl as
output is in single cells but input is in multiple cells. I need to use
pivot table functionality, but over merged cells. Any ideas?

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***