- Jan 20, 2006
- Office Version
I have a two seperate workbooks both with Pivot tables. They worked perfect UNTIL I opened them both at the same time. Now the only way I can refresh either one of them is to have both open at the same time. They are two entirely different subjects and have no shared information between them. I use one daily and the other maybe 3-4 times a month. But now I have to OPEN Both to update the daily and I have just noticed that since I opened both, now that the Filter (CATAGORY which is text) in the slider is no longer alphabetized after adding new categories. New entries are located at the bottom of the list. Daily file has over 2000 rows of data in 7 columns. Monthly file has 300 rows with 4 columns. (Excel 2019 running on Windows 10). Thanks in advance for the help.