"In the meantime could you try disabling all your COM and Excel Add-ins except for the sage intelligence related ones (under the excel options - add-ins)?
We have seen some issues with the "solver" add-in and others...
Give that a shot"
Are you trying to set default values for the parameters in the report manager?
If so, Right click on the parameters and choose "properties"
You will see an option to enter default values
From there you can choose if you want…"