I created a workbook which I use on a daily basis. One sheet is a template that pulls data from 3 other sheets through a number of array formulas. This data that is pulled is dependent upon the data entered in the first sheet/template. I've been the only one using this for that past few years, but I need to allow other users to access the workbook.

I can't simply share the workbook because I get error messages indicating shared workbooks cannot copy or move array formulas. When I receive this message I'm trying to select data from a drop down box. This drop down box references an array formula based on the data entered into the template and the other sheets. I've tried the work around provided on Microsoft's website, but it doesn't. I also import data into this workbook daily and am afraid sharing it would eventually ruin my workbook.

What are my options? I only need to give access to the first sheet/template, but this template has to pull data from the other sheets. I've tried separating the template from the rest of the workbook, but can't reference external data in data validation in a shared workbook even if I go through named ranges. Is there some way to create an external interface that inputs the data into the template, so that I don't have to share the entire workbook?