Need some help in Excel to excel Linking

Thu, 18 Aug 2011 04:00:27 GMT

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

Need some help in Excel to excel Linking

kaushiknsolanki — Thu, 18 Aug 2011 04:59:17 GMT

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

topic Need some help in Excel to excel Linking in QlikView

Need some help in Excel to excel Linking

Need some help in Excel to excel Linking