Copying SmartView ad-hoc queries between tabs within the same Excel worksheet
When I use the standard Excel functionality, "Move or Copy..", to create a exact copy of a tab with a ad-hoc query and I attempt to refresh the newly create ad-hoc query, I get an Invalid Free Form Grid message.
I would also like to know how to copy an ad-hoc query for data that linked to Essbase.