Pivot Table parameters in Excel 2007

Hey does anyone know if there is a way to make pivot table parameters reference a cell and not crash the worksheet. Every time i try to do it it looks like its worked, but when i go back and check the parameter config in the connection properties/definition/parameters the cell reference is blank. and if i refresh the table the worksheet crashes

thanks