You cannot perform ad hoc analysis on a function-only sheet
I have migrated a client from OACS to Essbase 21c on-premise. They have some Excel workbooks that are built using formulae. On those worksheets, they are unable to switch the connection to the new server. They get an error "You cannot perform ad hoc analysis on a function-only sheet." I have been unable to find a solution. Has anyone encountered this and hopefully found a solution?
Thanks.
Brian