TM1 Forum

Hi All,
I get the error "An invalid argument was encountered" on an active sheet when I hit action button "Rebuild Sheet".
I have unhidden the entire sheet to see if there is a "*KEY_ERR" or any others.
This active sheet updates two cubes. There is a drop down box (with both cube names) and selection of one triggers the values on the sheet to reflect the values of the selected cube. When the cube opens or when values are entered, nothing errors.
Errors only on hitting refresh. Any ideas?
I am on version 9.5.2, 2008 server, excel 2010.

Thanks,
Luther.

Have you put a statement inside the TM1RPTVIEW formula to point it towards the right cube?

Thanks Declan.
When I try to switch the name in the "TM1RPTVIEW" function, the report gets into non responding mode and does not return even after 5 min. Any further help?
Like I said, rest all works fine. when I switch the cube name from dropdown, the values save / change accordingly. Only when I hit refresh when the cursor is on a data element, I get the error.

Thanks,
Luther.