ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Unable to update data from pivot table (https://www.excelbanter.com/excel-worksheet-functions/198078-unable-update-data-pivot-table.html)

chedd via OfficeKB.com

Unable to update data from pivot table
 
Hi

I am designing a pivot table to give a monthly report and i have clicked the
box in table options to update to refresh on opening the spreadsheet, but
this is not happening. Any ideas?

chedd

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200808/1


TSW632

Unable to update data from pivot table
 
On Aug 8, 2:57*am, "chedd via OfficeKB.com" <u18187@uwe wrote:
Hi

I am designing a pivot table to give a monthly report and i have clicked the
box in table options to update to refresh on opening the spreadsheet, but
this is not happening. *Any ideas?

chedd

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200808/1


did you update the range?


All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com