Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Need some help in Excel to excel Linking

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


1 Reply

Need some help in Excel to excel Linking


    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.


Kaushik Solanki

Community Browser