I have a very large excel model (51 sheets, 8.2MB) that works properly stand-alone, but many sheets have references/links to other sheets in the model.
I need to be able to have other users fill out a template (in current large master file) without sending the whole file to them (due to file size and sensitive nature). The template sheet is referencing multiple other sheets in my model.
If I simply copy the template sheet out into a new file and send it, the references will no longer work (since the other user doesnt have the full master file). I considered also copying the two key sheets that the template references to also include in that new, smaller file. This is not ideal, but would work until I try to copy the completed template sheet back into my original master model (because the completed template sheet will then be looking at the other two sheets I copied into the new smaller file).
Is there a way to better manage this? I considered sending the entire model and protecting/passwording sheets the user should not see, but I still have sensitivity concerns. My last resort at this point is having the user complete the template, and then the model owner can copy/paste the data into the master file.
I'm using excel 2003 and windows XP professional.
Thank you in advance for your help!
Lindsay
I need to be able to have other users fill out a template (in current large master file) without sending the whole file to them (due to file size and sensitive nature). The template sheet is referencing multiple other sheets in my model.
If I simply copy the template sheet out into a new file and send it, the references will no longer work (since the other user doesnt have the full master file). I considered also copying the two key sheets that the template references to also include in that new, smaller file. This is not ideal, but would work until I try to copy the completed template sheet back into my original master model (because the completed template sheet will then be looking at the other two sheets I copied into the new smaller file).
Is there a way to better manage this? I considered sending the entire model and protecting/passwording sheets the user should not see, but I still have sensitivity concerns. My last resort at this point is having the user complete the template, and then the model owner can copy/paste the data into the master file.
I'm using excel 2003 and windows XP professional.
Thank you in advance for your help!
Lindsay