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?