Pivot table refresh reverts to "Show all"

B

BobG

My PTs have been grouped by date and I have unchecked the < start date and >
stop date, eliminating those rows in the PTs. For 3 years, up until 2 weeks
ago, I could refresh the tables and just get new data displayed. Now I have a
new behavior. When I refresh the PT the unchecked rows reappear and I have to
uncheck them again. I have many PTs and having uncheck the data at every
refresh is not appealing. One more curiousity is that once unchecked I can
refresh all day, but the next day the unchecked rows reappear the first time
I refresh. What has changed?
My company uses x2003 and the partner company uses x2007 and we pass the
workbooks back and forth in the xlsx format. I have to use the converter.
This has not been a problem, but is one of those things I feel I have to pass
on.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top