Amit,
We had a similar problem a couple of years ago. In our case, we changed the structure in a query and all workbooks using that query started showing the dreaded "No applicable data found" message.
By going to the Local Query tool, we discovered that the structure had been "deactivated" in the workbook, i.e. it was moved to the Free Characteristics section of the query and all key figures were hidden. To resolve this problem, we just moved the structure back to the Columns and unhid the appropriate key figures. After that, rerunning the query gave the correct results, and we were able to resave the workbook without resorting to the delete/reinsert technique.
This approach was much easier, since it preserves all the formatting, etc. of the workbooks. Still a lot of work if you have a lot of workbooks to change, though. In fact, our biggest headache was tracking down all the users who had saved copies of the faulty workbooks as Favorites, and going through the above approach for each of those workbooks.
Hope this helps...
Bob
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.