Linking a file without giving access to it

[scoscione]

Hi all,

i am new here so before hand thank you for any help you can give it to me.

So I am creating a tool for comparison purposes. i have some data in a different excel file - model 1- and I dont want to give this file to the team because it has sensitive information. So I created a new model - model 2 where i am linking some information from model 1 for comparison.

The problem is I am creating some dropdown list for a dynamic sumif function which is linked to model 1 andit works perfectly but whenever I close model 1, the values immediatelly turn to #value error and I have to reopen it. I want to share this tool but i cant share model 1, is there anyway I can link, use the drop down lists to the dynamic sumif without having an error as a result?

Thank you