Problem while saving workbook
We have created a workbook on a query.
The query is a very simple one, with 4 fields:
1. Sale Order
2. Payment Terms Text (1st 60 chars)
3. Payment Terms Text (61st to 120th chars)
4. Payment Terms Text (121st to 132th chars)
Now, in my workbook, i have used the concatenate formula of excel to combine the 3 Payment Terms fields.
When i go to Workbook Settings -> "Refresh Workbook on Open"; the concatenate formula which was applied is not saved, and the workbook is saved just like the query when executed.
i.e Instead of the 5 fields (Sales Oder, Payment Terms1, Payment Terms 2, Payment Terms 3, Payment Terms Concatenate); the original 4 fields are only displayed .
What could be the problem here?