fangfacekitty
Board Regular
- Joined
- Jul 28, 2010
- Messages
- 63
Every time I refresh my pivot table the formatting changes. I have gone into Table Options and unchecked "Auto Format Table" and checked "Preserve Formatting"....but it still changes formatting every single time.
What is going on here? How do I stop the PT from reformatting on every refresh?
My PT is based on one a coworker uses...that does not change formatting every single time. Is there a way to tell what table/report my coworker's PT is based on? I'm assuming that may be why mine keeps reformatting, if my PT is not based on the same table / report.
Thanks in advance for your help!
What is going on here? How do I stop the PT from reformatting on every refresh?
My PT is based on one a coworker uses...that does not change formatting every single time. Is there a way to tell what table/report my coworker's PT is based on? I'm assuming that may be why mine keeps reformatting, if my PT is not based on the same table / report.
Thanks in advance for your help!