ExcelBanter - how do i update contents in 1 workbook from pivot tble in another

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i update contents in 1 workbook from pivot tble in another (https://www.excelbanter.com/excel-worksheet-functions/109321-how-do-i-update-contents-1-workbook-pivot-tble-another.html)

Elaine

how do i update contents in 1 workbook from pivot tble in another

I have a work book with pivot tables in it.
I have another workbook which i set up to reformat and copy values from the
pivot table. When i set it up it looks wonderful. All data values are
correct.
I close up everything but when i re-open i can not get the second work book
to display the values.

All times are GMT +1. The time now is 01:19 PM.