Input From Excel and update it and loading into Qlikview 11

[vikasmahajan]

Dear All,

I have excel which is having certains GLS along with some parameters defined we load into qlikview and

deliver some reports in finance , Now problem is that if new GL arrive then we need to update the

excel sheet and then load into qlikview ,

Whether it is possible to give user GRID load all excel sheet as input and user will all/modify / Delete

excel sheet and save the excel through qlikview only not manually.

Whether it is possible in Qlikview Please give valuable suggetions.

Thanks

Vikas

[sushil353]

hi vikas,

Your requirement is not clear.

Could you please add some example or file for better understanding and faster resolution.

As of now the functionality you are talking about can be accomplished using macros.

HTH

Sushil

[vikasmahajan]

Hii Sushil

Thanks for your Input , I have excel file with GL goruping which holds GL and some flags related to PL & BS

when new GL will come or there is some change in schedules then we have to change in excel file, insted of doing in excel file can we load this excel file into qlikview Grid and save the modified chages in excel with revised data.

Please advise. If you have macro for the same can you share please

Vikas