Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-08-18 12:00 AM

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

Kedar

484 Views
0 Likes
1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2011-08-18 12:59 AM

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
238 Views
0 Likes