Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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