I have one workbook. It's contain one query, let's call it query X. I have change this query and transport it to production system. The problem is there different result between workbook execution (open workbook) and query execution (open query) even it's use same query (it execute in development system). For example, i change query in workbook (global definition), untick checkbox for suppress zero in structure at query X (before is ticked). When i refresh query in this workbook, my query still suppress zero but when i open this query in different sheet (open query), the result is value zero is not suppressed. What makes this happen? It seems, changes on query not have effect when execute workbook but when execute this query alone, the change is displayed...
Thank you and Regards,