Need some help in Excel to excel Linking

[#1]

Hello All,

We are generating an excel document which gets copied to a particular folder  at the time of reload from our qlikview application using a macro.

The excel file is genrating perfectly. But when the users link this excel sheet with their excel sheet & when we refresh the data in our excel by reloading the application, the Data in their excel sheet gets vanished. It throws up an error saying #REF. We have investigated it further & have a clue that it is pertaining to some rights which our exel sheet needs to be given. Kindly guide us to solve this problem.

Thanks & Regards

Kedar

[kaushiknsolanki]

Hi,

    Make sure that the data type of both the columns which you are trying to refer (May be using lookup function), is same.

    As far as i know there should not be any issue with the rights.

    Please give us more clarification what are you actually doing.

Regards,

Kaushik Solanki