When I refresh the pivot table I am working on, the column headings remain, but all the data disappears. I checked the data source and it is correct.
What am I doing wrong? How do I get the data to properly move to the pivot table?
Thank you
That's true, but that shouldn't cause the entire pivot table to disappear. Besides, when the table is refreshed, wouldn't the added rows now be included?
But I agree, it shouldn't cause all the data to disappear (assuming you didn't alter the data source incorrectly). What source range is the pivot pointing at currently?
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.