Workbook Change when query change
Please help for below, since i dont know how it coud be solved:
1. I have one workbook(created from query) which has 3 field in filter area (Controlling area, cost element, profit center).
2. I changed the query to add one more field to Filter area, this field is Company Code.
3. When i come to workbook and try to refresh, i could not see Company code to be appear in Filter area, Workbook is not changed at all.
I try to test “return query global definition” or “Refresh on Workbook Open”, but Still i could not see Company Code field appear in Filter area of Workbook.
Is there any way to fix the workbook, without change the “Result area”, because “Result Area” has so many format. If we make new Work Book, then all format local will be gone.