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 ***