the hidden columns of wrokbook will appear when refresh the workbook

Hi,expert.

I create a query,the query has 3 columns,

Fields Name: Col_A, Col_B, Col_C

Fields Value: 1001.....001 ... X

I want to connect the Col_B and Col_C, so I add a column Col_D, like this:

Fields Name: Col_A, Col_B, Col_C, Col_D

Fields Value: 1001 ... 001 .. ..X .... ..001X

and then I hidden Col_B and Col_C in the excel. save the query as a workbook.

When I open the workbook,and refresh it,the hidden Col_B and Col_C were appear.

PLZ tell me how to hide the columns Col_B and Col_C, If I refresh the workbook,they will be hidden either.

My BEX Analyzer version is BI AddOn 7.x(based on 7.10), Support package 8, Revison 1408.

TKS.

Edited by: Bruce Wang on Jul 26, 2010 11:28 AM

Edited by: Bruce Wang on Jul 26, 2010 11:29 AM