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.
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,127,194
Messages
5,623,303
Members
415,965
Latest member
Sixaside

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