I have an Account "DriverSize" attached to a SmarList. The SmartList contains 3 options (Small, Medium, Large). The value for small is 1, Medium, 2, etc... In SmartView, with a Planning connection, I can use the SmartList to set the value and submit successfully. However, if I try to copy the value of the SmartList (i.e. Small) for Jan and past it across for Feb-Dec......once I Submit Data, my spreadsheet freezes / crashes / etc. I have to restart Excel and also enable the SmartView add-in.
Any ideas? I've tried this on multiple machines and get the same result. I can make an Essbase connection and easily copy/past/submit the data values of the SmartLists (i.e. 1).