In an existing spreadsheet I've created several pivot tables. Until lately I've had no prioblem when I merged new data into them and updated the pivot tables. Now after merging in new data, the Refresh option isn't available, and when I attempt to change the pivot table ranges and the Wizard pops up, the back button isn't accessible so that I can enter a new range.
Any ideas on how to cure this. It is incredibly time consuming to recreate and rebuild the pivot tables.