Pivot table update??

DaGoose

Board Regular
Joined
Jan 20, 2006
Messages
96
Office Version
  1. 2019
Platform
  1. Windows
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.
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,614
Messages
5,838,381
Members
430,542
Latest member
Elaine E

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top