Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem while saving workbook

Hi All,

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?

Kindly help.

Former Member
Not what you were looking for? View more on this topic or Ask a question