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.