Macro in Excel - Run Time Error 1004

[wandan]

Hello,

I am trying to run a very small macro in Excel97 that gets a value from a cell in one spreadsheet and uses that value to select the value in a pivot table in another sheet. I have used this same code many times and have had no problems with it, but now it is giving me a message "Run Time Error 1004: Unable to set the_Default property of PivotItem class".

Here is my code:

Sub update()
classCell = Worksheets("Class Report&quot.Cells(1, 2)
Sheets("budget_pivot&quot.Select
ActiveSheet.PivotTables("BudgetPivot&quot.PivotFields("class&quot.CurrentPage = classCell
Sheets("Class Report&quot.Select
'ActiveWindow.SelectedSheets.PrintOut Copies:=1
ActiveWindow.SelectedSheets.PrintPreview
End Sub

Any thoughts will be greatly appreciated!

 

[wandan]

Nevermind -- I had an advanced sort on the field so it wouldn't let me update it. Thanks.