Problem while saving workbook

[Former Member]

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_member213877]

Hi Apeksha,

As suggested above, you can make use of the VBA code (macros).

Go through this link..

-Pradnya

[Former Member]

Hello,

Did you save as exisiting workbook.

I still think the best way to achieve the requirement is to go with a VB Script. Try to encode a macro to concatenate the needed fields.

Regards

Shashank