1 Reply Latest reply: Aug 18, 2011 12:59 AM by Kaushik Solanki RSS

    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