I have a simple pivot table which works on data from a different sheet in the
same workbook. When I change the text on the data source and then click
refreh an the pivot table it doesn't update. The changes I am making are just
simple corrections e.g. changing lower case letters for upper case. Please
help.